How to get a list of all users and the browsers they use to access our SharePoint Online sites?

Question

Hi there
How to get a list of all users and the browsers they use to access our SharePoint Online sites?
Is there any PowerShell or other way?
Thanks.

Answer 1

Hello there!

There is the Audit Log Feature where you can audit log users' activities such as "FileAccessed" or "PageViewed" (you can search for more than 1 at a time) and it is possible to check the client used to see or do the activity. I'll leave some articles that describe how to do it and that provide more details:

• https://learn.microsoft.com/en-us/microsoft-365/compliance/search-the-audit-log-in-security-and-compliance?view=o365-worldwide#search-the-audit-log
• https://learn.microsoft.com/en-us/microsoft-365/compliance/search-the-audit-log-in-security-and-compliance?view=o365-worldwide#audited-activities
• https://learn.microsoft.com/en-us/microsoft-365/compliance/detailed-properties-in-the-office-365-audit-log?view=o365-worldwide
• https://learn.microsoft.com/en-us/microsoft-365/compliance/export-view-audit-log-records?view=o365-worldwide

You can also create a report to detail each user/group permission but it does not show the browser or client used:

• https://learn.microsoft.com/en-us/sharepoint/sharing-reports

There are some requirements too or limitations about the M365 Audit Logs so I'll recommend checking the following section too:

• https://learn.microsoft.com/en-us/microsoft-365/compliance/search-the-audit-log-in-security-and-compliance?view=o365-worldwide#frequently-asked-questions

I hope this helps,
-DF