How to Create a Query
Updated: May 1, 2012
Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2
If you are unfamiliar with creating Microsoft System Center Configuration Manager 2007 queries, it is recommended that you use an existing query as the basis for a new query. If you want to use an existing query as the basis for a new query, click Import Query Statement on the Query Properties dialog box to locate and select the existing query. The new query will inherit the properties of the existing query, which you can then modify.
|Some invalid queries do not generate errors. Therefore, if a query does not return data, it might be invalid. Review the query to ensure that, for example, it is not querying a resource for a value that it does not possess.|
|You must have Create permission for the Query security object class to create a new query.|
How to create a query
Navigate to System Center Configuration Manager / Site Database / Computer Management / Queries.
Right-click Queries, point to New, and then click Query.
Complete the settings in the General dialog box, and then click Edit Query Statement.
In the Query Statement Properties dialog box, complete the settings on the following tabs:
Use the General tab to specify the attributes to be returned in the results of the query, the order in which the attribute results are presented within columns, and how they are sorted.
Use the Criteria tab to refine query criteria and limit the results that are returned.
Important If you create a query that contains no criteria, the query will return all devices in the All Systems collection.
Use the Joins tab to combine data from two different attribute classes or to modify an existing join operation. Joins refine your query and help ensure that useful data returns.
For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.