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 […]
Tag: Query
SCCM Report Query for Machines without Client Installed
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 […]
Configuration Manager Report Query for Client Version
If you want to report on the versions of your ConfigMgr clients that you have within your Configuration Manager environment then you can run this […]
Configuration Manager Report Query for Machine Count by Manufacturer
If you want to report on the number of machines per manufacturer that you have within your Configuration Manager environment then you can run this […]
Configuration Manager Report Query for Server Name and Properties
If you want to report on the server names and properties of those servers that you have within your Configuration Manager environment then you can […]
SCCM Report Query for Machine Make and Model Count
If you want to report on the number of certain makes and models of machines that you have within your Configuration Manager environment then you […]
Configuration Manager Report Query for Systems with Torrent Software Installed
If you want to check if any of the client machines within your Configuration Manager network have torrent software installed, you can run this query […]
Report Query for Package Distribution Status on Configuration Manager Distribution Points
If you want to check the distribution status on your Configuration Manager Distribution Points you can run this query directly on your SQL database or […]
Configuration Manager SQL Query for Installed Software Per Machine & Per Collection
If you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SQL data and SSRS […]
SCCM – Low Disk Space SQL Query
This is a SQL query for your SCCM database or you can use it to create a report using SSRS. For this work, you must […]
Query for all machines with SQL installed using Installed Software
If you wish to run a SQL query against your SCCM database to find all machines with SQL installed, then you can use this SQL […]
SCCM – WQL Query for machines with 4GB RAM or more
If you have a requirement to identify machines with 4GB RAM or more, then you can use the following WQL query to do this. select […]