Introduction
This site provides SQL queries and report templates for use with the Galileo and File Reporter file system analysis products.
See the How-to Guides for instructions on how to import and use the provided queries and reports from the Recipes page.
Recent updates
Power BI
Power BI reporting — early access
Starting with the 24.2 release of Galileo and File Reporter, we have introduced Early Access integration support for Power BI reporting.
Read more about Power BI →Summary with Quota and Owner
Summarize file and folder counts per user, along with quota allocated and quota consumed, for the folders under a given path.
Read more about Summary with Quota and Owner →Microsoft 365: Duplicate files
This report scans for truly duplicated files in Microsoft 365. The content hash collected from each file allows duplicates to be found and remediated.
Read more about Microsoft 365: Duplicate files →Microsoft 365: Filename extensions
This filename extension report scans your Microsoft 365 tenant to help you see what applications are being used, based on the filename extensions present.
Read more about Microsoft 365: Filename extensions →Microsoft 365: Teams chat files
This report finds files stored in Teams chat locations within Microsoft 365.
Read more about Microsoft 365: Teams chat files →