boognish

Think I figured it out. I just limited the query to the Laptop collection created by using 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 inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ( "8", "9", "10", "14" )

Thanks for the help and the quick replies. Next up....I have a collection for laptops ( found here http://sms-hints-tricks.blogspot.com/2008/07/laptop-collection.html). Now I want to create more specific sub collections based on manufacturer of the laptop. We are a very heterogeneous place here.

How would I go about creating a collection based on hardware manufacturer (Lenovo and Dell)? I think I have managed to get the Lenovo collection functioning but the one for dell doesn't populate.

Our scenario is sort of complex. We are migrating to a new AD, moving from a public IP scheme to a private one, coupled with 802.1x and network refreshes. Currently we install the SCCM Client on machines, convert the switch ports to the new network configuration. The machine shows up in the database, we manually move it to a collection for imaging purposes. Then after the image is complete we take it out of the temporary image collection and put it in another collection. So its direct membership. I want to automate the taking out and moving.

Is there a way to have a computer moved from one collection to another as a final part of an OSD task sequence? Say I have a collection (mandatory image collection) getting a mandatory assignment. As a last step in TS I want to take it out of that collection and move it into its rightful collection.