sccm logo

SCCM WQL Query – Clients without latest version installed

If you want to create a collection in Configuration Manager to show you all the devices that are not up to a specified version, then you can use the WQL query below: 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.ClientVersion != “5.00.8412.1007” Where “5.00.8412.1007” is the latest version number that you are…

Read More
CCMClean-Featured-Image

    CCMClean

    Prerequisites This program requires System Center Configuration Manager to be installed and configured in a production environment. Download To download, simply scroll down towards the bottom of this page and you will see the options for this download. Ensure you select the correct one and click the blue Download button as detailed below:

    Read More