How to Create Queries in Configuration Manager

In the Configuration Manager console, click Monitoring .

In the Monitoring workspace, click Queries and then, in the Home tab, in the Create group, click Create Query .

On the General tab of the Create Query Wizard , specify a unique name and an optional comment for the query.

If you want to import an existing query to use as a basis for the new query, click Import Query Statement and then, in the Browse Query dialog box, select an existing query that you want to import, and then click OK .

In the Object Type list, select the type of object you want the query to return. The following table describes some examples of the type of object you can search for:

Click Edit Query Statement to open the <Query Name>Statement Properties dialog box.

On the General tab in the <Query Name>Statement Properties dialog box, specify the attributes that this query returns and how they are to be displayed. Click the New icon to add a new attribute. You can also click Show Query Language to enter or edit the query directly in WMI Query Language (WQL).

On the Criteria tab of the <Query Name>Statement Properties dialog box, specify criteria that are used to refine the results of the query. For example, you could return only resources that have a site code of ‘XYZ’ in the query results. You can configure multiple criteria for a query.

On the Joins tab in the <Query Name>Statement Properties dialog box, you can combine data from two different attributes into your query results. Although Configuration Manager automatically creates query joins when you choose different attributes for your query result, the Joins tab provides more advanced options. The attribute classes supported by System Center 2012 Configuration Manager are:

For more information about how to use Join operations, see your SQL Server documentation.

Click OK to close the <Query Name>Statement Properties dialog box.

On the General tab of the Create Query Wizard , specify whether the results of this query are not limited to the members of a collection, are limited to the members of a specified collection, or prompt for a collection each time the query is run.

Complete the wizard to create the query. The new query is displayed in the Queries node in the Monitoring workspace.

In the Configuration Manager console, click Monitoring .

In the Monitoring workspace, click Queries and then, in the Home tab, in the Create group, click Import Objects .

On the MOF File Name page of the Import Objects Wizard , click Browse to select the Managed Object Format (MOF) file containing the query that you want to import.

Review information about the query to be imported and then complete the wizard. The new query is displayed in the Queries node in the Monitoring workspace.