WQL Archives - TechyGeeksHome

SCCM – Create a device collection based on Domain Controller role

24th January 201820th April 2019 - by A.J. Armstrong - 1 Comment

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 …

Guide / Microsoft / Query / SCCM / SQL

SCCM Collection Query – Virtual Machines

16th February 201620th April 2019 - by A.J. Armstrong - 1 Comment

If you are looking for a SCCM collection query for virtual machines in your environment, then you can use this query below: Free Subscription If you want to be notified …

Guide / SCCM / 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 …