SCCM CMPivot Query Devices with Greater than 15 GB Free Disk Space

0
SCCM CMPivot Query Devices with Greater than 15 GB Free Disk Space

Let’s find out SCCM CMPivot Query to find out the Devices with Greater than 15 GB Free Disk Space. The ConfigMgr CMPivot is based on fast channel notification architecture.

Configuration Manager CMPivot query tool allows us to quickly assess the state of devices. When we run a query against a device collection, the CMPivot tool will run a query in real-time on all currently connected (online) devices in the selected collection.

CMPivot Troubleshooting & Log files details available in the following blog post. This post includes CMPivot architecture and communication details as well. 👉SCCM CMPivot Architecture Fast Channel Making | ConfigMgr.

Launch SCCM CMPivot Query Tool

  • Navigate to device collection against that you want to run the CMPivot query.
  • Select All Systems device collection.

NOTE! – In a production environment with more than many devices, I don’t recommend to use All System collection. Instead, use the collection with smaller number of devices to try out the query.

  • Right-Click on All Systems collection.
  • Select Start CMPivot.
SCCM CMPivot Query Devices with Greater than 15 GB Free Disk Space
SCCM CMPivot Query Devices with Greater than 15 GB Free Disk Space
  • CMPivot Query tool got launched.
  • Get familiarized with new query language and CMPivot tool.
  • Check out the Run Query button from the SCCM CMPivot tool.
SCCM CMPivot Query Devices with Greater than 15 GB Free Disk Space
SCCM CMPivot Query Devices with Greater than 15 GB Free Disk Space
  • Copy the following query to find out the devices that have greater than 15 GB free disk space.
Disk | where (Description == 'Local Fixed Disk') | where (FreeSpace >= 15088816384)
| order by FreeSpace asc
  • Paste the query in the CMPivot query window as shown below.

NOTE! – Ignore the == symbol in the following screen capture. This is just to show the running status of the SCCM CMPivot query. >= is the correct symbol to find out the devices with greater than 15 GB disk space!

SCCM CMPivot Query Devices with Greater than 15 GB Free Disk Space
>= is the symbol used – ConfigMgr CMPivot Query Devices with Greater than 15 GB Free Disk Space
  • Now, you have the details of the devices that have more than 15 GB of free disk space.
  • Now you got the results of the SCCM CMPivot query.

NOTE! – Depending on the number of devices and complexity of the query, the CMPivot query shall take time to return the results. More details available in the following blog post. 👉SCCM CMPivot Architecture Fast Channel Making | ConfigMgr.

SCCM CMPivot Query Devices with Greater than 15 GB Free Disk Space 1
ConfigMgr CMPivot Query Devices with Greater than 15 GB Free Disk Space
  • Let’s create a device collection with the result and deploy a “special application” to that device collection.
  • Click on Create collection (device collection) option as shown below.
ConfigMgr CMPivot Query Devices with Greater than 15 GB Free Disk Space
ConfigMgr CMPivot Query Devices with Greater than 15 GB Free Disk Space
  • A collection creation wizard gets launched.
  • Limiting Collection is selected automatically. The limiting collection is selected based on device collection that you run CMPivot.
  • Click Next to continue

NOTE! – More details about the SCCM Collection creation process is explained in the following blog post. What is Collection, How to Create SCCM Direct Membership Collections?

Collection - CMPivot
Collection – CMPivot
  • This device collection is a static collection.
  • All the devices that showed up in the CMPivot query got automatically added to the static device collection called “Greater than 15 GB Disk Space”.
  • Click Next to continue.
SCCM CMPivot collection
SCCM CMPivot collection
  • Click Next, Next, and Close to complete the collection creation process based CMPivot query results.
Success: General
• Collection Name: Greater than 15 GB Disk Space
• Comment:
Membership Rules(Direct) PROD-WIN20
SCCM CMPivot collection
SCCM CMPivot collection

CMPivot Results – Devices with Greater than 15 GB Free Disk Space

  • Let’s check the CMPivot query results to find out the devices that are greater than 15 GB of Disk space!
SCCM CMPivot Query Devices with Greater than 15 GB Free Disk Space 2
  • Let’s see the collection membership created directly from CMPivot query results!
  • Navigate to \Assets and Compliance\Overview\Devices\Greater than 15 GB Disk Space
SCCM CMPivot Query Devices with Greater than 15 GB Free Disk Space 3

The results of both collection and CMPivot are the same! Happy Learning.

Resources

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.