SCCM Banner Name
WQL Queries
Main Menu > Tools
Date
Collection of computers with a specific file or older versionLast Modified: 11/29/2019
Create a collection of computers that is based on a file found during Software Inventory. These collections could be used to add a computer if the file is missing or if the file it the wrong date.
Collection of Computers based on User Group / OULast Modified: 11/29/2019
Create a collection of computers that is based on a security group or user group / OU
Collection where computer hasn't inventoried in 60 daysLast Modified: 11/29/2019
Create a collection of computers that hasn't inventoried in 60 days or hasn't sent a HW inventory.
Collection of LaptopsLast Modified: 11/29/2019
Create a collection of computers that have a laptop enclosure
List of computers with a specific fileLast Modified: 11/29/2019
Create a list of computers that is based on a file found during Software Inventory
Show login Ids to ComputersLast Modified: 11/29/2019
Query to show user login IDs linked to computers.
Collection of collectionsLast Modified: 11/29/2019
Create a collection of computers that is the culimantion of multiple collections based on their collection ID.
Collection of computers needing restart after patchesLast Modified: 11/29/2019
Create a collection of computers that need a restart after patches
Collection where sofware X is not installedLast Modified: 11/29/2019
Create a collection of computers that needs to have software x installed but doesn't have it according to hardware inventory (Add/Remove Programs)