If you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SCCM SQL data and […]
Tag: Query
SCCM SQL Query – Google Earth Installs
We have recently been asked to report on Google Earth installations within our SCCM environment. So, as we were already collecting the EXE file information within […]
SCCM WQL Query – All Windows 10 Installs
If you are using Configuration Manager and you want to create a collection based on all Windows 10 installations, you can use this WQL query […]
SCCM SQL Query – Count Computers by Model
If you are using Configuration Manager and want to run an SQL query on your database to count the number of different models you have in […]
SCCM WQL Query – No ConfigMgr Client Installed
If you are using Configuration Manager and you want to create a collection of all devices that do not have the Configuration Manager Client installed, […]
SCCM WQL Query – Clients without latest version installed
If you want to create a collection in Configuration Manager to show you all the devices that are not up to a specified version, then […]
SCCM WQL Query – All Inactive Clients
If you want to create a Configuration Manager Collection with all inactive devices in it, you can use the following WQL query. You can also […]
SCCM – 52 Operational Collections
There is an excellent Powershell download available giving you 52 operational collections within SCCM. You should go over to the link below and take a […]
SCCM Collection Query – Virtual Machines
If you are looking for a SCCM collection query for virtual machines in your environment, then you can use this query below:
SCCM Collection based on Active Directory Organisation Unit (OU) Membership
You may want to create a Configuration Manager Collection based upon an Active Directory Organisation Unit. To do this you can use the following WQL […]
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 […]
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 […]