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 →Microsoft 365: Permissions by site
This report shows all the site-level permissions for each scanned SharePoint site.
Read more about Microsoft 365: Permissions by site →Content Hash Duplicate File Report
This report uses the file-content-hash feature. The scan policy provides an option to generate file content hashes for All Files or Files uploaded since the last scan. When enabled, AgentFS generates a SHA256 hash of each file's content and stores it in the database, where it can be compared against other files with matching content.
Read more about Content Hash Duplicate File Report →Current NCP Trustees
Create a report that will display all NCP Trustees in eDirectory.
Read more about Current NCP Trustees →Duplicate file across the tenant
This report uses the Microsoft 365 scanning features. The tenant scan prompts Agent365 to collect a hash of each file's content and store it in the database, where it can be compared against other files with matching content.
Read more about Duplicate file across the tenant →