SCCM CMPivot Query for Out-of-Support Office 365 ProPlus

Let’s build a ConfigMgr CMPivot Query for out-of-support Office 365 ProPlus semi-annual and monthly channels. ConfigMgr can help you find the out-of-support versions of Office 365 Pro Plus (a.k.a. Microsoft 365 App) installed devices in your environment.

CMPivot provides a fast and efficient way to assess the status of devices in your environment and execute real-time queries on all connected devices within the chosen collection.

The CMPivot query gives you the real-time value of these versions in your environment. The following blog posts use the SQL query to provide details on Office 365 ProPlus out-of-support devices.

Index
Launching CMPivot Query Window
Semi-Annual Office 365 ProPlus Out-of-Support CMPivot Query
Other Option
Monthly Office 365 ProPlus Out-of-Support CMPivot Query
Other Option
SCCM CMPivot Query for Out-of-Support Office 365 ProPlus – Table 1

NOTE!CMPivot can return on the results of ONLINE devices when running the query. So, this might not make much sense if you want to get a report on all the devices of a global organization.

Patch My PC

Launching CMPivot Query Window

  • Navigate to the device collection against which 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 the All Systems collection.
  • Select Start CMPivot.
SCCM CMPivot Query for Out-of-Support Office 365 ProPlus - Fig.1
SCCM CMPivot Query for Out-of-Support Office 365 ProPlus – Fig.1
  • CMPivot Query tool was launched.
  • Get familiarized with new query language and CMPivot tool.
  • Copy any of the following queries (monthly and semi-annual) as required.
  • Check out the Run Query button from the SCCM CMPivot tool.

Semi-Annual Office 365 ProPlus Out-of-Support CMPivot Query

Copy the following CMPivot query to get the list of ONLINE devices for the Out-of-Support Office 365 ProPlus semi-annual channel. More details about the version and CDN Update channel are explained in the previous post.

NOTE! – I don’t think the last part of the build number is significant while checking out the support scenarios. So, in the above example, version number 1902 = build number 11328. You can just use 11328 in the following scenarios.

Office365ProPlusConfigurations | where VersionToReport < '16.0.11328.20644' and cfgUpdateChannel == 'http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114'
SCCM CMPivot Query for Out-of-Support Office 365 ProPlus - Fig.2
SCCM CMPivot Query for Out-of-Support Office 365 ProPlus – Fig.2

Other Option

OfficeProductInfo | where Channel == 'Semi-Annual Enterprise Channel' and ProductName > '16.0.11929.20648'

Monthly Office 365 ProPlus Out-of-Support CMPivot Query

Copy the following CMPivot query to get the list of ONLINE devices for the out-of-support Office 365 ProPlus Monthly channel. More details about the version and CDN Update channel are explained in the previous post.

Office365ProPlusConfigurations | where VersionToReport < '16.0.12827.20656' and cfgUpdateChannel == 'http://officecdn.microsoft.com/pr/55336b82-a18d-4dd6-b5f6-9e5095c314a6'
SCCM CMPivot Query for Out-of-Support Office 365 ProPlus - Fig.3
SCCM CMPivot Query for Out-of-Support Office 365 ProPlus – Fig.3

Other Option

OfficeProductInfo | where Channel == 'Monthly Enterprise Channel' and ProductName > '16.0.12827.20656'

Resources

We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.

Leave a Comment

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