Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel SCCM

Find the out-of-support version of Microsoft 365 apps (a.k.a Office 365 apps) Let’s build a ConfigMgr custom report to list down the devices that have Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel.

SCCM can help you to find the out of support versions of office 365 pro plus installed devices in your environment.

Note! – Office 365 ProPlus was renamed to Microsoft 365 Apps for the enterprise. More info here.

Patch My PC

Supported Versions Of Microsoft 365 Enterprise Apps

The following table lists the supported version for each Office 365 (a.k.a Microsoft 365 Apps) update channel while writing this post. The recommendation is to check the Microsoft docs to get the latest support version details.

Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel SCCM 1
Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel SCCM 3

You need to convert the Build number from the below table to match the version number as per Configuration Manager data (VersionToReport0).

  • Build Number = 14131.20384
  • Version Number (SCCM) = 16.0.14131.20384

NOTE! – I don’t think the last part of the build number is significant. So in the above example version number 2005 = build number 14131.

1E Nomad

Let’s understand some Once you have the latest supported version, replace the version number in the below SQL query. You can use the above version number (SCCM) to build the SQL query to list down the devices that have out of support versions of Office 365.

ChannelVersionBuildRelease dateVersion supported until
Monthly Enterprise Channel2106 14131.20384 August 10, 2021October 12, 2021
Supported Versions Of Office 365 – SCCM Custom Report Out of Support Versions of Microsoft 365 Apps Monthly Channel

Custom Report – Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel

You can start this section, once you have the version details of the latest supported Microsoft 365 Apps Monthly Enterprise Channel. You can track the status of out of support versions of monthly channels. This is the simplest way to get custom reports from ConfigMgr.

The CDNBaseUrl0 for Monthly Enterprise Channel is – http://officecdn.microsoft.com/pr/55336b82-a18d-4dd6-b5f6-9e5095c314a6

More details about Microsoft 365 Apps CDN Base URL for Office 365 Pro Plus

SQL Query

Use the following query in the custom report section below to find out the list of devices that are Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel.

select * from v_GS_OFFICE365PROPLUSCONFIGURATIONS where VersionToReport0 < '16.0.14131.20384' and CDNBaseUrl0 = 'http://officecdn.microsoft.com/pr/55336b82-a18d-4dd6-b5f6-9e5095c314a6'

Custom Report

  • Open the SQL Management Studio.
  • Click on the New Query button.
  • Select the CM_MEM database from the drop-down menu.
    • MEM is the ConfigMgr site code.
  • Copy the following SQL query to find the report to list the devices that have Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel.
  • Click on the Execute button.
ConfigMgr Custom Report Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel SCCM
ConfigMgr Custom Report Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel SCCM

Results

You can check VersionToReport0 value from the following column to understand the out of support Versions of Microsoft 365 Apps (Office 365) monthly Channel.

ResourceIDGroupIDRevisionIDAgentIDTimeStampAutoUpgrade0CCMManaged0CDNBaseUrl0cfgUpdateChannel0ClientCulture0ClientFolder0GPOChannel0GPOOfficeMgmtCOM0InstallationPath0KeyName0LastScenario0LastScenarioResult0OfficeMgmtCOM0Platform0SharedComputerLicensing0UpdateChannel0UpdatePath0UpdatesEnabled0UpdateUrl0VersionToReport0
1678921914102:20.0NULLUpdateNotify Objecthttp://officecdn.microsoft.com/pr/55336b82-a18d-4dd6-b5f6-9e5095c314a6http://officecdn.microsoft.com/pr/55336b82-a18d-4dd6-b5f6-9e5095c314a6en-usC:\Program Files\Common Files\Microsoft Shared\ClickToRunNULLNULLC:\Program Files\Microsoft OfficeOffice365ProPlusConfigurationsUPDATEFailureTRUEx640NULLNULLTRUENULL16.0.11229.20648
SCCM Custom Report Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel

Resources

Author

About Author -> Anoop is Microsoft’s Most Valuable Professional Award winner from 2015 on the technologies! He is a Solution Architect on enterprise device management solutions with more than 20 years of experience (calculation done in 2021) in IT. He is Blogger, Speaker, and Local User Group Community leader. His main focus is on Device Management technologies like Configuration Manager, Windows 365 Cloud PC, Intune, Azure Virtual Desktop, Windows 10, and Windows 11.

Leave a Comment

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