SCCM Query Collection List.

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 try to add it to this list.

Note: Some of these collection queries require software or hardware inventory to be enabled. Also, not all query’s work in all SCCM versions.

SCCM Query Collections

Computers that have more than 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 5GB free disk space on C:

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

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 many OU.

In case you have many repeated OU structure (one OU name exist in many other OU). Replace “domain.local/%/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

Collection of all SQL Servers 2016 (x64)

Collection of all SQL Servers 2014 (x64)

Collection of all SQL Servers 2012 (x64)

Collection of all SQL Servers 2012.

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

 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