SCCM Microsoft 365 App Report Dashboard | Part 2 | ConfigMgr

0
SCCM Microsoft 365 App Report

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 rdl file and see how can we interlink previous post with this one.We will also understand few Columns which we have enabled in 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 update channels you can control how often your organisation get the new features.

Different Types of channels

New namePrevious name
Beta ChannelInsider
(sometimes referred to as Insider Fast)
Current ChannelMonthly 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

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 Overview of Update channels

Columns of O365ProplusConfigurations

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

ColumnsDescription
HostnameHostname of machine
Architecturex86 or x64
Versionversion 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 controlled manner.This Columns tells us the information of if auto update is ‘enabled’ or ‘disabled’.

Below are 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 three methods which can be used so that Office 365 clients can receive updates from Configuration Manager.

Client Settings
  • 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 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
  • 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 application during service startup. Change domain policy or Configuration Manager client settings require explicit Disable selection for Office COM to be successfully deregistered and restore 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.

For more detailed information check Managing 365 Apps.

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 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 Actions tab and select the option as 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 O365 Inventory report and browse the same in the other highlighted section in first Image and its 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 feature etc.

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

References

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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