Export (0) Print
Expand All

Overview of Queries

Updated: December 1, 2008

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

You can create and run queries to locate objects in a Microsoft System Center Configuration Manager 2007 site that match your query criteria. These objects include items such as specific types of computers or user groups. Queries can return most types of Microsoft System Center Configuration Manager 2007 objects, including sites, collections, packages, and saved queries themselves. However, queries are most useful for extracting information related to resource discovery, inventory data, and status messages.

When you create a query, you must specify a minimum of two parameters: where to search and what to search for. For example, to find out the amount of hard disk space that is available on all personal computers in a Configuration Manager 2007 site, you can create a query to search the System Resource About Object Types and search for available hard disk space.

After you create an initial query, you can specify additional query criteria. For example, you can specify that the query results include only personal computers with more than 100 MB of available hard disk space. You can also modify how results are displayed so that you can view the results in an order that is meaningful to you. For example, you can specify that the results be ordered by the amount of available hard disk space in either ascending or descending order.

When you create a query, it is stored by Configuration Manager 2007 and displayed in the Configuration Manager 2007 console under Queries. From this location, you can create a Query , run or update a, view, modify, and delete queries.

When a query is run, Configuration Manager 2007 searches the Configuration Manager 2007 site database for objects that match the query criteria. The results of the query appear in the results pane of the Configuration Manager 2007 console.

noteNote
Queries targeting Configuration Manager 2007 status messages are best viewed using Status Message Viewer.

noteNote
For information about using the Configuration Manager 2007 Software Development Kit to script and develop software for this feature, see http://go.microsoft.com/fwlink/?LinkID=129522.

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