SharePoint Sites/Files Discovery Report

An M365 SharePoint Sites and Files Discovery Report.

Getting a full list of every file in your organizations' Share Point environment can be difficult via the normal consoles and reports. What I put together here is a scripted way to attach to the tenant and export both a Site Collection report and a Site File Report showing all the details you need to know.

The Site Collection report shows the main details for each of the sites including.

• Title
• Owner
• Status
• Storage Used(MB)
• Storage Quota(MB)
• URL
• Last Content Modified
• Teams Connected?
• Teams Channel Connected?

From this you can get a great overview of the SharePoint landscape, including the sites that are part of a Teams connected backend. 

In addition to this, I have added a separate report that details all of the file information in each of the Site Collections as well. This provides the following data.

• Site Collection
• Item Type
• Directory
• Filename
• File ID
• File Type
• Relative URL
• Created By/Created Time
• Modified By/Modified Time
• File Size (MB)
• Checked Out User - (if checked out)
• Unique Permissions

The Site Library Report is produced also and contain the following information on all of the Document Libraries in the SharePoint environment.

• SPO Site
• SPO Site URL
• Library Title
• Type
• Access to Site
• Is Catalog
• Created Date
• Document Count
• Document Size (MB)
• URL
• Default View URL
• Item Count
• Last Item User Modified Date
• ParentWebURL
• ID
• Is Private

All the reports that are created are output in both a CSV and XLSX format. The XLSX file is created in a way you can instantly use it to provide a solid and functional base to any filtering, pivot table or user permission lookup that you need.

Please look at the website - https://thecloudgeezer.com - for full instructions on how to use and run it all.

The YouTube channel for The Cloud Geezer can be found here - https://youtube.com/thecloudgeezer

Mark - The Cloud Geezer - mark@thecloudgeezer.com