Link to home
Start Free TrialLog in
Avatar of ISTechDir
ISTechDirFlag for United Kingdom of Great Britain and Northern Ireland

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,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_COMPUTER_SYSTEM       ON SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId   WHERE  SMS_G_System_COMPUTER_SYSTEM.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
ASKER CERTIFIED SOLUTION
Avatar of bwoodall
bwoodall

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ISTechDir

ASKER

Sorry for the delay in updating this question.

This is exactly what I was looking for and has worked exactly as expected. Thank you very much for your help!