SCCM Microsoft 365 App Report Dashboard | Part 2 | ConfigMgr

Let’s SCCM Microsoft 365 App Report Dashboard. This post is a continuation of Part1, in my previous we imported two Raw data reports that gave us information about different Microsoft Office versions and Information on Office 365 Inventory after enabling the Hardware class.

Introduction

In this post, we will create a Dashboard by importing the rdl file and see how can we interlink the previous post with this one. We will also understand a few Columns which we have enabled in the Hardware Inventory of ‘Office365 ProPlusConfigurations‘ and how to use those columns.

Update Channels

Microsoft has defined different channels when it comes to Managing 365 Apps. With the help of updated channels, you can control how often your organization gets the new features.

Different Types of channels

The following table gives the details of types of Office 365 channels.

Patch My PC
New namePrevious name
Beta ChannelInsider
(sometimes referred to as Insider Fast)
Current Channel Monthly Channel (Targeted)
(sometimes referred to as Insider Slow)
Current ChannelMonthly Channel
Monthly Enterprise Channel
Semi-Annual Enterprise Channel (Preview)Semi-Annual Channel (Targeted)
Semi-Annual Enterprise ChannelSemi-Annual Channel
SCCM Microsoft 365 App Report Dashboard | Part 2 | ConfigMgr

Channels and CDN Values

The channels and CND values for Office 365 or Microsoft 365 apps are given in the below table.

Channel NameCDN Values
Current Channel(Preview)http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be
Current Channelhttp://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60
Semi-Annual Enterprise channel(Preview)http://officecdn.microsoft.com/pr/b8f9b850-328d-4355-9145-c59439a0c4cf
Semi-Annual Enterprise Channelhttp://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114
Monthly Enterprise Channelhttp://officecdn.microsoft.com/pr/55336b82-a18d-4dd6-b5f6-9e5095c314a6
Beta Channelhttp://officecdn.microsoft.com/pr/5440fd1f-7ecb-4221-8110-145efaa6372f
SCCM Microsoft 365 App Report Dashboard | Part 2 | ConfigMgr

Note: To know more information on Update channels follow the Overview of Update channels

Columns of O365ProplusConfigurations

After enabling the hardware inventory of O365Proplusconfigurations we get information on different columns.

ColumnsDescription
HostnameHostname of machine
Architecturex86 or x64
Versiona version of O365 installed
UpdateEnableTrue or False
OfficeMgmtCOMTrue or false
Language(ClientCulture)O365 Language
Channel(CDNBaseUrl)different channels
Client FolderClick to run Path
Installation PathApplication installation Path
Auto UpgradeYes or No
CCM ManagedYes or No

AutoUpgrade

By default, installations of Microsoft Office are configured to automatically update your Office installation when new updates are made publicly available. But many environments prefer to update it in a controlled manner. This column tells us the information if auto-update is ‘enabled’ or ‘disabled’.

Adaptiva

Below is the registry key which either you can manage via GPO or via SCCM Baseline and change according to your environment.

  • Microsoft 365 Apps for enterprise, Office 2019, and Office 2016
HKEY_LOCAL_MACHINE\software\policies\microsoft\office\16.0\common\OfficeUpdate
  • Office 2013
HKEY_LOCAL_MACHINE\software\Wow6432Node\microsoft\office\15.0\common\OfficeUpdate
  • DWORD: EnableAutomaticUpdates
    Values:
    0 = automatic updates are disabled
    1 = automatic updates are enabled
  • DWORD: HideEnableDisableUpdates
    Values:
    1 = hide the menu option to enable or disable automatic updates
    0 = show the menu option to enable or disable automatic updates

OfficeMgmtCOM

There are different options available on how we can manage Microsoft Office 365 apps.

Office 365 clients to receive updates from Configuration Manager

This Option provides us with three methods that can be used so that Office 365 clients can receive updates from Configuration Manager.

Client Settings

You can configure the client settings using the following method. This helps to define the inventory for O365. In the Configuration Manager console, click Administration > Overview > Client Settings.

Open the client settings, click Software Updates and select Yes for the Enable management of the Office 365 Client Agent setting.

Group Policy

You can enable Configuration Manager to manage Office updates on specific computers by using Group Policy. You can apply this setting to multiple computers, an organizational unit (OU), or a domain.

To use Group Policy, do the following:

  • Download and install the Administrative Template files (ADMX/ADML) for Office from the Microsoft Download Center.
  • Enable the Management of Microsoft 365 Apps for enterprise policy setting. You can find this policy setting under Computer Configuration\Policies\Administrative Templates\Microsoft Office 2016 (Machine)\Updates.

Office Deployment Tool

If you have used Office Deployment Tool then you can have settings in the configuration.xml file to achieve the results

<Configuration> 
       <Add OfficeClientEdition="32" Channel="Current" OfficeMgmtCOM="True" > 
         <Product ID="O365ProPlusRetail"> 
           <Language ID="en-us" /> 
       </Product> 
</Add> 
  <Updates Enabled="True" /> 
     </Configuration>

Office 365 clients to receive updates from the Office CDN

Client Settings

You can follow the steps tp receive updates from Office CDN. In the Configuration Manager console, click Administration > Overview > Client Settings.

Open the appropriate device settings to enable the client agent. For more information about default and custom client settings, see How to configure client settings in Microsoft Endpoint Configuration Manager.

  • Click Software Updates and select No for the Enable management of the Office 365 Client Agent setting.

Group Policy

Download and install the Administrative Template files (ADMX/ADML) for Office from the Microsoft Download Center.

Disable the Management of Microsoft 365 Apps for enterprise policy setting. You can find this policy setting under Computer Configuration\Policies\Administrative Templates\Microsoft Office 2016 (Machine)\Updates

Note – The Microsoft Office Click-to-Run Service is responsible for registering and unregistering Office COM applications during service startup. Change domain policy or Configuration Manager client settings require explicit Disable selection for Office COM to be successfully deregistered and restore the default configuration. Toggling Management of Microsoft 365 Apps for enterprise via Group Policy or Client Settings for Configuration Manager from Enabled to Not Configured is not sufficient.

Office 365 – Microsoft 365 App Report -Dashboard

Download the RDL file ‘Microsoft Office Client Management Dashboard’ Download and use the same the get below the dashboard. The highlighted section below links to the RDL file provided in the previous posts.

For larger environments, the pie charts have been selected as Top 10 in decreasing order of count which can be changed accordingly.

How to edit a report check Create Custom Report using Report builder.

SCCM Microsoft 365 App Report Dashboard | Part 2 | ConfigMgr
Microsoft Office Client Management | Understanding 365 Apps and Dashboard – SCCM Microsoft 365 App Report Dashboard | Part 2 | ConfigMgr

After uploading the report edit it in ‘Report Builder’, select the highlighted column in Report builder, and right-click to select ‘text box properties’.

SCCM Microsoft 365 App Report Dashboard | Part 2 | ConfigMgr
SCCM Microsoft 365 App Report Dashboard | Part 2 | ConfigMgr

Inside text box Properties, go to the Actions tab and select the option below, you have to browse the previous ‘Different Office Version’ Report here.

SCCM Microsoft 365 App Report Dashboard | Part 2 | ConfigMgr
SCCM Microsoft 365 App Report Dashboard | Part 2 | ConfigMgr

Do the same for the O365 Inventory report and browse the same in the other highlighted section in the first image and it’s done.

Now when you will run this dashboard report and click on the highlighted section it will redirect you to Raw Data for the same dashboard.

Conclusion

In this post, we learned about Different columns, how to Manage Office 365 updates with different options, Auto upgrade features, etc.

Wait for my next post which will be Part3 which will have some more useful information and will help you in Upgrading your Microsoft Office.

References

1 thought on “SCCM Microsoft 365 App Report Dashboard | Part 2 | ConfigMgr”

  1. I can see that you are referencing “Different Office Version” report. Where can i find that report? On the github there are 4 reports and none are “Different Office Version”
    Thank you

    Reply

Leave a Comment

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