Model Collection Query

  • 20 December 2016
  • Sean Huggans

Replace with the output of "wmic csproduct get name" on the model of PC you want to create a collection for.

Query: 
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 like "%<Model Name Here>%"
Query Type: 
Collection Query (WQL)