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 |
string |
v4 |
first_name |
First name of the user device/msgraph/MsolUser.cache.FirstName |
string |
v4 |
last_name |
Last name of the user device/msgraph/MsolUser.cache.LastName |
string |
v4 |
o365_username |
user name on O365 device/msgraph/MsolUser.cache.UserPrincipalName |
string |
v4 |
ELEMENT |
DESCRIPTION AND SOURCE FIELD |
DATA TYPE |
VERSION |
|---|---|---|---|
display_name |
displayed name of user device/msgraph/MsolUser.cache.DisplayName |
string |
v4 |
is_licensed |
User licensing status device/msgraph/MsolUser.cache.IsLicensed |
string |
v4 |
licenses |
List of licenses device/msgraph/MsolUser.cache.Licenses |
array |
v4 |
licenses.account_sku_id |
license SKUId licenses.AccountSkuId |
string |
v4 |
licenses.disabled_serviceplans |
List of disabled service plans Licenses.X.ServicePlans |
array |
v4 |
licenses.disabled_serviceplans.Service_Name |
Disabled service plan name Licenses.X.ServicePlans.X.ServiceName where Enabled is False |
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"
"disabled_serviceplans": [
{
"Service_Name": "AAD_PREMIUM"
}
]
}
],
"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"
}
]