Let’s build an SCCM custom report to list down the devices that have out of support versions of Office 365 semi-annual channel. ConfigMgr 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.
Supported Versions Of Office 365
The following table lists the supported version for each Office 365 update channel while writing this post. The recommendation is to check the Microsoft docs to get the latest support version details.
You need to convert the Build number from the below table to match the version number as per Configuration Manager data.
- Build Number = 11328.20644
- Version Number (SCCM) = 16.0.11328.20644
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.
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.
Channel | Version | Build | Release date | Version supported until |
---|---|---|---|---|
Semi-Annual Enterprise Channel | 1902 | 11328.20644 | August 11, 2020 | September 8, 2020 |
Custom Report – Out of Support Versions of Office 365 Semi-Annual Channel
You can start this section, once you have the version details of the latest supported office 365 semi-annual channel. You can track the status of out of support versions of Office 365 semi-annual channels. This is the simplest way to get custom reports from ConfigMgr.
The CDNBaseUrl0 for Semi-Annual Enterprise Channel is – http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114
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 for Microsoft 365 Apps.
select * from v_GS_OFFICE365PROPLUSCONFIGURATIONS where VersionToReport0 < '16.0.11328.20644' and CDNBaseUrl0 = 'http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114'
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 Office 365 semi-annual channels.
- Click on the Execute button.
Results
You can check the VersionToReport0 value from the following column to understand the out-of-support Versions of the Microsoft 365 Apps (Office 365 Semi-Annual) Channel.
ResourceID | GroupID | RevisionID | AgentID | TimeStamp | AutoUpgrade0 | CCMManaged0 | CDNBaseUrl0 | cfgUpdateChannel0 | ClientCulture0 | ClientFolder0 | GPOChannel0 | GPOOfficeMgmtCOM0 | InstallationPath0 | KeyName0 | LastScenario0 | LastScenarioResult0 | OfficeMgmtCOM0 | Platform0 | SharedComputerLicensing0 | UpdateChannel0 | UpdatePath0 | UpdatesEnabled0 | UpdateUrl0 | VersionToReport0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16777219 | 1 | 4 | 1 | 21:50.0 | NULL | UpdateNotify Object | http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114 | http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114 | en-us | C:\Program Files\Common Files\Microsoft Shared\ClickToRun | NULL | NULL | C:\Program Files\Microsoft Office | Office365ProPlusConfigurations | UPDATE | Failure | TRUE | x64 | 0 | NULL | NULL | TRUE | NULL | 16.0.11229.20648 |
Resources
- SCCM Create Custom Report Using Report Builder | ConfigMgr | Part 1
- Overview of update channels for Microsoft 365 Apps
- Release information for updates to Microsoft 365 Apps
- Download sizes for updates to Microsoft 365 Apps
So this basically just gives me a version that is out of date and not what systems have an out of date install?