SCCM Device Collection - Operating System

This is an SCCM device collection query to show devices of a certain operating system


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 "Microsoft Windows NT Workstation 10%"


and you replace the operating system with the operating system you are looking for. Some examples would be:

• Windows 10: Microsoft Windows NT Workstation 10%
• Windows 7: Microsoft Windows NT Workstation 6.1
• Windows XP: Microsoft Windows NT Workstation 5.1
• Windows Server: Microsoft Windows NT Server%

Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.