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.
|Queries targeting Configuration Manager 2007 status messages are best viewed using Status Message Viewer.|
|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.|
TasksHow to Modify How Query Results Are Displayed
How to Run or Update a Query
How to Delete a Query
How to Create a Query
ConceptsAbout Query Elements
About Object Types
About Attributes and Attribute Classes
About Criterion Types
About Logical Operators and Operator Precedence
About Relational Operators
About Group Parentheses
About Attribute Class Joins
How to Modify a Query
For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.