Product guide
Working with queries
Use these tasks to create, use, and manage queries.
Tasks
Creating custom queries
Running an existing query
Running a query on a schedule
Making personal queries public
Duplicating queries
Sharing a query between ePO servers
Creating custom queries
Use this task to create custom queries with the Query Builder wizard. You can query on system
properties, product properties, many of the log files, repositories, and more.
Task
For option definitions, click ? on the page displaying the options.
1 Go to Reporting | Queries, then click New Query. The Result Type page of the Query
Builder wizard appears.
2 Select the data type for this query. This choice determines the options available on
subsequent pages of the wizard.
3 Click Next. The Chart page appears.
4 Select the type of chart or table to display the primary results of the query. Depending on
the type of chart, there are different configuration options available.
5 Click Next. The Columns page appears.
6 Select the properties from the Available Columns list that you want as columns in the
results table, then order them as desired with the arrow icons on the column headers.
NOTE: If you select Table on the Chart page, the columns you select here are the columns
of that table. Otherwise, these are the columns of the drill-down table.
7 Click Next. The Filter page appears.
8 Select properties to narrow the search results. Selected properties appear in the content
pane with operators to specify criteria to narrow the data that is returned for that property.
Ensure your choices provide the data to display in the table columns configured in the
previous step.
9 Click Run. The Unsaved Query page displays the results of the query, which is actionable,
so you can take any available actions on items in any tables or drill-down tables.
• If this is a query you want to use again, click Save to add it to your My Queries list.
• If the query didn’t appear to return the expected results, click Edit Query to go back
to the Query Builder and edit the details of this query.
• If you don’t need to save the query, click Close.
Querying the Database
Working with queries
McAfee Policy Auditor 5.0 Product Guide78