.. _mso365_data_export: MS Office 365 Data Export -------------------------- .. _21.1|VOSS-847: .. _21.3|EKB-12283: .. _21.3|EKB-12065: .. _21.4-PB1|EKB-14929: .. _21.4-PB1|EKB-14921: Filename: ``_ms_o365.json.gz`` Layout: .. tabularcolumns:: |p{4.5cm}|p{9cm}|p{1cm}|p{1cm}| +---------------------+------------------------------------------------------------------------------------------------+-----------+---------+ | ELEMENT | DESCRIPTION AND SOURCE FIELD | DATA TYPE | VERSION | +=====================+================================================================================================+===========+=========+ | username | VOSS Username of the user tied to this O365 service instance. | string | v4 | | | | | | | | 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. | | | +---------------------+------------------------------------------------------------------------------------------------+-----------+---------+ | first_name | First name of the user | string | v4 | | | | | | | | device/msgraph/MsolUser.FirstName | | | | | | | | +---------------------+------------------------------------------------------------------------------------------------+-----------+---------+ | last_name | Last name of the user | string | v4 | | | | | | | | device/msgraph/MsolUser.LastName | | | | | | | | +---------------------+------------------------------------------------------------------------------------------------+-----------+---------+ | entitlement_profile | Entitlement profile of the user | string | v4 | | | | | | | | data.User.entitlement_profile of matching data/User | | | | | | | | +---------------------+------------------------------------------------------------------------------------------------+-----------+---------+ | o365_username | user name on O365 | string | v4 | | | | | | | | device/msgraph/MsolUser.UserPrincipalName | | | | | | | | +---------------------+------------------------------------------------------------------------------------------------+-----------+---------+ .. tabularcolumns:: |p{4.5cm}|p{9cm}|p{1cm}|p{1cm}| +---------------------------------------------+---------------------------------------+-----------+---------+ | ELEMENT | DESCRIPTION AND SOURCE FIELD | DATA TYPE | VERSION | +=============================================+=======================================+===========+=========+ | display_name | displayed name of user | string | v4 | | | | | | | | device/msgraph/MsolUser.DisplayName | | | | | | | | +---------------------------------------------+---------------------------------------+-----------+---------+ | is_licensed | User licensing status | string | v4 | | | | | | | | device/msgraph/MsolUser.IsLicensed | | | | | | | | +---------------------------------------------+---------------------------------------+-----------+---------+ | licenses | List of licenses | array | v4 | | | | | | | | device/msgraph/MsolUser.Licenses | | | | | | | | +---------------------------------------------+---------------------------------------+-----------+---------+ | licenses.account_sku_id | license SKUId | string | v4 | | | | | | | | licenses.AccountSkuId | | | +---------------------------------------------+---------------------------------------+-----------+---------+ | licenses.disabled_serviceplans | List of disabled service plans | array | v4 | | | | | | | | Licenses.X.ServicePlans | | | +---------------------------------------------+---------------------------------------+-----------+---------+ | licenses.disabled_serviceplans.Service_Name | Disabled service plan name | string | v4 | | | | | | | | Licenses.X.ServicePlans.X.ServiceName | | | | | where Enabled is False | | | | | | | | +---------------------------------------------+---------------------------------------+-----------+---------+ 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": "user_1@emailaccount.com", "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": "user_2@emailaccount.com", "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": "user_3@emailaccount.com", "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": "user_4@emailaccount.com", "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": "user_5@emailaccount.com", "licenses": [ { "account_sku_id": "DEVELOPERPACK_E5" } ], "reseller_name": "Resel1", "provider_name": "Prov1", "customer_name": "Cust1" } ]