Details

This report combines file extensions in to categories. The report uses the srs.current_fs_scandata database view which limits the scope to current scans only. The scope is further limited by the sd.fullpath LIKE portion of the sql where clause. If you remove it, the report will run across all current scan_data.

This recipes comes in two versions, a Detailed version and a Summary version.

You will need to modify the path line 32 of the desired query.

Summary

New with version 4.0 is ability to scan your Microsoft 365 tenant for SharePoint Online document libraries, OneDrive for Business drives, and Teams document libraries.  This query helps you located duplicate files across user OneDrives.

The purpose for including some queries to provide examples that can be used to make queries that better suit the needs of the administrators.

Summary

This report utilizes the new added file content hash feature of version 4.0.  The 4.0 scan policy definition gives a new option to Generate file content hashes for All Files or Files uploaded since the last scan.  This option prompts the AgentFS to generate a SHA256 hash of the file content and store the hash in the database where it can be compared against other files that match in content.

Details

Line 10 contains the paths to be reported against.  Modify these paths appropriate to your environment.

This code finds files within a scan target where the owner is either NULL, [Nobody], [Supervisor], or [UNKNOWN] instead of an FDN in eDirectory.

Find files where the owner is an unresolved or orphaned SID.  Just change the scan_target line to make the query work for your environment.

Background

A customer needed to create a report for management that shows the file and folder counts, the users quota, and how much of their quota was being used. This customer wanted all empty directories to be ignored.

This custom query shows a summary of the folders in the path provided on line 7. The report summaries the file and folder counts, size used, the quota value set, and the quota remaining.

A customer asked for a query to find filenames that are too long, and might cause issues when migrating files from eDirectory to AD. The customer requested that query find filenames longer than 128 characters. The filename length to be reported by changing line 12, and the scope can limited by adding sd.scan_target = '\\server\share' to the where clause. 

Note: If you have downloaded an older version of the is query and have moved to version 3.5 of the product, the old active_fs_scandata views have been replaced with current_fs_scandata.