Category: SQL


ConfigMgr SQL Query – ConfigMgr clients installed per AD Site

This query will give you the amount of ConfigMgr clients that are installed on machines per AD site.

This can be run on your Configuration Manager SQL database or...


SQL Query for SCCM – Hierarchy information

This is a very simple SQL query but still very useful and will give you a lot of information about your Configuration Manager hierarchy.

Run this on your Configuration...


SQL query for retrieving Site Roles from ConfigMgr Database

If you want to retrieve the site roles from your ConfigMgr environment, you can use the following SQL query:

More Queries Our full range of SQL and WQL Collection...


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 query below:

More Queries...