SCCM 2012 Dynamic collection for Specific System Model - Lenovo Laptops
If you need to create a collection for specic System model for Lenovo Laptops. Please use below query and change Model accordingly.
If you need to create a collection for specic System model for Lenovo Laptops. Please use below query and change Model accordingly.
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_PRODUCT on
SMS_G_System_COMPUTER_SYSTEM_PRODUCT.ResourceId = SMS_R_System.ResourceId where
SMS_G_System_COMPUTER_SYSTEM_PRODUCT.Version = "ThinkPad x240"
No comments:
Post a Comment