System Center

Ultimate SCCM Query Collection List

Here are some useful queries for System Center Configuration Manager that you can use to create collections. These collections demonstrate different queries you can use to create all the collection you need. Simply copy and paste these into the sccm query statement of the query rule. Let me know in the comments below if you need a specific query and I will add it to this list.

Note: Some of these collection queries require software or hardware inventory to be enabled.

SCCM Query Collections

Computers that have 30 days old hardware information.


Collection of clients not approved.


Collection of clients requiring a reboot.


Collection of ConfigMgr clients waiting for another installation to finish.


All SCCM client computers with less than 1GB free disk space on C:


All  computer objects with client installed in the specific site “PS1”


All SCCM 2007 R3 Clients


Collection with all computers without a ConfigMgr client.


Active Directory Collections

Collection based on OU.

Replace “domain.local/OU/OU” with your own domain name and OU that you need a collection of.


Collection based on domain membership.

Replace “domain” with the NETBIOS name of your domain.


Client Collections

Collection for all Workstations.


Collection of all Windows 10 clients.

Collection of All Windows 10 Creators Update (1703)

Collection of All Windows 10 Aniversary Update (1607)

Collection of All Windows 10 November Update (1511)

Collection of All Windows 10 RTM (1507).

Collection of all Windows 8.1 clients.

Collection of all Windows 8 clients.

This query need to be limited to the All Workstations collection to work. If not it will also have Windows Server 2012 members as they share the same version number.


Collection of all Windows 7 clients.

This query need to be limited to the All Workstations collection to work. If not it will also have Windows Server 2008 R2 members as they share the same version number.


Collection of all Windows Vista clients.

This query need to be limited to the All Workstations collection to work. If not it will also have Windows Server 2008 members as they share the same version number.


Collection of all Windows XP clients.


Collections based on computer manufacturer model.

Use this query to create collections for your various computer models.


Collection of computers ending with odd numbers

Note: This query may be heavy on the SCCM server.

Collection of computers ending with even numbers

Note: This query may be heavy on the SCCM server.

Collection of computers with failing hard drive

This collection query requires hardware inventory settings:

  • Classes -> Disk Drives -> Status
  • Classes -> Disk Drives -> Status Info
  • Classes -> Logical Disk -> Status
  • Classes -> Logical Disk -> Status Info

 

Server Roles Collections

Collection for all Servers.


 Collection of all Windows 2016 Servers.

 Collection of all Windows 2012 R2 Servers.


Collection of all Windows 2012 Servers.


Collection of all Windows 2008 R2 Servers.


Collection of all Windows 2008 Servers.


Collection of all Windows 2003 Servers.


Collection of all Domain Controllers.

This query requires that the config manager client is installed and hardware inventory is turned on.

 

Microsoft Exchange Server Collections

Query based collection for all Microsoft Exchange Servers


 

SQL Server Collections

Collection of all SQL Servers 2008.


Collection of all SQL Servers 2005.


Network Collections

Query based collection based on IP subnet


Query based collection based on IP range

This query creates a collection for all devices between the IP range: 10.10.10.11 – 10.10.10.19


 

Computer Model Collections

All Dell Systems

All Hewlet-Packard Systems

All HP EliteBook 840 G3 Computers

 

All Lenovo Systems

All Physical Systems

 

Other Operating Systems

Linux Collection query

Linux / Unix clients are easy to query as they have SMS_R_System.ClientEdition property set to 13 in the database. This is hos a collection query for linux / unix computers look like in SCCM.

Mac OS X Collection query

This is a collection query for a with all Mac computers as members of the collection

 

Collections of software

Computers with AVG and Security Essentials Antivirus

 

  • L. Guapo

    Good list. What about a collection query for a range of IP addresses (e.g. 192.168.2.1-192.168.2.126 [CIDR 192.168.2.0/25])?

    • Hi L. Guapo. I just put up query nr 28 (Query based collection based in IP range) based on your request. Thanks for the feedback.

  • Pingback: Requetes utiles SCCM | Ressources informatiques()