July 2020’s free Microsoft Endpoint Manager Configuration Manager (ConfigMgr/SCCM/MEMCM) giveaway is the Microsoft Office 365 dashboard. This dashboard is available in both Power BI and SSRS formats.
Why do you need this dashboard? Keep reading below!
With ConfigMgr you can manage Microsoft Office 365 (sometimes referred to as Office 2016 and Office 2019) licenses through the dashboard found in the ConfigMgr console, but this dashboard could be better. Managers, the ITAM team and Microsoft Office online teams shouldn’t need to access the ConfigMgr console just to see what versions of Microsoft Office 365 are installed, so first and foremost, this dashboard should be a report.
Along that same vein, it is only from within the console that you can see who has what version of Microsoft Office 365 by clicking on each item and creating a special device query.
From an auditing standpoint, how can you record who has what by using the special device query? There is no nice way to create an audit report for your ITAM team from these results.
Additionally, you can only query on one device attribute from the dashboard. For example, there is no means to locate all x86, semi-annual channel, 1808 versions of Microsoft Office 365.
Here’s another problem: the ConfigMgr console dashboard uses the build version (16.0.12827.20336, 16.0.10730.20102, etc.) for its reporting, but when most companies talk about versions they refer to 2005, 1808, etc., and not build versions. Sometimes companies, including Enhansoft, call the build version, the version number. That’s not exactly wrong, but it’s not exactly right either. In the console, the build version is listed as the version number, but it’s not the true version number. You can only find the correct version number by viewing the Update history for Microsoft 365 Apps. Will all of your teams, including managers, know where to find this link?
In all of these cases, wouldn’t it be great to have a report that can be used for auditing purposes, looks-up and translates the build version information, and can be accessed by everyone who needs it outside of the console?
Solution: Microsoft Office 365 Dashboard
This report is close in design to the Microsoft Office 365 dashboard found within the ConfigMgr console. Unlike the console report, however, this dashboard provides you with the normalized version numbers of Microsoft Office 365. It also displays the channel type, architecture (x64/x86) and language details.
You can mix and match the filters (or prompts in SSRS) to see which computers meet your specifications. The Office 365 related prompts leverage a multi-select option, so you can see the selected values for a particular filter.
Similar to any other ConfigMgr dashboard or report, by having this report on your reporting services point, you can grant others access to it without having to provide them with access to the ConfigMgr console.
Note: The normalized Microsoft Office version details found within the Power BI dashboard are taken directly from the Microsoft Office documentation webpage. An internet connection is required for this report to work correctly. The normalized details in this dashboard are updated as the webpage is updated. In the SSRS dashboard, the normalized Microsoft Office version details are manually updated, at a minimum, on a monthly basis. As a result, if you see that a version number is NOT normalized, please ensure that you are running a current version of Enhansoft Reporting or contact the support team.
One of the best parts about the SSRS dashboard version is that, not only can you export it to a PDF and print it (the columns all fit nicely onto one page) but you can setup an email subscription to this report. Once a subscription is setup, the report is emailed to you at scheduled times. This feature is also available in a number of Enhansoft Reporting’s dashboards/reports. For more information about how to setup an email subscription, please see this post, How to Set-up an Email Subscription in SSRS.
Enhansoft Reporting – Microsoft Office 365 Dashboard
The Microsoft Office 365 dashboard is found within Enhansoft Reporting’s Microsoft Office category. This category of dashboards and reports provides you with important details about the different versions and applications of Microsoft Office in your environment. This includes Microsoft Office 365 and Microsoft Office Add-ins. These reports also remove duplicate entries to ensure that you have the most accurate count information about your Microsoft Office licenses. In the footer of all reports, you see when the Microsoft Office data was last queried from SCCM. You can even have these dashboards and reports emailed to administrators at scheduled times!
Would you find it useful to see a list of all Microsoft Office 365 versions in one report? Then get the Microsoft Office 365 dashboard now!
Are you looking for another ConfigMgr/SCCM/MEMCM report? Are you looking for Power BI reports? Do you find that Configuration Manager reporting is difficult? Reporting shouldn’t be hard and with Enhansoft Reporting’s 150+ reports, sorted into 26 different categories, we make it easy for you!
Find out more about the reports in Enhansoft Reporting by clicking on any of the 26 category buttons below.
Still not sure that we have the right report for you? Just ask and we will be more than happy to help you out! Send a note to TechTalk@enhansoft.com.
All of our free reports have the Role-Based Administration (RBA) feature enabled. This means that whether you are using Configuration Manager Current Branch or System Center 2012 R2 Configuration Manager, these reports will work with all RBA settings.