Skip to content
Trending
Simplify Windows Devices to Run Only the Required Applications using Intune Enhance macOS Compliance with Custom Security and Compliance Checks to Improve Device Security using Microsoft Intune Manage Samsung Galaxy Firmware Versions to Improve Security and Compliance using Microsoft Intune MS Intune Adds Windows Registry Data Collection to Device Inventory for Single Values All Key Values and Subkeys Updated Windows Device Sync Experience Enhances Per-Device Troubleshooting Configure Windows Sandbox vGPU Policy using Intune for Better Graphics Performance or Reduced Attack Surface Simplify Windows Devices to Run Only the Required Applications using Intune Enhance macOS Compliance with Custom Security and Compliance Checks to Improve Device Security using Microsoft Intune Manage Samsung Galaxy Firmware Versions to Improve Security and Compliance using Microsoft Intune MS Intune Adds Windows Registry Data Collection to Device Inventory for Single Values All Key Values and Subkeys Updated Windows Device Sync Experience Enhances Per-Device Troubleshooting Configure Windows Sandbox vGPU Policy using Intune for Better Graphics Performance or Reduced Attack Surface
Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel SCCM

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

Written By Anoop C Nair
Last Updated July 2, 2024
Posted In SCCM
SHARE

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

Using Microsoft 365 Apps on supported operating systems is essential to ensure optimal performance and reliability. This will help you fully take advantage of new features and ensure that updates work as expected.

SCCM can help you find the out-of-support versions of Office 365 Pro Plus installed devices in your environment. Office 365 ProPlus was renamed to Microsoft 365 Apps for the enterprise. More info here.

Index
Supported Versions Of Microsoft 365 Enterprise Apps
Custom Report – Out of Support Versions of Microsoft 365 Apps
SQL Query
Custom Report
Results
Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel SCCM – Table 1

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 updating this post. You should check the Microsoft docs for the latest support version details.

Patch My PC
ChannelVersion Build Latest release DateVersion Availability dateLatest Release Date
Current Channel2406
17726.20126		June 26, 2024June 26, 2024Version 2407 is released
Monthly Enterprise Channel240417531.20190June 11, 2024June 6, 2024August 13, 2024
Monthly Enterprise Channel240317425.20258June 11, 2024May 9, 2024July 9, 2024
Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel SCCM – Table 2

You need to convert the Build number from the table below 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.

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

ChannelVersionBuildRelease dateVersion supported until
Monthly Enterprise Channel240317425.20258June 11, 2024July 9, 2024
Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel SCCM – Table 2

Custom Report – Out-of-Support Versions of Microsoft 365 Apps

You can start this section once you have the latest supported Microsoft 365 Apps Monthly Enterprise Channel version details. 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

SQL Query

Use the following query in the custom report section below to find 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 listing the devices with out-of-support Versions of Microsoft 365 Apps Monthly Enterprise Channel.
  • Click on the Execute button.
Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel SCCM - Fig.2
Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel SCCM – Fig.2

Results

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

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
Out of Support Versions of Microsoft 365 Apps Monthly Enterprise Channel SCCM – Table 3

Resources

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

Author

Anoop C Nair is a Microsoft MVP. He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is a Blogger, Speaker, and leader of the Local User Group HTMD Community. His primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.

Written by

Anoop C Nair is Workplace Technology solution architect with 25+ years of experience in global enterprise organizations such as JP Morgan, Capgemini, etc. Microsoft Certified Trainer. Microsoft MVP from 2015 onwards for consecutive 11+ years! He also conducts Intune and modern workplace tech training for enterprise organizations. He is Blogger, Speaker, and Founder of HTMD Community and HTMD Conference. His main focus is on Device Management technologies like Intune, Windows, Cloud PC. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security.

Discussion

Join the discussion

Your email address will not be published. Required fields are marked *

Related guides

Intune

Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws

Key Takeaways Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws! In the July 2026 Patch, Microsoft introduced new features designed to improve the overall Windows experience. The update adds enhancements to Windows Update for more flexible update management and introduces Point-in-Time Restore, providing an additional recovery option for […]

AC Anoop C Nair 9 min read
Intune

2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws

Key Takeaways 2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws! The June 2026 Windows 11 Patch Tuesday update brings several improvements to File Explorer. It adds support for additional archive formats, including UU, CPIO, XAR, and NuGet Packages (NUPKG). The update also preserves View and Sort preferences in […]

AC Anoop C Nair 10 min read
Intune

2026 May KB5089549 KB5087420 Windows 11 Patch | 0 Zero Day Vulnerabilities and 120 Flaws

Key Takeaways The Windows 11 May 2026 Patch KB5089549 KB5087420 Update brings important security fixes, performance improvements, and reliability enhancements across the operating system. The update introduces new features such as Xbox Mode for gaming, File Explorer improvements, enhanced input and sharing experiences, better taskbar and Windows Hello reliability, and additional enterprise management capabilities for […]

AC Anoop C Nair 8 min read
SCCM

ConfigMgr 2603 Introduces New Early Update Enrollment Process

Key Takeaways In this post we are discussing the ConfigMgr 2603 Introduces New Early Update Enrollment Process. Microsoft has officially released Configuration Manager version 2603 to the Early Update Ring, giving organizations an opportunity to test upcoming improvements before the global production rollout. The release is targeted at enterprises running ConfigMgr version 2409 or later […]

AC Anoop C Nair 3 min read