Tuesday, March 3, 2015

SCCM 2012 Dynamic Collection Query for Computers by Model Number

Here is WQL for a hardware models...

select distinct SMS_G_System_COMPUTER_SYSTEM.Name, SMS_G_System_COMPUTER_SYSTEM.Model, SMS_R_System.LastLogonUserName 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 "XXXXXXXX" or SMS_G_System_COMPUTER_SYSTEM.Model like "XXXXXXX" or SMS_G_System_COMPUTER_SYSTEM.Model like "XXXXXX" or SMS_G_System_COMPUTER_SYSTEM.Model like "XXXXXXXX" or SMS_G_System_COMPUTER_SYSTEM.Model like "XXXXXXXX" or SMS_G_System_COMPUTER_SYSTEM.Model like "XXXXXXX"

No comments:

Post a Comment