question

NickLCI-4603 avatar image
0 Votes"
NickLCI-4603 asked NickLCI-4603 commented

getOffice365ActiveUserDetail with period parameter no longer working

Starting the night of August 30th, the REST API endpoint: https://graph.microsoft.com/v1.0/reports/getOffice365ActiveUserDetail(period='D30') is no longer working. Tried all the different options for period value (D7,D90,D180). This endpoint has been working without issue for as long as we've been using it (going back almost 2 years)

By no longer working, the status_code being returned is 200 - and the csv is being returned with column headers, but no user data is included.

Note that using the date parameter is working as expected (returning column headers and data): https://graph.microsoft.com/v1.0/reports/getOffice365ActiveUserDetail(date=2021-08-10)

microsoft-graph-reports
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JamesMoran-4607 avatar image
0 Votes"
JamesMoran-4607 answered

Ive also noted this issue but struggling to find any information as to why - looks to be also affecting OneDriveStorage reports also

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NickLCI-4603 avatar image
0 Votes"
NickLCI-4603 answered

As an update to this, the endpoint https://graph.microsoft.com/v1.0/reports/getOffice365ActiveUserDetail(period='D30') is now returning data, however the User Principal Name and Display Name are being returned as de-identified so the information is not useful. Note that using the date parameter - the data is now also de-identified - and this wasn't the case yesterday.

De-identified, meaning instead of user@email.com, we are receiving a value like: 3291XX15F80EE0D0DFEAF23D01BE0F36

Not sure if this is a setting introduced that we have to adjust, or if it is an issue with endpoint. Does anyone have any ideas?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JamesMoran-4607 avatar image
0 Votes"
JamesMoran-4607 answered NickLCI-4603 commented

Ah glad it is returning data-

The blank data looks to be related to this change posted 2 days ago - not quite sure how can make such a large change with little notice

https://techcommunity.microsoft.com/t5/microsoft-365-blog/privacy-changes-to-microsoft-365-usage-analytics/ba-p/2694137

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for referencing this @JamesMoran-4607 . I have also been notified of this incident:

MO282045:

Title: Admins may see no data for specific reports after August 31, 2021

User Impact: Admins may see no data for specific reports after August 31, 2021.

More info: Impacted reports (both admin center usage reports and when requesting via Graph API) include:

-OneDrive Activity Report. -OneDrive Site Usage Report. -SharePoint Activity Report. -SharePoint Site Usage Report. -ProplusUsage Report. -Forms Report. -FormPro Report. -LicenseActivity Report (also known as Active User Usage Report). -MultiGeo Report. -Power BI Report. -Exchange Activity Report. -Email Activity Report.

Current status: We've identified an upstream data issue associated with loading tenant profile and usage report data. We're developing on a fix to remediate impact.

Scope of impact: This issue may impact admins running any of the listed reports from August 31, 2021.

Root cause: An upstream data issue associated with loading tenant profile and usage report data, is providing unexpected results for specific reports.

Next update by: Thursday, September 2, 2021, 11:00 AM (9:00 AM UTC)

0 Votes 0 ·