azuregraphazure-active-directoryexchange-servermicrosoft-graph-mail

Mailboxusage report via Graph api gives back hash values

We are trying to get a mailboxusage report from Microsoft Graph API. We are using an azure app registration with application permission Users.Read.All; Reports.Read.All; User.Export.All We also tried those permission as delegated permission.

The report gives the userprincipalname and display name back as hash values like this

B9AEDADB26B6539164C2F9DD6 (not a real one)

Output example

Are we missing an api permission ?

Solution

  • Initially, I too got same results as you with hash values when I tried to fetch mailbox usage report via Graph API like this:

    GET https://graph.microsoft.com/v1.0/reports/getMailboxUsageDetail(period='D7')

    Response:

    enter image description here

    This happens when your tenant is configured to hide user information for all reports.

    To resolve the issue, modify below setting by logging into Microsoft 365 Admin Center as Global Administrator:

    Go to the Microsoft 365 admin center -> Settings -> Org Settings -> Services -> Select Reports -> Uncheck this option -> Save

    enter image description here

    When I ran the same Graph API call again now, I got the results with User principal name and display name successfully like this:

    GET https://graph.microsoft.com/v1.0/reports/getMailboxUsageDetail(period='D7')

    Response:

    enter image description here

    Reference: Microsoft 365 reports show anonymous instead of actual user names