SCCM – SQL Queries for Make, Model and Architectures of Devices
These simple SQL queries can be used to pull data from the Configuration Manager database to provide you with a count of all make, model and architecture devices in your…
SCCM Collection Query for Devices with specific software installed and version or below [2023 Updated]
If you need to identify machines with specific software installed on a device but would also like to know whether they have a certain version of the stated software or…
How to Automatically Remove Spotify using SCCM [2022 Updated]
How to automatically uninstall Spotify installations using System Center Configuration Manager (SCCM).
SCCM Collection Query for Virtual Machines
Just a quick post to add to our list of SCCM collection queries. We needed one today for a collection of virtual machines only. This query you can use to…
SCCM – Create a device collection based on Domain Controller role
We have another WQL query here for you today to enable you to create a Configuration Manager collection based on whether a device is used as a domain controller. Go…
SCCM – Hardware and Client Version SQL Query
If you are looking for a SQL query to pull back hardware inventory information and the SCCM client version, then you can use the below to pull all this information…
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 code and then simply amend…
