SQL

SCCM – Report on Outlook Archive PST files on Devices

SCCM – Report on Outlook Archive PST files on Devices

If you want to report on machines that have Outlook archive (PST’s) on them, where they are and how big they are, then you can use this guide to create a report that will do this for you using Configuration Manager. First of all, you will need to tell your Software Inventory to look for […]

SCCM – WQL Query for Devices with Configuration Manager Client Installed and no System Center Endpoint Protection Installed

SCCM – WQL Query for Devices with Configuration Manager Client Installed and no System Center Endpoint Protection Installed

We have had a report that one of our WQL queries has not been working correctly, this is the one for devices that have Configuration Manager client installed but do not have System Center Endpoint Protection installed on them. The original post is here: WQL Query for Devices without Endpoint Installed So, we have looked […]

Configuration Manager Report Query for Servers not rebooted in the last week

Configuration Manager Report Query for Servers not rebooted in the last week

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 […]

SCCM Report Query for Machines without Client Installed

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 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 […]

Configuration Manager Report Query for Client Version

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 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 […]

Configuration Manager Report Query for Machine Count by Manufacturer

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 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 […]

Configuration Manager Report Query for Server Name and Properties

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 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 […]

SCCM Report Query for Machine Make and Model Count

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 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 […]

Configuration Manager Report Query for Systems with Torrent Software Installed

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 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 […]

Report Query for Package Distribution Status on Configuration Manager Distribution Points

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 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 […]

Configuration Manager SQL Query for Installed Software Per Machine & Per Collection

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 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 […]

SCCM – Low Disk Space SQL Query

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 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 […]

Scroll to top

×