Customized Query Reports

Query the SQL database to extract and present the exact information you want in a report.

Even though File Reporter provides an extensive set of built-in reports, there might be instances where you need very specific information that is not provided in any of the built-in reports. Custom Query reports let you specify what you want included in your report through a series of SQL commands that you enter.

Custom Query reports use the same file system and permissions scans used to create built-in reports, but limit the reported content to the conditions of the SQL commands. With Custom Query reports, it's even possible to include data from two different types of scans, a file system scan and a permissions scan.

Once generated, you can design the Custom Query Report using the Report Designer. You can also utilize File Query Cookbook as a resource for obtaining SQL commands and sample report layouts that have been submitted by the File Reporter community. Both the SQL commands and report layouts can be customized as needed. You can access the File Query Cookbook directly through the Report Designer interface, or at http://www.filequerycookbook.com.