If you are using Configuration Manager and you want to create a collection based on all Windows 10 installations, you can use this WQL query below:
where SMS_R_System.OperatingSystemNameandVersion like "%Microsoft Windows NT Workstation 10%"
You can change the “%Microsoft...
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:...
If you are looking for a SCCM collection query for virtual machines in your environment, then you can use this 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.ResourceId not in (select SMS_R_SYSTEM.ResourceID from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "%Virtual%")
This is a SCCM 2012 query that will return all machines that are in a specified organisational unit (OU). All you need to do is change the demo OU below to your...
If you need to identify machines with specific software installed on a machine but would also like to know whether they have a certain version of the stated software or below, then...