Control Manager supports modifying saved Ad Hoc Queries from the My Queries tab of the Saved Ad Hoc Queries screen. Modifying a saved Ad Hoc Query requires the following steps:
Step 1: Select the managed product or current Control Manager server for the query
Step 2: Select the Data View to query
Step 3: Specify filtering criteria, and the specific information that displays
Step 4: Save and complete the query
Step 5: Export the data to CSV or XML
The Saved Ad Hoc Queries screen appears.
The Select Product Tree screen appears.
Select Control Manager: Specifies that information originates from the Control Manager server to which the user is currently logged on.
Specifying this option disables the Product Tree, because the information only comes from the Control Manager server to which the user is logged on.
Select Product Tree: Specifies that information originates from the managed products the Control Manager server manages.
After specifying this option, the user must then select the protection category from which the information originates. The user does this by selecting managed products/directories from the Product Directory.
Selecting the managed product/directory on this screen affects the available data views. For example, by selecting OfficeScan in the product directory only data views associated with desktop protection display in the Data Views list.
The Select Data View screen appears.
The Query Criteria screen appears.
Specify the display and sequence for the information the query returns:
The Select Display Sequence screen appears.
Selected columns highlight.
Select the columns one at a time or use the Shift or Ctrl keys to select multiple columns.
Selecting and adding one column at a time is one method that allows users to specify the sequence which the information displays.
Selected columns appear in the Selected Fields list.
The Step 3: Query Criteria screen appears.
When querying for summary data (any data view with the word Summary in the title), you must specify items under Required Criteria.
Specify a Summary Time for the data or whether you want COOKIES to appear in your reports.
The custom criteria options appear.
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.
If you do not specify any filtering criteria, the Ad Hoc Query returns all results for the applicable columns. Trend Micro recommends specifying filtering criteria to simplify data analysis after the information for the query returns.
From the left-most drop-down list, select the column to filter.
From the middle drop-down list, select the matching condition for the filter.
In the right-most field, provide the filter criteria. A list box or text box appears here depending on the column selected to filter.
Click the + icon to add another filter criterion for the data view.
Control Manager supports sharing saved Ad Hoc Queries with other users. Saved queries appear on the Saved Ad Hoc Queries screen.
The Ad Hoc Query Results screen appears displaying the results of the query.
Export to CSV: Exports the query results to CSV format.
Export to XML: Exports the query results to XML format.
Click Open to view the query results immediately in CSV or XML format.
Click Save. A Save As dialog box appears. Specify the location to save the file.