The Tools tab provides access to APTARE IT Analytics Report Template Designers and the File List Export feature.

A: When you create a custom report, you can provide the user with a similar experience to the out-of-the box IT Analytics reports. Then, each time a report is generated from the report template you designed, the user can select parameters to be used for report generation. See Configure SQL Template Scope Selector Components.

A: Queries can serve as a starting point to give you ideas about how to create your own custom queries. In fact, you simply can copy and paste a query from the examples to demonstrate the results in the Report Template Designer. Sample queries include Report on Server Attributes, Failed Backup Job Report, Host Group Membership and Pie Charts for Job Size by Example. See Construct the SQL Query.

A: Yes. Functions can be used to further expand the capabilities of the custom report templates. The functions fall into the following categories: General, Backup Manager, Policy Auditing and Capacity. See Use Functions in Queries.

A: You can choose custom options for a variety of reporting elements. Select the output style, such as table, bar chart or pie chart, the labels, headers and footers, aggregation such as sum, average, and so on. See Format the SQL Template Output.

A: The File List Exporter provides a mechanism for extracting the File Analytics collected metadata into a comma-separated values (.csv) file, enabling further analysis of files that may be wasting storage. Up to 20K rows can be exported to this CSV file. The File List Export window lists the export processes that are currently in progress, as well as those that are available for download. See File List Export.