Find files where the owners are unresolveable SIDs
Submitted by rlagger on Thu, 11/01/2018 - 11:02Find files where the owner is an unresolved or orphaned SID. Just change the scan_target line to make the query work for your environment.
4.0
Summary with Quota and Owner
Submitted by richlagger on Tue, 07/14/2015 - 09:45Background
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.
Note: This query is written for Active Directory and can be modified for use with eDirectory.
Find Files Renamed By The Crypto or Wanna Cry Ransomware Viruses
Submitted by richlagger on Wed, 03/04/2015 - 15:25Summary
Over the past few years computer systems everywhere have been dealing with ransomeware viruses. Crypo, Wanna Cry, and others have hit networks all over the world. How can I find these infected files, so I can restore them from back up?
File Extension Find Media Formats
Submitted by richlagger on Wed, 03/04/2015 - 10:31Summary
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.
Although, this query is written to report on media based file extensions, line 16, can be modified to any set of file extensions needed.