Re: Analyze Metadata for All Unstructured Files in SharePoint and OneDrive Using Microsoft Services

You could try this:

 

1. Content Search to search for each of those properties and generate statistics.

 

Example Query:
(created>2025-01-01)(filetype=docx)(size>1)

https://learn.microsoft.com/en-us/purview/ediscovery-content-search

You can then export a report with the items it found.

 

 

2. Use Auto Labeling Policies based on conditions in Simulation to see what it detects.

https://learn.microsoft.com/en-us/purview/apply-retention-labels-automatically

 

3. Use Microsoft Graph to programmatically enumerate files and extract metadata like:

• • name – file name
  • size – file size (in bytes)
  • file.mimeType – MIME type (e.g., application/pdf)
  • createdDateTime – when the file was created
  • lastModifiedDateTime – when the file was last modified
  • createdBy, lastModifiedBy – user info
  • webUrl – file URL (handy for reference)

https://learn.microsoft.com/en-us/graph/overview

 

I hope that helps!