Tuesday, October 29, 2013

SCCM Collection for Laptops



Below WQL query creates a collection for all the laptops in the environment based on the System Enclosure attribute and Chassis type.
************************************************************
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_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes like "8 , 9, 10, 11, 12, 14, 18, 21"
**************************************************************


More SCCM collection queries can be found here

No comments:

Post a Comment