Use the View Results page in query management to view and manage query results.
The View Results page displays the following: Query name, query run time, the platform, and the entity of the query.
Control Compliance Suite displays messages for queries that are executed with no records. To ensure the display of all warning messages for queries, in the CCS Manager config file, set the config key to true: <add key="EnableRecordsWarnings" value="true"/>
To view and manage query results
To get the Queries page, on the Control Compliance Suite home page, point to Manage, and click Queries.
To get the View Results page, select a query in the queries table, and do one of the following:
Right-click the query, and then click View Results.
On Common tasks, click View Results.
To filter results, in the Filter pane of the View Results page, click the arrows in the Filter pane, and then click Add Statement.
In the Add Filter Statement box, select the condition parameter type from the options that are listed.
In the fields for the field, operator, and value, enter values to define the filter, and then click OK.
To export results, click Export.
To rerun the query, click Run Again.
To edit the query in the Create or Edit wizard, click Modify.
To view the information about errors, click View Errors.
View the records for a selected field in the Query result details pane.