Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

How to Modify a Query

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 want to use an existing Microsoft System Center Configuration Manager 2007 query as the basis for a new query (to preserve the original query), click Browse 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
If you select only a portion of a clause in a query that has multiple clauses, the Delete button is disabled. Select the entire clause.

noteNote
You must have Modify permission for the Query security object class to modify query properties.

Procedures

How to modify a query

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

  2. Right-click the query that you want to modify, and then click Properties.

  3. Modify the settings in the Query Properties dialog box, and then click Edit Query Statement.

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

  5. Use the General tab to modify 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 modify the query criteria and limit the results that are returned.

  7. Use the Joins tab to combine data from two different attribute classes or to modify an existing join operation.

See Also

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.