Export (0) Print
Expand All

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.

noteNote
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.

noteNote
You must have Create permission for the Query security object class to create a new query.

How to create a query

  1. Navigate to System Center Configuration Manager / Site Database / Computer Management / Queries.

  2. Right-click Queries, point to New, and then click Query.

  3. Complete the settings in the General dialog box, and then click Edit Query Statement.

  4. In the Query Statement Properties dialog box, complete the settings on the following tabs:

  5. 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.

  6. Use the Criteria tab to refine query criteria and limit the results that are returned.

    ImportantImportant
    If you create a query that contains no criteria, the query will return all devices in the All Systems collection.

  7. 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.

See Also

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft