Monday, October 19, 2015

SCCM Collection query to find "WINDOWS 8" and "WINDOWS 8.1" Systems

WQL Query to find Windows 8 Systems and Windows 8.1


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   where    SMS_R_System.OperatingSystemNameandVersion like "%Workstation%"   and SMS_R_System.OperatingSystemNameandVersion like "%6.3%"  or SMS_R_System.OperatingSystemNameandVersion like "%Workstation%"   and SMS_R_System.OperatingSystemNameandVersion like "%6.2%"



1 comment: