Create and Run a Database Query (Trellix ePO)

Create and run a database query to return information about client tasks and policies.

Before you begin

You must be logged on to the Trellix ePO server as an administrator.

NOTE: A Trellix ePO Cloud administrator can run queries, but not create them.

1. From the Trellix ePO menu, select Reporting > Queries & Reports.
2. From the Groups menu, select Skyhigh Security Groups > Skyhigh Security Client Proxy, then click New Query.
3. In the Query Builder: From the Feature Group list, select Policy Management.
4. Select a Result Type, then click Next:
   1. Applied Client Tasks — Returns the names of client tasks and the organizational levels where they were applied.
   2. Applied Policies — Returns the names of policies and the organizational levels where they were applied.
   3. Client Task Assignment Broken Inheritance — Returns the names of client tasks and the organizational levels where task assignments were broken.
   4. Policy Assignment Broken Inheritance — Returns the names of policies and the organizational levels where policy assignment was broken.
      The Chart page opens.
5. Configure how you want the query results displayed in chart format:
   1. Select a chart type.
   2. Specify labels, units, sort orders, and other values as needed.
   3. Click Next.
      The Columns page opens.
6. Configure how you want the query results displayed in table format, then click Next:
   • In the Available Columns menu, click column names to select them.
   • In the Selected Columns pane, close columns to remove them.
   • To reorder selected columns, drag and drop them or use the arrow keys.
     The Filter page opens.
7. Configure how you want the query results filtered:
   1. In the Available Properties menu, click property names to select them.
   2. From the Comparison drop-down list, select an operator for each property.
   3. For each operator, select a value.
8. Click Run to see the query results, then click Edit Query to make changes as needed.
9. Click Save, then on the Save Query page:
   1. Specify a name and optional description for the query.
   2. Select an existing group or specify a new group.
   3. Click Save.

The database query is saved for later use.