Introduction

This site provides SQL queries and report templates for use with the Galileo and OpenText 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

How to Import a Custom Query

Submitted by darnold on Wed, 04/29/2015 - 15:48

Download the zip file containg the SQL query and/or Report Layout (repx) file.
Extract the zip contents to a local folder.
The SQL file can be opened with a text editor, and its contents copied and pasted to the either the Custom Query SQL editor using either the Web interface (figure 1) or in the Report Designer (figure 2) for a given Custom Query report definition.

Find Files Renamed By The Crypto or Wanna Cry Ransomware Viruses

Submitted by richlagger on Wed, 03/04/2015 - 15:25

Summary

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:31

Summary

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.