Making IT Happen
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 SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS SQL Query The query is below …
Configuration Manager Report Query for Servers not rebooted in the last week Read MoreIf 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 or you can use it to create a report within SSRS. The query is below and can be altered to fit your own needs by adding columns and …
SCCM Report Query for Machines without Client Installed Read MoreIf you want to report on the versions of your ConfigMgr clients that you have within your Configuration Manager environment then you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS The query is below and can be altered to …
Configuration Manager Report Query for Client Version Read MoreIf you want to report on the number of machines per manufacturer that you have within your Configuration Manager environment then you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS The query is below and can be altered to …
Configuration Manager Report Query for Machine Count by Manufacturer Read MoreIf you want to report on the server names and properties of those servers that you have within your Configuration Manager environment then you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS The query is below and can be …
Configuration Manager Report Query for Server Name and Properties Read MoreIf you want to report on the number of certain makes and models of machines that you have within your Configuration Manager environment then you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS SQL Query The query is below …
SCCM Report Query for Machine Make and Model Count Read MoreIf you want to check if any of the client machines within your Configuration Manager network have torrent software installed, you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS The query is below and can be altered to fit …
Configuration Manager Report Query for Systems with Torrent Software Installed Read MoreIf you want to check the distribution status on your Configuration Manager Distribution Points you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS The query is below and can be altered to fit your own needs by adding columns …
Report Query for Package Distribution Status on Configuration Manager Distribution Points Read MoreIf you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SQL data and SSRS to produce the reports. The best way to start to create a custom report is to ensure that you get your SQL query correct first. We have written hundreds of various queries over the years …
Configuration Manager SQL Query for Installed Software Per Machine & Per Collection Read MoreThis is a SQL query for your SCCM database or you can use it to create a report using SSRS. For this work, you must ensure that you have the Logical Disk class enabled in the hardware inventory settings. This will give you the following information: Computer Name Disk Description Drive Letter Volume Name File System Total Size Free Space …
SCCM – Low Disk Space SQL Query Read MoreIf you wish to run a SQL query against your SCCM database to find all machines with SQL installed, then you can use this SQL query below: More SQL Queries Our full range of SQL and WQL Collection queries are available here. Feedback If you have any questions or feedback about this post, or if you would like us to create …
Query for all machines with SQL installed using Installed Software Read MoreIf you have a requirement to identify machines with 4GB RAM or more, then you can use the following WQL query to do this. select distinct SMS_R_System.Name, SMS_R_System.ADSiteName, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, SMS_R_System.IPAddresses, SMS_R_System.LastLogonUserName, SMS_R_System.DistinguishedName from SMS_R_System inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId where SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory >= 4096000 order by SMS_R_System.Name, SMS_R_System.ADSiteName, SMS_R_System.IPAddresses, SMS_R_System.LastLogonUserName, SMS_R_System.DistinguishedName You can change the where value of 4096000 …
SCCM – WQL Query for machines with 4GB RAM or more Read More
