Name: Microsoft Licence Summary
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Microsoft Licence Summary

A summary list of Microsoft licenses.
Publisher name: Leeds City Council
Last updated: 2022-07-01T04:02:59Z

Tables

11/04/2018

@ukgov.microsoft_licence_summary.n_11_04_2018

9.41 kB
291 rows
6 columns

CREATE TABLE n_11_04_2018 (
  "product_pool" VARCHAR,
  "license_product_family" VARCHAR,
  "license_version" VARCHAR,
  "effective_quantity" BIGINT,
  "unresolved_quantity" BIGINT,
  "active_sa_quantity" BIGINT
);

11/04/2018 (Microsoft Comparex)

@ukgov.microsoft_licence_summary.n_11_04_2018_microsoft_comparex

5.07 kB
37 rows
5 columns

CREATE TABLE n_11_04_2018_microsoft_comparex (
  "group" VARCHAR,
  "edition_version" VARCHAR  -- Edition + Version,
  "type" VARCHAR,
  "start_effective_date" TIMESTAMP,
  "end_effective_date" TIMESTAMP
);

21/12/2016

@ukgov.microsoft_licence_summary.n_21_12_2016

9.31 kB
282 rows
6 columns

CREATE TABLE n_21_12_2016 (
  "product_pool" VARCHAR,
  "license_product_family" VARCHAR,
  "license_version" VARCHAR,
  "effective_quantity" BIGINT,
  "unresolved_quantity" BIGINT,
  "active_sa_quantity" BIGINT
);

30/07/2015

@ukgov.microsoft_licence_summary.n_30_07_2015

8.9 kB
245 rows
6 columns

CREATE TABLE n_30_07_2015 (
  "product_pool" VARCHAR,
  "license_product_family" VARCHAR,
  "license_version" VARCHAR,
  "effective_quantity" BIGINT,
  "unresolved_quantity" BIGINT,
  "active_sa_quantity" BIGINT
);