Collections based on manufacturer

[boognish]

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.

[wmmayms]

Query statement

 

select *  from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Manufacturer like "%Dell%"

[boognish]

Query statement

 

select *  from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Manufacturer like "%Dell%"

 

 

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.

[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" )