Control Manager 5 templates allow greater flexibility for report generation than previous versions of Control Manager templates. Control Manager 5 templates directly access the Control Manager database, providing users the opportunity to create reports based on any information the Control Manager database contains.
Adding a Control Manager 5 custom template requires the following steps:
Access the Add Report Template screen and name the template.
Specify the template component to add to the report template.
Specify the data view for the template.
Specify the query criteria for the template.
Specify the data to appear in the report and the order in which the data appears.
Complete report template creation.
The Report Templates screen appears.
The Add Report Template screen appears.
Static Text: Text a user inserts into the template. This could be a summary of the information that the report presents.
Pie Chart: Report data displays in a pie chart
Bar Chart: Report data displays in a bar chart
Dynamic Table: Report data displays in a table similar to a pivot table
Line Chart: Report data displays in a line chart
Grid Table: Report data displays in a table like an Ad Hoc Query table
The Edit <Report Template Element> Step 1: Data View screen appears.
For every component except Static text, the Edit <Report Template Element> Step 1: Data View screen appears. The Edit link in Static Text opens the Edit Static Text screen.
The Step 2: Set Query Criteria screen appears.
If you do not specify any filtering criteria, the report returns all results for the applicable columns. Trend Micro recommends specifying filtering criteria to simplify data analysis after the information for the report returns.
All of the criteria: This selection acts as a logical AND function. Data appearing in the report must meet all the filtering criteria.
Any of the criteria: This selection acts as a logical OR function. Data appearing in the report must meet any of the filtering criteria.
Depending on the selection for the report element, specify the data to display in reports:
Bar chart
Pie chart
Dynamic table
Grid table
Line chart
The Step 3: Specify Design screen appears.
Data Field: Specifies the data that appears along the vertical axis of the bar chart
Series Field: Specifies additional data that can appear along the horizontal axis
Category Field: Specifies the data that appears along the horizontal axis of the bar chart
Total number of instances: Specifies that the total count for the number of incidents is used for the results
Number of unique instances: Specifies that only the count for distinct items is used for the results
Sum of value: Specifies that the sum of all the values in the "Count" of a Data View column is used for the results
Example: OfficeScan detects 10 virus instances of the same virus on one computer. The Count number of row displays 10, while Count distinct row displays 1.
Aggregation value: Sorts the data according to the data values.
Category name: Sorts the data according to the alphabetic order of the category names.
Ascending: Sorts the data in ascending order.
Descending: Sorts the data in descending order.
The Add Report Template screen appears.
The Step 3: Specify Design screen appears.
Data Field: Specifies the total count for data appearing in the chart
Category Field: Specifies how the data is separated in the chart
Example: To provide a graph that displays virus distribution across your network Data Fields would represent the total number of viruses in your network. Category Fields would represent how the total number of viruses would be broken down as a percentage.
Total number of instances: Specifies that the total count for the number of incidents is used for the results
Number of unique instances: Specifies that only the count for distinct items is used for the results
Sum of value: Specifies that the sum of all the values in the "Count" of a Data View column is used for the results
Example: OfficeScan detects 10 virus instances of the same virus on one computer. The Count number of row would display 10, while Count distinct row displays 1.
Aggregation value: Sorts the data according to the data values.
Category name: Sorts the data according to the alphabetic order of the category names.
Ascending: Sorts the data in ascending order.
Descending: Sorts the data in descending order.
The Add Report Template screen appears.
The Step 3: Specify Design screen appears.
Data Field: Specifies the total count for data appearing in the table
Row Fields: Specifies how the data is separated horizontally in the table
Column Field: Specifies how the data is separated vertically in the table
Example: Olivia selects the Data View "Detailed Virus/Malware Information". She does not specify any filtering criteria. She wants a table that displays infected clients, the viruses infecting the clients, and the action taken against the viruses by the managed product. Olivia drags the following fields to the Data, Row, and Column Fields:
Data Field: Detections
Row Fields: Virus/Malware and Action
Column Field: Host
Total number of instances: Specifies that the total count for the number of incidents is used for the results
Number of unique instances: Specifies that only the count for distinct items is used for the results
Sum of value: Specifies that the sum of all the values in the "Count" of a Data View column is used for the results
Example: OfficeScan detects 10 virus instances of the same virus on one computer. The Count number of row would display 10, while Count distinct row displays 1.
Aggregation value: Sorts the data according to the data values.
Header title: Sorts the data according to the alphabetic order of the header names.
Ascending: Sorts the data in ascending order.
Descending: Sorts the data in descending order.
Aggregation value: Sorts the data according to the data values.
Header title: Sorts the data according to the alphabetic order of the header names.
Ascending: Sorts the data in ascending order.
Descending: Sorts the data in descending order.
The Add Report Template screen appears.
The Step 3: Specify Design screen appears.
Data Field: Specifies the total count for data appearing in the table
Series Field: Specifies how the data is separated in the chart along the vertical axis
Category Field: Specifies how the data is separated in the chart along the horizontal axis
Example: Olivia selects the Data View "Detailed Virus/Malware Information". She does not specify any filtering criteria. She wants a chart that displays virus infections over time. Olivia drags the following fields to the Data, Series, and Category Fields:
Data Field: Detections
Category Field: Generated
Series Field: Virus/Malware
Total number of instances: Specifies that the total count for the number of incidents is used for the results
Number of unique instances: Specifies that only the count for distinct items is used for the results
Sum of value: Specifies that the sum of all the values in the "Count" of a Data View column is used for the results
Example: OfficeScan detects 10 virus instances of the same virus on one computer. The Count number of row would display 10, while Count distinct row displays 1.
Aggregation value: Sorts the data according to the data values.
Category name: Sorts the data according to the alphabetic order of the category names.
Ascending: Sorts the data in ascending order.
Descending: Sorts the data in descending order.
The Add Report Template screen appears.
The Step 3: Specify Design screen appears.
The Add Report Template screen appears.