Get all Workstations with Windows XP (WQL)

Purpose: Get all Workstations with Windows XP (WQL)

You are in a need to gather all Windows XP workstations with or without a SCCM client. You will first need to create a Device Collection: all Windows XP workstations with or without SCCM client (limiting collection: All Systems). Then create the: all Windows XP workstations without SCCM client (limiting collection: all XP workstations with or without client).

 

All Windows XP workstations (with or without SCCM client)
Limiting collection: All Systems
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 5.1%”
All Windows XP workstations (without SCCM client)
Limiting collection: All Windows XP workstations (with or without SCCM client)
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.Client is null and SMS_R_System.OperatingSystemNameandVersion like “Microsoft Windows NT Workstation 5.1”

Leave a Reply

Your email address will not be published. Required fields are marked *


two + seven =

Post Navigation