as well as the ability to make any personal query available to anyone with access to public
queries.
NOTE:
To run some queries, you also need permissions to the feature sets associated with their
result types. Also, in a query’s results pages, the available actions to take on the resulting items
depend on the feature sets a user has permission to.
Query Builder
ePolicy Orchestrator provides an easy, four-step wizard with which to create and edit custom
queries. With the wizard you can configure which data is retrieved and displayed, and how it
is displayed.
Result types
The first selection you make in the Query Builder wizard is a result type. This selection identifies
what type of data the query will be retrieving. This selection determines what the available
selections are in the rest of the wizard.
Result types include:
• Audit Log Entries — Retrieves information on changes and actions made by ePO users.
• Compliance History — Retrieves information on compliance counts over time. This query
type and its results depend on a Run Query server task that generates compliance events
from the results of a (Boolean pie chart) query. Additionally, when creating a Compliance
History query, be sure the time unit matches the schedule interval for the server task. McAfee
recommends creating the Boolean pie chart query first, followed by the server task that
generates the compliance events, and finally the Compliance History query.
• Events — Retrieves information on events sent from managed systems.
• Managed Systems — Retrieves information about systems running the McAfee Security
Agent.
• Notifications — Retrieves information on sent notifications.
• Repositories — Retrieves data on repositories and their status.
• Rolled-up Compliance History — Retrieves information on compliance counts over time from
registered ePO servers. This query depends on server tasks being run on this ePO server
and the registered servers.
• Rolled-up Managed Systems — Retrieves summary information on systems from registered
ePO servers.
Chart types
ePolicy Orchestrator provides a number of charts and tables to display the data it retrieves.
These and their drill-down tables are highly configurable.
NOTE:
Tables do not include drill-down tables.
Chart types include:
• Bar chart
• Boolean pie chart
• Grouped bar chart
Querying the Database
Query Builder
McAfee ePolicy Orchestrator 4.0.2 Product Guide
172