Get all Workstations with Defined OS and no SCCM client (WQL)

Purpose: Create a Device Collection which gathers workstations without SCCM client

In an SCCM controlled environment, a system without SCCM client is malfunctioning. Therefore you must be able to monitor that all the systems in your environment actually have the SCCM client. A fully operational SCCM and a workstation without SCCM client will mean that the workstation is not receiving any application updates, any OS updates and might even download OS updates them directly from MS without any restrictions (depending on other settings outside SCCM in your environment). So you really ought to fix these.

 

all Windows 7 workstations (NO SCCM AGENT)
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.Client is null and SMS_R_System.OperatingSystemNameandVersion like “Microsoft Windows NT Workstation 6.1”
all Windows XP workstations (NO SCCM AGENT)
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.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 *


+ eight = sixteen

Post Navigation