If you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SCCM SQL data and SSRS to produce the reports....
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...
If you are using Configuration Manager and want to run an SQL query on your database to count the number of different models you have in your organisation, you can use...
If you are using Configuration Manager and you want to create a collection of all devices that do not have the Configuration Manager Client installed, then you can use this...
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...
If you want to create a Configuration Manager Collection with all inactive devices in it, you can use the following WQL query. You can also change the last “0” to...
There is an excellent Powershell download available giving you 52 operational collections within SCCM. You should go over to the link below and take a look: 52 SCCM Powershell Collections...
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...
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...
If you would like to create a report to show you the number of different Operating System’s you have, you can use this script below which should provide you with...