ISTechDir
asked on
SCCM: Collection based on Computer Model Query?
I am trying to find out a good method of creating collections based on laptop model.
The majority of our collections are based on active directory OU queries however I would like to create collections for our laptops based on their model, however I am unsure of where to find their 'model id' and where this information is pulled from in the first place.
I'm assuming that system discovery should find this information but in the properties tab of a single computer I cannot find any reference to the computer model.
I have found this query statement elsewhere on the web:
select SMS_R_SYSTEM.ResourceID,SM S_R_SYSTEM .ResourceT ype,SMS_R_ SYSTEM.Nam e,SMS_R_SY STEM.SMSUn iqueIdenti fier,SMS_R _SYSTEM.Re sourceDoma inORWorkgr oup,SMS_R_ SYSTEM.Cli ent from SMS_R_System INNER JOIN SMS_G_System_COMPUTER_SYST EM ON SMS_G_System_COMPUTER_SYST EM.Resourc eID = SMS_R_System.ResourceId WHERE SMS_G_System_COMPUTER_SYST EM.Model = "Ergo Ensis 211"
As you can see I have manually entered the 'Ergo Ensis 211' as an example.
I have created a collection with this statement, but now need to know where to find this information, or instructions on how to configure SCCM to recognise the different laptops in some way so I can seperate them into collections ready for OSD.
Any help would be greatly appreciated.
Thanks
The majority of our collections are based on active directory OU queries however I would like to create collections for our laptops based on their model, however I am unsure of where to find their 'model id' and where this information is pulled from in the first place.
I'm assuming that system discovery should find this information but in the properties tab of a single computer I cannot find any reference to the computer model.
I have found this query statement elsewhere on the web:
select SMS_R_SYSTEM.ResourceID,SM
As you can see I have manually entered the 'Ergo Ensis 211' as an example.
I have created a collection with this statement, but now need to know where to find this information, or instructions on how to configure SCCM to recognise the different laptops in some way so I can seperate them into collections ready for OSD.
Any help would be greatly appreciated.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is exactly what I was looking for and has worked exactly as expected. Thank you very much for your help!