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...
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...
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...
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...
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: select SMS_R_System.ResourceId, SMS_R_System.ResourceType,...
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...