When Configuration Manager 2007 clients are deleted from a child site, the record is not automatically deleted from the parent site. However, the client record at the parent site is marked as decommissioned. You can display decommissioned client records in the Configuration Manager 2007 console and create collections of decommissioned clients.

Use the following procedures to display decommissioned client records in the collections window of the Configuration Manager console, and to create a collection showing only decommissioned client computers.

To display decommissioned client computer records in the Configuration Manager Console

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Collections / All Systems.

  2. In the Actions pane of the Configuration Manager console, click View, and then click Add/Remove columns.

  3. In the Available columns field of the Add/Remove Columns dialog box, select Decommissioned, and then click Add.

  4. Click OK to close the Add/Remove Columns dialog box.

To create a Configuration Manager collection to display decommissioned client computers

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management.

  2. Right-click Collections and then click New Collection.

  3. In the General page of the New Collection Wizard, specify the following values:

    • Name: Enter a descriptive name for the collection such as Decommissioned clients.

    • Comment: Enter a description for the collection, such as Displays all decommissioned client computers.

  4. Click Next to continue.

  5. In the Membership Rules page of the New Collection Wizard, click the new query icon to open the Query Rule Properties dialog box.

  6. In the General tab of the Query Rule Properties dialog box enter a name for the query rule such as Decommissioned clients query.

  7. Click Edit Query Statement to open the Query Statement Properties dialog box.

  8. In the General tab of the Query Statement Properties dialog box, click Show Query Language.

  9. In the Query Statement field of the Query Statement Properties dialog box, copy and paste the following code:

      Copy Code 
    Select * from SMS_R_System where SMS_R_System.Decommissioned = 1

  10. Click OK to close the Query Statement Properties dialog box.

  11. Click OK to close the Query Rule Properties dialog box.

  12. In the Membership Rules page of the New Collection Wizard, click Next to continue.

  13. In the Advertisements page of the New Collection Wizard, click Next to continue.

  14. In the Security Page of the New Collection Wizard, click Next to continue.

  15. In the Confirmation page of the New Collection Wizard, click Close.

See Also