Query Archives - TechyGeeksHome

SCCM Query for Microsoft Server 2019

2nd December 201910th November 2019 - by A.J. Armstrong - Leave a Comment

I’ve not done a post about SCCM queries for a while now so in addition to a load I did some time ago, I thought I’d bring things up to …

Guide / Microsoft / Query / SQL

SQL Query to find members of an Active Directory Security Group

26th November 201820th April 2019 - by A.J. Armstrong - Leave a Comment

We recently helped out with a data migration which included creating a completely new set of Active Directory security groups. They wanted all the members to have the same level …

Guide / Microsoft / Query / SCCM / SQL

SCCM – Active Directory Security Group Query for User Collection

23rd March 20189th July 2018 - by A.J. Armstrong - Leave a Comment

If you are looking at setting up a SCCM user collection based on membership of an Active Directory Security Group, then you can use this WQL query for the collection. …

System Center Configuration Manager SCCM

Guide / Query / SCCM / SQL

SCCM – SQL Queries for Make, Model and Architectures of Devices

19th March 20189th July 2018 - by A.J. Armstrong - Leave a Comment

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 …

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 …

Guide / Microsoft / Query / SCCM / SQL

SCCM SQL Query for Software not in Add Remove Programs

9th January 201817th July 2019 - by A.J. Armstrong - Leave a Comment

If you are looking for an SCCM SQL query to create a report to search for machines which do not have a particular software installed, you can use the following: …

Guide / Microsoft / Query / SCCM / SQL

SCCM – SQL Query for all Laptops

1st November 20171st September 2019 - by A.J. Armstrong - Leave a Comment

Table of ContentsThe SQL QueryChassis Type is just a number, what does it mean?What if I want to amend the query?I need help with setting up the SSRS report.More QueriesFeedback …

Guide / Query / SCCM

SCCM WQL Query – All Windows 10 Installs

15th September 201615th May 2018 - by A.J. Armstrong - Leave a Comment

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 below: select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, …

Guide / Microsoft / Query / SCCM / SQL

SCCM SQL Query – Count Computers by Model

14th September 20167th April 2018 - by A.J. Armstrong - 2 Comments.

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 your organisation, you can use …

SCCM / Guide / Query

SCCM WQL Query – No ConfigMgr Client Installed

12th September 20169th July 2018 - by A.J. Armstrong - 3 Comments.

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, then you can use this …

SCCM / Guide / Query

SCCM WQL Query – Clients without latest version installed

7th September 201624th March 2018 - by A.J. Armstrong - Leave a Comment

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 you can use the WQL …

Guide / Query / SCCM / SQL

SCCM WQL Query – All Inactive Clients

6th September 201615th July 2018 - by A.J. Armstrong - Leave a Comment

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 change the last “0” to …

Query / Guide / SCCM / SQL

SCCM – 52 Operational Collections

16th March 201616th June 2018 - by A.J. Armstrong - Leave a Comment

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 look: 52 SCCM Powershell Collections …

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: select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from …

Guide / Microsoft / Query / SCCM / SQL

SCCM – Report on Outlook Archive PST files on Devices

25th August 20147th April 2018 - by A.J. Armstrong - Leave a Comment

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 use this guide to create …

Guide / Microsoft / Query / SCCM / SQL

SCCM – WQL Query for Devices with Configuration Manager Client Installed and no System Center Endpoint Protection Installed

23rd August 20144th June 2018 - by A.J. Armstrong - Leave a Comment

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 Manager client installed but do …

Guide / Microsoft / Query / SCCM / SQL

Configuration Manager Report Query for Servers not rebooted in the last week

3rd July 20144th June 2018 - by A.J. Armstrong - Leave a Comment

If you want to report on the servers that have not had a reboot in the last week within your Configuration Manager environment then you can run this query directly …