Lifecycle Insights integrates directly with Microsoft 365 via the Microsoft Graph API. When we sync (pull) data directly from MS 365, we will load data into one of two places. First, we provide you with a summary level report called Microsoft 365, which indicates by product the number of licenses available, consumed, and suspended. This report can be found under MSP Reports and it is called Microsoft 365.
The second place we load Microsoft 365 data is in the User List. The purpose of this document is to review the Microsoft 365 columns in the User List.
If we have successfully sync'd Microsoft 365 data for a particular company, 5 additional columns will be available in the User List. Those columns are:
- Microsoft 365 (Indicates if User is in MS 365)
- Microsoft 365 Assigned Products
- Microsoft 365 Last Activity Date
- Microsoft 365 MFA Status**
- Microsoft365 Authentication Methods**
** The MS365 API will only return per user MFA data when client has Azure Active Directory Premium P1 license or higher
Now let's take a look at the source of the data. All data comes from Microsoft's Graph API. We use two of the API endpoints to retrieve the data. See the table below for details:
| Column | MS Graph API | Notes | Data 'Freshness'*** |
| Microsoft 365 | https://docs.microsoft.com/en-us/graph/api/reportroot-getoffice365activeuserdetail?view=graph-rest-1.0 | Pull any users with activity in last 180 days | As of Last Refresh Date Listed in User List Report*** |
| Microsoft 365 Assigned Products | https://docs.microsoft.com/en-us/graph/api/reportroot-getoffice365activeuserdetail?view=graph-rest-1.0 | Pull any users with activity in last 180 days | As of Last Refresh Date Listed in User List Report*** |
| Microsoft 365 Last Activity Date | https://docs.microsoft.com/en-us/graph/api/reportroot-getoffice365activeuserdetail?view=graph-rest-1.0 | Pull any users with activity in last 180 days. Pull latest activity date | As of Last Refresh Date Listed in User List Report*** |
| Microsoft 365 MFA Status | https://docs.microsoft.com/en-us/graph/api/resources/credentialuserregistrationdetails?view=graph-rest-beta | MS API Endpoint in Beta. Must have premium license | As of last sync |
| Microsoft 365 Authentication Methods | https://docs.microsoft.com/en-us/graph/api/resources/credentialuserregistrationdetails?view=graph-rest-beta | MS API Endpoint in Beta. Must have premium license | As of last sync |
*** The MS Graph endpoint used to determine if user is in MS 365, the Assigned Products and Last Activity Date does NOT provide data in real time. It is typically anywhere from 1 to 5 days behind. The data in LCI will be as of the Last Refresh Date listed in the User List report.