MS Office 365 Data Export

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

Layout:

ELEMENT	DESCRIPTION AND SOURCE FIELD	DATA TYPE	VERSION
username	VOSS Username of the user tied to this O365 service instance. For release 21.3 and later, the data/User.username field mapping is: data/User.username_ms_365 = device/graph/MSOLUser.UserPrincipalName If this field is blank, it means there is not a corresponding data/User for this MSOLUser.	string	v4
first_name	First name of the user device/msgraph/MsolUser.FirstName	string	v4
last_name	Last name of the user device/msgraph/MsolUser.LastName	string	v4
entitlement_profile	Entitlement profile of the user data.User.entitlement_profile of matching data/User	string	v4
o365_username	user name on O365 device/msgraph/MsolUser.UserPrincipalName	string	v4

ELEMENT	DESCRIPTION AND SOURCE FIELD	DATA TYPE	VERSION
display_name	displayed name of user device/msgraph/MsolUser.DisplayName	string	v4
is_licensed	User licensing status device/msgraph/MsolUser.IsLicensed	string	v4
licenses	List of licenses device/msgraph/MsolUser.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",
  "entitlement_profile": "Default-EP",
  "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",
  "entitlement_profile": "Default-EP",
  "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",
  "entitlement_profile": "Default-EP",
  "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",
  "entitlement_profile": "Default-EP",
  "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",
  "entitlement_profile": "Default-EP",
  "o365_username": "[email protected]",
  "licenses": [
    {
      "account_sku_id": "DEVELOPERPACK_E5"
    }
  ],
  "reseller_name": "Resel1",
  "provider_name": "Prov1",
  "customer_name": "Cust1"
}
]