Jump to content


Sign in to follow this  
boognish

Collections based on manufacturer

Recommended Posts

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.

Share this post


Link to post
Share on other sites


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%"

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...