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 →Sharing Links by User Drive
Find sharing links across OneDrive for Business drives, surfacing cases where employees may be sharing company intellectual property with little regard for security.
Read more about Sharing Links by User Drive →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 →Sharing Links by User Drive
Find sharing links across OneDrive for Business drives, surfacing cases where employees may be sharing company intellectual property with little regard for security.
Read more about Sharing Links by User Drive →Current NCP Trustees
Create a report that will display all NCP Trustees in eDirectory.
Read more about Current NCP Trustees →File Extensions Media Categories
This is a file-extension report that displays fullpath, filename, size, owner, scan_target, and file_extension from the srs.current_fs_scandata database view and is limited to current scan data.
Read more about File Extensions Media Categories →Files Renamed by Ransomware
Identify potentially affected files based on typical file extensions added by various ransomware variants.
Read more about Files Renamed by Ransomware →Files with long names
Find filenames longer than a chosen length threshold. Long filenames frequently cause problems during migrations between platforms (for example, Open Enterprise Server to Windows Server), with backup tools, and with downstream applications that enforce path-length limits.
Read more about Files with long names →Files without owners in Open Enterprise Server
Find files in an eDirectory scan target where the owner cannot be resolved to a Fully Distinguished Name — owner is NULL, [Nobody], [Supervisor], or [Unknown].
Read more about Files without owners in Open Enterprise Server →