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.

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.
You must have Modify permission for the Query security object class to modify query properties.


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