Trevor Sullivan

Try using the "System Resource".Name property. Also, try the "Computer System".Name property. Cheers, Trevor Sullivan http://trevorsullivan.net http://twitter.com/pcgeek86

I would recommend using Rick Houchin's Right-Click Tools for SCCM. You can right-click a collection and paste in a list of computer names you'd like to add to the collection. That is probably the most straightforward method of handling it for the time being, without some custom scripting. http://myitforum.com/cs2/blogs/rhouchins/archive/2008/04/09/sccm-right-click-tools.aspx Cheers, Trevor Sullivan http://trevorsullivan.net http://twitter.com/pcgeek86

Kevin, First off, you must ensure that Active Directory System Group Discovery is enabled on your primary site servers. Next, you can create a query around the SMS_R_System.SystemOUName that looks for an OU path like: Domain.com/USA/Site/Clients. Keep in mind that it does not use the distinguished name syntax, like OU=Clients,OU=Site,OU=USA,DC=domain,DC=com. You could also, in theory, use a Desired Configuration Management (DCM) rule to build such a collection. Check the root\RSOP\machine WMI namespace for a class called RSOP_Session, which has a property called SOM. This property contains the distinguished name of the OU that the client is a member of. Cheers, Trevor Sullivan http://trevorsullivan.net http://twitter.com/pcgeek86

You're welcome. Basically what I did was use a sub-select query to select *all* members of the LMG00033 collection, and then in the outer query, we selected everything that's *not* in the sub-select. Glad it helped! Cheers, Trevor Sullivan http://trevorsullivan.net http://twitter.com/pcgeek86

Try something like this: select * from SMS_R_System where SMS_R_System.ResourceID not in (select ResourceID from SMS_FullCollectionMembership where CollectionID = 'LMG00033') and OperatingSystemNameAndVersion like 'Microsoft Windows NT%Server%' Cheers, Trevor Sullivan http://trevorsullivan.net http://twitter.com/pcgeek86