.. _mso365_data_export:

MS Office 365 Data Export
--------------------------

.. _21.1|VOSS-847:
.. _21.3|EKB-12283:
.. _21.3|EKB-12065:

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

Layout:


.. tabularcolumns:: |p{4.5cm}|p{9cm}|p{1cm}|p{1cm}|

+--------------------------+-------------------------------------------------------+-----------+---------+
| ELEMENT                  | DESCRIPTION AND SOURCE FIELD                          | DATA TYPE | VERSION |
+==========================+=======================================================+===========+=========+
| username                 | username of the user                                  | string    | v4      |
|                          |                                                       |           |         |
|                          | device/msgraph/MsolUser.data/User.username            |           |         |
|                          |                                                       |           |         |
+--------------------------+-------------------------------------------------------+-----------+---------+
| first_name               | First name of the user                                | string    | v4      |
|                          |                                                       |           |         |
|                          | device/msgraph/MsolUser.cache.FirstName               |           |         |
|                          |                                                       |           |         |
+--------------------------+-------------------------------------------------------+-----------+---------+
| last_name                | Last name of the user                                 | string    | v4      |
|                          |                                                       |           |         |
|                          | device/msgraph/MsolUser.cache.LastName                |           |         |
|                          |                                                       |           |         |
+--------------------------+-------------------------------------------------------+-----------+---------+
| o365_username            | user name on O365                                     | string    | v4      |
|                          |                                                       |           |         |
|                          | device/msgraph/MsolUser.cache.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.cache.DisplayName |           |         |
|                                             |                                           |           |         |
+---------------------------------------------+-------------------------------------------+-----------+---------+
| is_licensed                                 | User licensing status                     | string    | v4      |
|                                             |                                           |           |         |
|                                             | device/msgraph/MsolUser.cache.IsLicensed  |           |         |
|                                             |                                           |           |         |
+---------------------------------------------+-------------------------------------------+-----------+---------+
| licenses                                    | List of licenses                          | array     | v4      |
|                                             |                                           |           |         |
|                                             | device/msgraph/MsolUser.cache.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", 
     "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", 
     "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", 
     "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", 
     "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", 
     "o365_username": "user_5@emailaccount.com", 
     "licenses": [
       {
         "account_sku_id": "DEVELOPERPACK_E5"
       }
     ], 
     "reseller_name": "Resel1", 
     "provider_name": "Prov1", 
     "customer_name": "Cust1"
   }
   ]