Small Tricks and Tips – Microsoft 365 administration – Usage reports – how to show / display concealed user, group, and site names in all reports – showing details in usage reports in readable format

fig : Microsoft 365 admin center - Settings - Org settings - Reports - Display concealed user, group and site names in all reports
fig : Microsoft 365 admin center - Settings - Org settings - Reports - Display concealed user, group and site names in all reports

Background

fig : Microsoft 365 administration - all One Drive site report - notice the information - Site URL / Owner Display Name / Owner Principal Name - all are in Ids and not in respective readable format
fig : Microsoft 365 administration – all One Drive sites report – notice the information – Site URL / Owner Display Name / Owner Principal Name – all are in Ids and not in readable format
  • If we notice in above reports, details in reports are not in readable format
  • Site URL, Owner Display Name and Owner Principal Name are in IDs
  • By default all user details are hidden
  • These settings are explicitly applied to help organizations to support their local privacy laws

Steps to update setting – Display user details – site URL, Display Names… in readable format in all usage reports

  • To un-hide the user level details – Global Administrator needs to change the organization level report setting from Microsoft 365 admin center
  • Navigate to Microsoft 365 admin center
  • Navigate to Microsoft 365 admin center either through office 365 portal or from direct URL – https://admin.microsoft.com/
  • From office portal – navigate to URL – https://portal.office.com
  • We have detailed article for navigating to Microsoft 365 admin center – Microsoft 365 – Navigating to Microsoft 365 admin center
  • Once we are on Microsoft 365 admin center, we could navigate to “Settings” section
fig : Microsoft 365 admin center
fig : Microsoft 365 admin center
  • Click on “Settings” section, drop-down will be collapsed, then we could navigate to – organizational settings page
fig : Microsoft 365 admin center - navigating to "Org settings"
fig : Microsoft 365 admin center – navigating to “Org settings”
  • From left pane, click on “Org settings” link, we will be redirected to “Org settings” page / “Services” page
fig : Microsoft 365 admin center - Org settings page
fig : Microsoft 365 admin center – Org settings page
  • Bit scroll down the page to navigate to “Report” settings

  • As shown in above fig, click on “Reports” link. We will be redirected to
fig : Microsoft 365 admin center - Settings >> Org settings >> Reports
fig : Microsoft 365 admin center – Settings >> Org settings >> Reports
  • Uncheck the statement Display concealed user, group, and site names in all reports, and then save changes.
fig : Microsoft 365 admin center - Settings - Org settings - Reports - Display concealed user, group and site names in all reports
fig : Microsoft 365 admin center – Settings – Org settings – Reports – Display concealed user, group and site names in all reports
  • As we update this setting, we will be see the details in respective reports in readable format as shown in below fig – we are again exporting all One Drive sites after changing the setting
fig : Microsoft 365 admin - Usage report - exported One Drive sites - Information is readable format - display concealed use, group and site names
fig : Microsoft 365 admin – Usage report – exported One Drive sites – Information is readable format – display concealed use, group and site names

Permissions required to update the setting – display concealed user, group, and site names in all reports

  • Global Administrator

Graph API for updating report settings – https://graph.microsoft.com/beta/admin/reportSettings – I’ll cover detailed next article on this

Thanks for reading. HAVE A FANTASTIC LEARNING AHEAD!!!

Prasham Sabadra

LIFE IS VERY BEAUTIFUL. ENJOY THE WHOLE JOURNEY :) Founder of Microsoft 365 Junction, Speaker, Author, Learner, Developer, Passionate Techie. Certified Professional Workshop Facilitator / Public Speaker. Believe in knowledge sharing. Around 20+ years of total IT experience and 17+ years of experience in SharePoint and Microsoft 365 services Please feel free me to contact for any SharePoint / Microsoft 365 queries. I am also very much interested in behavioral (life changing) sessions like motivational speeches, Success, Goal Setting, About Life, How to live Life etc. My book - Microsoft 365 Power Shell hand book for Administrators and Beginners and 100 Power Shell Interview Questions - https://www.amazon.in/Microsoft-Administrators-Beginners-Interview-Questions/dp/9394901639/ref=tmm_pap_swatch_0?_encoding=UTF8&qid=1679029081&sr=8-11

You may also like...

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.