# SharePoint Online Reports **URL:** \ **Category:** Auditor Discussions & Questions\ **Tags:** auditor, sharepoint-online\ **Created:** [April 1, 2025, 7:18pm UTC](https://community.netwrix.com/t/sharepoint-online-reports/5198 "2025-04-01T19:18:39Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![The.Bob](https://avatars.discourse-cdn.com/v4/letter/t/d9b06d/32.png) [@The.Bob](https://community.netwrix.com/u/The.Bob)\ **Post date:** [April 1, 2025, 7:18pm UTC](https://community.netwrix.com/t/sharepoint-online-reports/5198/1 "2025-04-01T19:18:39Z")
I am looking for 2 specific reports and have not found them, so I thought I would ask the group. First, is there a predefined report to list all sites and also shows last activity? We have many sites. Some probably are not used any longer and they can be removed. Showing site owner would be healpful, but not required. Second, SharePoint access has been granted by user on each site. Again, we have MANY sites. I am trying to put AD groups together and assign by group instead. Is there a report that can show who has access to all sites? ---
**Author:** ![dimav](https://yyz1.discourse-cdn.com/netwrix/user_avatar/community.netwrix.com/dimav/32/249_2.png) [@dimav](https://community.netwrix.com/u/dimav)\ **Post date:** [April 2, 2025, 4:36pm UTC](https://community.netwrix.com/t/sharepoint-online-reports/5198/2 "2025-04-02T16:36:04Z")
@The.Bob hi, thanks for this question! Unfortunately, there’s no way to accomplish this with Auditor currently. Something similar to the second item is available in 1Secure because the reporting structure is a little different there, but not in Auditor. But as you explained your use cases - they make a ton of sense, I’ve added this to our backlog. I cannot give an ETA yet at this point because we still need to discuss this with the team. ---
**Author:** ![The.Bob](https://avatars.discourse-cdn.com/v4/letter/t/d9b06d/32.png) [@The.Bob](https://community.netwrix.com/u/The.Bob)\ **Post date:** [April 2, 2025, 4:43pm UTC](https://community.netwrix.com/t/sharepoint-online-reports/5198/3 "2025-04-02T16:43:56Z")
Unfortunately, I was sold a pile of beans then. The person I spoke to before purchasing said it could be accomplished. Any suggestions as to how I could make something similar that might help me get closer? Even if it’s not exactly what I’m looking for? ---
**Author:** ![dimav](https://yyz1.discourse-cdn.com/netwrix/user_avatar/community.netwrix.com/dimav/32/249_2.png) [@dimav](https://community.netwrix.com/u/dimav)\ **Post date:** [April 2, 2025, 4:48pm UTC](https://community.netwrix.com/t/sharepoint-online-reports/5198/4 "2025-04-02T16:48:54Z")
Sorry to hear that. Let me play around with the reports and I’ll see how to get the maximum maybe with a couple extra steps. If anyone else has any ideas, please feel free to chime in. ---
**Author:** ![The.Bob](https://avatars.discourse-cdn.com/v4/letter/t/d9b06d/32.png) [@The.Bob](https://community.netwrix.com/u/The.Bob)\ **Post date:** [April 2, 2025, 4:56pm UTC](https://community.netwrix.com/t/sharepoint-online-reports/5198/5 "2025-04-02T16:56:19Z")
I could get all of the sites (I think) from within SharePoint Online or somewhere in the portal. The main thing I am looking for is “who has access to what” in SharePoint. I’m envisioning a list that has a site and who has access to it. Grouped by site. If that exists, then I could work with it. ---
**Author:** ![dimav](https://yyz1.discourse-cdn.com/netwrix/user_avatar/community.netwrix.com/dimav/32/249_2.png) [@dimav](https://community.netwrix.com/u/dimav)\ **Post date:** [April 18, 2025, 4:13pm UTC](https://community.netwrix.com/t/sharepoint-online-reports/5198/6 "2025-04-18T16:13:22Z")
Hi Bob, I couldn’t find a way to accomplish more than you could with out of the box reporting. ---
**Author:** ![system](https://yyz1.discourse-cdn.com/netwrix/user_avatar/community.netwrix.com/system/32/3102_2.png) [@system](https://community.netwrix.com/u/system)\ **Post date:** [June 17, 2025, 4:13pm UTC](https://community.netwrix.com/t/sharepoint-online-reports/5198/7 "2025-06-17T16:13:53Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.