File Query Cookbook

Welcome to the File Query Cookbook

Select your product to see relevant content.

You can change this anytime from the site options in the header.

File Query Cookbook
Site Configuration

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 →

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:

This report shows all the site-level permissions for each scanned SharePoint site.

Read more about MS365 Permissions by Site →

NTFS ACEs Without Inheritance

Submitted by rlagger — Updated:

Report on ACEs without inheritance using the srs.current_ntfs_aces view.

Read more about NTFS ACEs Without Inheritance →