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.
    Blogger Comment


Post a Comment

Note: Only a member of this blog may post a comment.