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%")
If you want to report on the servers that have not had a reboot in the last week within your Configuration Manager environment then you can run this query directly on your...
If you want to report on the machines that do not have the ConfigMgr client installed within your Configuration Manager environment then you can run this query directly on your SQL database...