Query
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 …
Read More 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 …
Read More
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 you …
Read More 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. select * from sites Run this …
Read More 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: select SiteCode, RoleName, ServerName from SysResList More Queries Our full range …
Read More 
SCCM – WQL Query for machines without Endpoint Protection installed
If you need to identify machines that have the Configuration Manager client installed but do not have the System Center Endpoint Protection client installed, then you can use the following …
Read More 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 distinct SMS_R_System.Name, SMS_R_System.ADSiteName, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, SMS_R_System.IPAddresses, …
Read More 