Tag Archives: Device Collection

Get all Workstations with Internet Explorer 9 or 10 (WQL)

Purpose: Gather all workstations with Internet Explorer 9 or 10

Gathing all of the Internet Explorer versions across your domain will require one additional configuration. This configuration is a client side software inventory setting, where you set the SCCM client to search through all your workstations iexplorer.exe and fetch the version from the appointed file.

Continue Reading

Get all Inactive Agents since Date (WQL)

Purpose: Get all Workstations that have inactive agents for 30, 60 or 90 days.

This is meant purely as monitoring collections. A workstation that has an inactive agent for 90 days is prone to have problems, is slow, has not updated, application installations are not deploying and so forth. Setting up and fixing these workstations will give the customer a better working environment.

Continue Reading

Get all duplicate Workstations in SCCM (WQL)

Purpose: Query for all duplicate Workstations in SCCM 2012

The first principle in SCCM is that… There is no first principle. The second principle is that DO NOT have duplicates in your system. Duplicate Workstations will cause a lot of troubles including disoriented support personnel, customers who thought to receive something but are still waiting for it and similar problems. Create a collection to monitor duplicate workstation names and act accordingly (or create an automation for it).

Continue Reading

Get all Workstations that have not rebooted since a Date (WQL)

Purpose: Get all Workstations that have not rebooted since 30, 60 or 90 days.

This is meant purely as monitoring collections. A workstation that has NOT rebooted in 90 days is prone to have problems, is slow, has not updated, application installations might be queued and so forth. Setting up and fixing these workstations will give the customer a better working environment.

Continue Reading

Get all Workstations with Failed Software Updates (WQL)

Purpose: Get all Workstations with Failed Software Updates (WQL)

SCCM offers multiple ways to monitor your environment. Using Device Collections is one of them. You can create a Device Collection that gathers all the workstations that have failed their Windows Updates. The rest is up to you if something actually happens to this group after the identification.

Continue Reading

Get all Workstations from an AD SG (WQL)

Purpose: Get all Workstations from an Active Directory Security Group (WQL)

If your environment uses heavily active directory security groups, you can use those memberships in Configuration Manager Device Collections. With a simple query, you can set the system to gather all the members of an active directory security group into your brand new (or old) device collection.

Continue Reading

Get all Workstations without an Application (WQL)

Purpose: All Workstations without an Application (WQL)

As an opposite to our previous example we create a device collection, which gathers all workstations that DO NOT HAVE a predefined application. This predefined application must be inserted into the query. The first table shows how to gather workstations WITHOUT an application and not take into account the version number of the application (ignores all versions). The second query ignores only specific versions of the application.

Continue Reading

Get all Workstations with an Application (WQL)

Purpose: All Workstations with an Application (WQL)

In this example we create a device collection, which gathers all workstations that has a predefined application. This predefined application must be inserted into the query. The first table shows how to gather workstations with an application and not take into account the version number of the application (gathers all versions). The second query has application version restriction as well.

Continue Reading

Get all Workstations with Windows 7 and OS is 32-bit or 64-bit (WQL)

Purpose: Get all Workstations with Windows 7 x86 or x64 (WQL)

You might need to do certain procedures to a limited list of operating systems. In this example we will gather all workstations with Windows 7 operating system and separate them into two different collections depending on if the operating system is x86 or x64.

 
Continue Reading

Display a SCCM Collection Variable and its Value

Purpose: Query SCCM Collection Variables and Values in MS SQL Reporting services (SQL)

There is a suprize waiting for you if you thought you could add variables and values into your collections and query the results using Microsoft SQL Report. Finding the correct attributes from the SQL tables is straightforward, but that is not the real problem.

Continue Reading