MS Office 365 Data Export

Filename: <YYYY-MM-DD_HHMM>_ms_o365.json.gz

Layout:

ELEMENT

DESCRIPTION AND SOURCE FIELD

DATA TYPE

VERSION

username

username of the user

device/msgraph/MsolUser.data/User.username

or

device/azureadonline/MsolUser.data/User.username

string

v4

first_name

First name of the user

device/msgraph/MsolUser.cache.FirstName

or

device/azureadonline/MsolUser.cache.FirstName

string

v4

last_name

Last name of the user

device/msgraph/MsolUser.cache.LastName

or

device/azureadonline/MsolUser.cache.LastName

string

v4

o365_username

user name on O365

device/msgraph/MsolUser.cache.UserPrincipalName

or

device/azureadonline/MsolUser.cache.UserPrincipalName

string

v4

ELEMENT

DESCRIPTION AND SOURCE FIELD

DATA TYPE

VERSION

display_name

displayed name of user

device/msgraph/MsolUser.cache.DisplayName

or

device/azureadonline/MsolUser.cache.DisplayName

string

v4

is_licensed

User licensing status

device/msgraph/MsolUser.cache.IsLicensed

or

device/azureadonline/MsolUser.cache.IsLicensed

string

v4

licenses

List of licenses

device/msgraph/MsolUser.cache.Licenses

or

device/azureadonline/MsolUser.cache.Licenses

array

v4

licenses.account_sku_id

license SKUId

licenses.AccountSkuId

string

v4

Example

[
{
  "username": "user_1",
  "first_name": "FirstName_1",
  "last_name": "LastName_1",
  "display_name": "DisplayName_user_1",
  "hierarchy": "sys.A242BC6E4F94.Prov1.Resel1.Cust1",
  "is_licensed": "N",
  "o365_username": "[email protected]",
  "licenses": [
    {
      "account_sku_id": "DEVELOPERPACK_E5"
    }
  ],
  "reseller_name": "Resel1",
  "provider_name": "Prov1",
  "customer_name": "Cust1"
},
{
  "username": "user_2",
  "first_name": "FirstName_2",
  "last_name": "LastName_2",
  "display_name": "DisplayName_user_2",
  "hierarchy": "sys.A242BC6E4F94.Prov1.Resel1.Cust1",
  "is_licensed": "N",
  "o365_username": "[email protected]",
  "licenses": [
    {
      "account_sku_id": "DEVELOPERPACK_E5"
    }
  ],
  "reseller_name": "Resel1",
  "provider_name": "Prov1",
  "customer_name": "Cust1"
},
{
  "username": "user_3",
  "first_name": "FirstName_3",
  "last_name": "LastName_3",
  "display_name": "DisplayName_user_3",
  "hierarchy": "sys.A242BC6E4F94.Prov1.Resel1.Cust1",
  "is_licensed": "N",
  "o365_username": "[email protected]",
  "licenses": [
    {
      "account_sku_id": "DEVELOPERPACK_E5"
    }
  ],
  "reseller_name": "Resel1",
  "provider_name": "Prov1",
  "customer_name": "Cust1"
},
{
  "username": "user_4",
  "first_name": "FirstName_4",
  "last_name": "LastName_4",
  "display_name": "DisplayName_user_4",
  "hierarchy": "sys.A242BC6E4F94.Prov1.Resel1.Cust1",
  "is_licensed": "N",
  "o365_username": "[email protected]",
  "licenses": [
    {
      "account_sku_id": "DEVELOPERPACK_E5"
    }
  ],
  "reseller_name": "Resel1",
  "provider_name": "Prov1",
  "customer_name": "Cust1"
},
{
  "username": "user_5",
  "first_name": "FirstName_5",
  "last_name": "LastName_5",
  "display_name": "DisplayName_user_5",
  "hierarchy": "sys.A242BC6E4F94.Prov1.Resel1.Cust1",
  "is_licensed": "N",
  "o365_username": "[email protected]",
  "licenses": [
    {
      "account_sku_id": "DEVELOPERPACK_E5"
    }
  ],
  "reseller_name": "Resel1",
  "provider_name": "Prov1",
  "customer_name": "Cust1"
}
]