SCCM Microsoft 365 Office Client Management Reports | Part 1

Let’s learn more about SCCM Microsoft 365 Office Client Management Reports. In this series of posts, I will share the RDL files for custom reporting of Microsoft 365 apps (a.k.a. Office 365 Pro Plus) reports.

Many organizations have already moved to Office 365, some are in the middle of upgrading, and some have yet to start. This post will help you with two reports to get the raw data with relevant information about Microsoft Office in your environment.

The Microsoft 365 Apps for enterprise updates can be integrated into the software deployment process. Clients only download necessary updates from the Distribution Point. Configuration Manager Administrators can download a cumulative build once from the internet and deploy it to all distribution points.

Select the Office 365 Client product from the products tab under Software Update Point Component Properties and synchronize software updates after the change. Once complete, Office 365 Client Updates populate the Office 365 Updates node under Office 365 Client Management within the Software Library tab in Configuration Manager Console.

Patch My PC
Index
Prerequisites-Microsoft 365 Office Client Management Reports
Microsoft Office Inventory
O365 Device Management Inventory
Uploading RDL File
Conclusion – Microsoft 365Office Client Management Reports
SCCM Microsoft 365 Office Client Management Reports | Part 1 – Table 1

PrerequisitesMicrosoft 365 Office Client Management Reports

Suppose you have SCCM Current Branch 1606 or above. In that case, Microsoft has configured the ‘Office365 ProPlusConfigurations’ hardware inventory as built into SCCM, so we don’t need to edit the MOF File to get the relevant information. If you have not yet enabled this Inventory class, follow the process below to allow it to do so.

  • In the Configuration Manager console, navigate to Administration > Client Settings > Default Client Settings. (Follow the same procedure if you have any custom client settings 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 - Fig.1
SCCM Microsoft 365 Office Client Management Reports | Part 1 – Fig.1

Microsoft Office Inventory

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

This Report Fetches Information from the Display name of installed software.

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

Adaptiva
SCCM Microsoft 365 Office Client Management Reports | Part 1 - Fig.2
SCCM Microsoft 365 Office Client Management Reports | Part 1 – Fig.2

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

O365 Device Management Inventory

After enabling the Hardware Inventory for ‘Office365ProplusConfiguration,’ we can get information about Clients that have 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 - Fig.3
SCCM Microsoft 365 Office Client Management Reports | Part 1 – Fig.3

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

Uploading RDL File

To learn how to start using Report Builder and create step-by-step custom reports, 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 - Fig.4
SCCM Microsoft 365 Office Client Management Reports | Part 1 – Fig.4

Click on Upload file, Browse to the RDL file downloaded and then Click OK.

SCCM Microsoft 365 Office Client Management Reports | Part 1 - Fig.5
SCCM Microsoft 365 Office Client Management Reports | Part 1 – Fig.5

Click on the Browse button.

SCCM Microsoft 365 Office Client Management Reports | Part 1 - Fig.6
SCCM Microsoft 365 Office Client Management Reports | Part 1 – Fig.6

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 - Fig.7
SCCM Microsoft 365 Office Client Management Reports | Part 1 – Fig.7

After clicking on Manage, go to Data Sources>>Browse and Select the Data Source for your environment, and then click Apply.

SCCM Microsoft 365 Office Client Management Reports | Part 1 - Fig.8
SCCM Microsoft 365 Office Client Management Reports | Part 1 – Fig.8

ConclusionSCCM Microsoft 365 Office Client Management Reports

In this post, two Raw Reports provide information on Different Office Versions and Information on the O365 Inventory. Follow my next post to learn how to merge these reports into a dashboard.

References

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

Author

Ankit Shukla, an IT professional with over seven years of experience, has worked on SCCM/MECM since 2012. During this time, he has extensively dealt with various aspects of the tool, such as migration, infrastructure designing, OSD, custom SQL reporting, and client-side troubleshooting. Ankit’s blog posts reflect his hands-on experience addressing issues and providing practical solutions. The primary aim of his posts is to cater to the audience, comprised of support team members and SCCM admins in organizations.

8 thoughts on “SCCM Microsoft 365 Office Client Management Reports | Part 1”

  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.

    Reply

Leave a Comment

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