Creating an Ad Hoc Query

Ad hoc query reports give administrators the ability to create reports quickly from the Control Manager database. The reports provide the raw data many administrators require for their day to day tasks.

To create an ad hoc query report:

  1. Access the Ad Hoc Reports screen and specify the data scope.

    1. Mouseover Logs/Reports in the main menu. A drop down menu appears.

    2. Select New Ad Hoc Query from the drop down menu. The Step 1: Data Scope screen appears.

    3. From the New Ad Hoc Query screen, select the origin for the information query:

    4. 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 Directory, 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 Product Directory.

    1. 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 Available Data Views list.

      You will still have to specify filtering criteria (Managed Product Name > is equal to > OfficeScan) to return data only from OfficeScan servers.

    2. Click Next. The Step 2: Data View screen appears.

  2. Specify the Data View for the query.

    1. Select the data to query from the Available Data Views area.

    2. Click Next. The Step 3: Query Criteria screen appears.

  3. Specify the data to appear in the returned query and the order in which the data appears.

    Items appearing at the top of the Selected Fields list appear as the left most column of the table. Removing a field from Selected Fields list removes the corresponding column from the Ad Hoc Query returned table.

    1. Click Change column display. The Select Display Sequence screen appears.

    2. Specify the data to display in the report:

    1. Select a query from the Available Fields list. The selected item highlights.

      Select multiple items using the Shift or Ctrl keys.

    2. Click to add items to the Selected Fields list.

    3. Specify the order in which the data displays by selecting the item/items and clicking or .

    1. Click Back. The Query Criteria screen appears.

  4. Specify the filtering criteria for the query.

    When querying for summary data (any data view with the word Summary in the title), you must specify items under Required Criteria.

    1. Specify the Required Criteria:

    • Specify a Summary Time for the data or whether you want COOKIES to appear in your reports.

    1. Specify the Custom Criteria:

    1. Select Custom criteria. The custom criteria options appear.

    2. Specify the criteria filtering rules for the data categories:

    • 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.

    • Specify the filtering criteria for the data. Control Manager supports specifying up to 20 criteria for filtering data.

    • 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.

  5. Save and complete the query.

    1. To save the query:

    1. Click Save this query to the saved Ad Hoc Queries list.

    2. Type a name for the saved query in the Query Name field.

    1. Click Query. The Results screen appears.

  6. Analyse or export the report.

    1. To save the report to CSV:

    1. Click Export to CSV. A dialog box appears.

    2. Click Save. A Save as dialog box appears.

    3. Specify the location to save the file.

    4. Click Save.

    1. To save the report to XML:

    1. Click Export to XML. A dialog box appears.

    2. Click Save. A Save as dialog box appears.

    3. Specify the location to save the file.

    4. Click Save.

    5. To query more results on a single screen select a different value in Rows per page. A single screen can display 10, 15, 30, or 50 query results per page.

    1. To save the settings for the query:

    1. Click Save query settings. A confirmation dialog box appears.

    2. Type a name for the saved query in the Query Name field.

    3. Click OK. The saved query appears on the Saved Ad Hoc Queries screen.