When you want to create a collection with computers without specific software in System Center Configuration Manager 2007 you should use a dynamic method for creating your collection (query-based membership). You define the rules by which those members are placed in the collections. These rules form a query, and Configuration Manager periodically reruns the query to keep the collection up to date.

To create a collection with computers without Word Viewer

1. Open Configuration Manager console.
2. Navigate to System CenterConfiguration Manager > Site Database > Computer Management > Collections.
3. Right-click Collections, and then click New Collection.
4. Use the New Collection Wizard.
5. On General tab specify Name and Comment.

   

    

6. On Membership rules Tab click button with database. In Query Rule Properties window click “Edit Query Statement…” button.

   

    

7. On General click “Show Query Language” button.

   

    

8. Type the following SQL query:
   select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.Client = 1 and SMS_R_System.Name not in (select SMS_R_SYSTEM.Name from SMS_R_System join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductName like “%Word Viewer%”)

   

    

9. Approve the operation, use default settings in the wizard.