Query management makes provision for the management of failures in query results. View the failures in query results and take appropriate action. Drag the information in any Failures table column to isolate it for viewing. Rerun a query, modify a query, or export the failure information in query results to better manage the failures.
Expand a query to view the asset, type, and the asset owner of the query.
The View Errors feature fetches the Messages box that provides the following information:
Date: Displays the query run date
Error: States the error. For example: 'Windows Data Collection: Information Server query returned with message(s).'
Error details: Displays the details about the error. For example: 'The RPC server is unavailable.'
Total assets affected: Provides the number of assets to gauge the extent of the problem
State: Query failures display two states, Error or Warning. Unlike a warning, an error can stall a query run.
To export failure results
In the queries table in List View, select a query and do one of the following:
Right-click the query, and click View Results.
On Common tasks, click View Results.
On the View Results page, click View Errors.
On the Messages box, click Export.
On Save exported file to..., in the File name field, enter a name for the failures file.
In the Save as type field, enter the format in which you want the file exported.