WQL Archives - TechyGeeksHome

How to Automatically Remove Spotify using SCCM [2019 Updated]

15th October 201915th October 2019 - by A.J. Armstrong - 1 Comment

How to automatically uninstall Spotify installations using System Center Configuration Manager (SCCM).

Guide / Microsoft / Query / SCCM / SQL

SCCM – Create a device collection based on Domain Controller role

24th January 201820th April 2019 - by A.J. Armstrong - 2 Comments.

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 …

Guide / Microsoft / Query / SCCM / SQL

SCCM – Hardware and Client Version SQL Query

17th January 20189th July 2018 - by A.J. Armstrong - Leave a Comment

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 …

Query / Guide / Microsoft / SCCM / SQL

SCCM Collection Query – Virtual Machines

16th February 201620th April 2019 - by A.J. Armstrong - 2 Comments.

If you are looking for a SCCM collection query for virtual machines in your environment, then you can use this query below:

SCCM / Guide / SQL

SCCM Collection based on Active Directory Organisation Unit (OU) Membership

25th May 201521st October 2018 - by A.J. Armstrong - Leave a Comment

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 …