SCCM Query Library

• SQL Queries

• WQL Queries

SQL Queries

Count of…

• All Collections
• Number of Collections enabled for Scheduled updates
• Number of Collections enabled for Incremental updates
• Number of Collections enabled for Incremental and Scheduled updates
• Total Number of Machines By Manufacturer and Model

List of…

• All Collections in my Site Database
• All Device-based Collections
• All User-based Collections
• Collection Membership count, biggest to smallest
• Collections by “CollectionType”
• Collections by “RefreshType”
• Collections enabled for Incremental Updates
• Collections enabled for Periodic Updates
• Collections enabled for Periodic and Incremental Updates
• Collections showing Collection ID, Name and Comment sorted by the Collection ID

WQL Queries

 Active Directory

• Computers in a specific Active Directory Organizational Unit (OU)

App-V

•  Users who have installed a specific App-V Application

Computers

• Computers with a specific NetBIOS name
• All computers that are Laptops
• All computers that are virtual machines

Devices

• Android
• Apple Mac
• Intel System On a Chip
• iOS
• iPad
• iPad Touch
• Nokia Symbian
• Unix and Linux servers
• Windows ARM-based device (running Windows RT)
• Windows CE
• Windows Desktop or Laptop
• Windows Mobile 6.5
• Windows Phone
• Windows Embedded

Software

• Computers with a specific software package installed based on the name shown in Control Panel
• Computers WITHOUT a specific software package installed

SQL Versions

• SQL 2005
• SQL 2008
• SQL 2012

Windows Server Operating Systems

• All Windows Server 2000
• All Windows Server 2003
• All Windows Server 2008
• All Windows Server 2008 R2
• All Windows Server 2012 Servers
• All Windows Server 2012 R2 Servers

Windows Workstation Operating Systems

• All Windows 2000 Computers
• All Windows XP Computers
• All Windows XP 64-Bit Computers
• All Windows Vista Computers
• All Windows 7 Computers
• All Windows 8 Computers
• All Windows 8.1 Computers
• All Windows 10 Computers