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

Submitted by darnold on

Power BI Reporting - Early Access

Power BI Sample

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 →

Find long file names in eDirectory

Submitted by rlagger — Updated:

A customer asked for a query to find filenames that are too long, and might cause issues when migrating files from eDirectory to AD.

Read more about Find long file names in eDirectory →

Current NTFS ACEs Without Inheritance

Submitted by rlagger — Updated:

How when using the srs.current_ntfs_aces view can I report on the ACEs without inheritance?

Read more about Current NTFS ACEs Without Inheritance →

File Extension Find Media Formats

Submitted by richlagger — Updated:

This is file extension report that displays the 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 Extension Find Media Formats →

MS365 Permissions by Site

Submitted by rlagger — Updated:

New with version 4.0 is ability to scan and report on permissions and sharing within Microsoft 365.

Read more about MS365 Permissions by Site →