SCCM CMPivot Query Patches Installed in Last 90 Days | ConfigMgr

3
SCCM CMPivot Query Patches Installed in Last 90 Days ConfigMgr

Let’s find out a list of devices that are SCCM CMPivot Query Patches Installed in last 90 Days. The ConfigMgr CMPivot provides real-time data based on fast channel architecture.

Configuration Manager CMPivot tool allows us to quickly assess the state of devices. When we run a query against a device collection, the CMPivot shall 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. The 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 a smaller number of devices to try out the query.

  • Right-Click on All Systems collection.
  • Select Start CMPivot.
Launch SCCM CMPivot Query Tool
  • CMPivot Query tool got launched.
  • Get familiarized with new query language and CMPivot tool.
  • Copy any of the following queries as per the requirement.
  • Check out the Run Query button from the SCCM CMPivot tool.
SCCM CMPivot Query Patches Installed in Last 90 Days | ConfigMgr
SCCM CMPivot Query Patches Installed in Last 90 Days | ConfigMgr

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.

CMPivot Query Patches Installed in Last 90 Days

Patches Installed within the last 90 Days! (3 Months)

QuickFixEngineering | where InstalledOn >= ago(90d)

Patches Installed within the last 60 Days! (2 Months)

QuickFixEngineering | where InstalledOn >= ago(60d)

Patches Installed within the last 30 Days! (1 Month)

QuickFixEngineering | where InstalledOn >= ago(60d)

Results

When is the patch installed? You can check the column Installed On from the below table. As you can see above, we used the CMPivot query to find out the patches installed on Windows 10 devices 90 days before.

DeviceCaptionDescriptionFix CommentsHotFix IDInstall DateInstalled ByInstalled OnNameService Pack In EffectStatus
PROD-WIN20http://support.microsoft.com/?kbid=4552925UpdateKB45529255/11/2020
PROD-WIN20http://support.microsoft.com/?kbid=4537759Security UpdateKB45377595/11/2020
PROD-WIN20http://support.microsoft.com/?kbid=4557968Security UpdateKB45579685/11/2020
PROD-WIN20http://support.microsoft.com/?kbid=4556803UpdateKB45568035/11/2020
SCCM CMPivot Query Patches Installed in Last 90 Days | ConfigMgr
SCCM CMPivot Query Patches Installed in Last 90 Days | ConfigMgr
SCCM CMPivot Query Patches Installed in Last 90 Days | ConfigMgr

Resources

3 COMMENTS

  1. Patches Installed within the last 30 Days! (1 Month)
    QuickFixEngineering | where InstalledOn >= ago(60d) —> correct for 30 days 🙂

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.