Let’s find out more details about SCCM Microsoft 365 Office Client Management Reports. I this series of posts, I will share the RDL files to get custom reporting of Microsoft 365 apps (a.k.a Office 365 Pro plus) reports.

Introduction

Many organizations have already moved to Office 365, some will be in the middle process of getting it upgraded and some might be yet to start. This post will help you with two different reports to get the raw data having relevant information about ‘Microsoft Office’ in your environment.

Prerequisites

With having SCCM Current Branch 1606 or above Microsoft has configured ‘Office365 ProPlusConfigurations’ hardware inventory as inbuilt in SCCM due to which we don’t need to edit the MOF File to get the relevant information.If you have not yet enabled this Inventory class to follow the below process to enable it.

  • In the Configuration Manager console, navigate to Administration > Client Settings > Default Client Settings. (follow the same if you have any custom client setting defined).
  • On the Home tab, in the Properties group, click Properties.
  • In the Default Client Settings dialog box, click the Hardware Inventory.
  • In the Device Settings list, click Set Classes.
  • In the Hardware Inventory Classes dialog box, select Office 365 ProPlus Configurations.
  • Click OK to save your changes and close the Hardware Inventory Classes dialog box.
SCCM Microsoft 365 Office Client Management Reports | Part 1 - ConfigMgr
Microsoft Office Client Management | Enabling Office 365 ProPlus Configuration – SCCM Microsoft 365 Office Client Management Reports | Part 1 – ConfigMgr

Microsoft 365 Office Client Management Reports

Microsoft Office Inventory

The RDL file provided for the first report tells about different versions of Office in your environment, the report has been created with a custom column, it can be modified accordingly and more columns can be added.

This Report Fetches Information from Display name of installed software.

Note – The custom column provide information about Office 365, Office 2013 , Office 2010 and Other versions.

SCCM Microsoft 365 Office Client Management Reports | Part 1 - ConfigMgr
Microsoft Office Client Management | Different Microsoft Office Versions – SCCM Microsoft 365 Office Client Management Reports | Part 1 – ConfigMgr

Download the rdl file ‘Microsoft Office Version’ from – Microsoft-Office-Client-Management

O365 Device Management Inventory

Post enabling the Hardware Inventory for ‘Office365ProplusConfiguration’, we can get information about Clients that are already upgraded to Office 365.

The information includes different languages, versions, channels, settings regarding auto-updates in your environment, etc.

SCCM Microsoft 365 Office Client Management Reports | Part 1 - ConfigMgr
Microsoft Office Client Management | Office 365 device Inventory – SCCM Microsoft 365 Office Client Management Reports | Part 1 – ConfigMgr

Download the rdl file ‘O365 Device Management Invenory’Microsoft-Office-Client-Management

Uploading RDL File

On how to start using Report builder and creating step by step custom report follow the article SCCM Create Custom Report Using Report Builder.

  • Type the URL of your report server in your web browser, by default the URL is https://<servername>/reports
SCCM Microsoft 365 Office Client Management Reports | Part 1 - ConfigMgr
Microsoft Office Client Management | how to upload rdl file – SCCM Microsoft 365 Office Client Management Reports | Part 1 – ConfigMgr
  • Click on Upload file , Browse to the RDL file downloaded and then Click Ok.
SCCM Microsoft 365 Office Client Management Reports | Part 1 1
Microsoft Office Client Management | how to upload rdl file
SCCM Microsoft 365 Office Client Management Reports | Part 1 2
Microsoft Office Client Management | how to upload rdl file
  • After clicking on OK you will see your report as above, you will see a drop-down if you move the mouse on the right side of your report, click on that, and then select Manage.
SCCM Microsoft 365 Office Client Management Reports | Part 1 3
Microsoft Office Client Management| how to upload rdl file
  • After clicking on Manage, Go to Data Sources>>Browse and select the Data source of your environment and then click on Apply.
SCCM Microsoft 365 Office Client Management Reports | Part 1 - ConfigMgr
Microsoft Office Client Management | how to upload rdl fileSCCM Microsoft 365 Office Client Management Reports | Part 1 – ConfigMgr

Conclusion

In this post, we have got two Raw Reports which will provide information on Different Office Versions and Information on O365 Inventory, Follow my next post to know how we can merge these reports into a dashboard.

References

1 COMMENT

  1. Hi thanks ,i got an error when trying to upload the .rdl file

    An error has occurred.
    The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the settings into XmlReader.Create method.

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.