Announcing the PowerON BI ConfigMgr Dashboard 1611

NB. Please note this article is now out of date; links/downloads may not function as originally intended.

 

The next installment of the Power BI Configuration Manager Dashboard is here!

We’ve been busy making some changes to the successful 1.4 version which we brought out back in July. We’re now over 4000 downloads on the technet gallery and can’t believe the positive response from the community.

With the ever progressing Power BI (BI) and Configuration Manager (ConfigMgr) updates, we had to address a few problems with query and website changes. I took the decision to wait for this version rather than release a quick fix as we were so far into this one and wanted to get this version out asap.

With this version, we’ve taken the approach to change naming convention in line with ConfigMgr, moving to a Year/Month format. This should make it easier when BI and ConfigMgr receive updates, as we can release a tested version based on a ConfigMgr or BI release.

I hope you’ll enjoy the update and the improvements we’ve made to it :)

Version 1611 Release Notes

  • Tested with November 2016 Power BI desktop update
  • Workstation Admin Breakdown consolidated to one page.
  • Site Admin Page Redesign.
  • Ability to drill down through deployed OS support lifecycle added
  • Windows 10 Breakdown page added (Tested on CM 1602 and above)
  • Minor visual changes to page layouts.
  • Managed Mobile Devices page updated to include information table.
  • Chassis Type table changed to custom table.
  • Client version web query fixed after table column was changed.
  • Support Life Cycle query fixed after MS changes. Now changed to api call and updated some of the naming conventions.
  • SCCM Technet blog feed added.
  • DB Fragmentation page visual updated to include min/max on saturation and URL link added.

Client Overview

This view contains a basic overview of client information such as, EndPoint Compliance, Client Activity and Health.

 Client Overview

Workstation / Server Breakdown

This contains a breakdown of your site workstations/Servers including manufacturer, operating systems, architecture and even chassis type info! The Chassis Type information now built into the report and workstation admin page consolidated into main page.

Workstation Breakdown 

Server Breakdown

*NEW* WINDOWS 10 BREAKDOWN

This contains a breakdown of your Windows 10 workstations including things like branch and OS version.

 Windows 10 Breakdown

Client Health Summary

Contains summary information on your clients health and activity status. Client Health Summary

Update Compliance

This view contains a breakdown for update compliance, showing you missing updates by bulletin ID. Update Compliance

EndPoint Compliance

This view contains summary information on client EndPoint compliance and protection status. EndPoint Compliance

*New* Site Admin

The site admin view has been completely revamped. With changes to the support lifecycle page, it stopped the query from pulling back information. We’ve updated this to now include a drill down for Mainstream, Extended and Service Pack end dates. We’ve also included the technet blog feed and site information to really made this page usefl for keeping on top of updates.  Site Admin

Managed Mobile Devices

 This view contains summary information on Managed Mobile Devices in ConfigMgr. It allows you to view things like Make and OS version of devices connected. We’ve updated the visuals and included a table view for additional information.  Managed Mobile Devices 

DB Fragmentation 

DB Fragmentation Report into the dashboard. SQL query from Kent Agerlund’s NIC 4th Edition. Updated saturation visual to highlight on min/max value.   DB Fragmentation

Installation

You can download the dashboard from the Technet Gallery  Ensure you have at least read access to the SCCM SQL Database and you can access the Internet from the machine running Power BI. Download the lastest Power BI desktop. Once installed Open Power BI. 1. Go to File > Options and Settings > Options. 2. Under Privacy enable Fast Combine to file privacy.Privacy Levels 3. Under Security untick “Require user approval for native SQL database queries”. Native Queries 4.  Select Edit Queries to load the Query Editor. Edit Queries 5. Supply parameter information in the Setup section Setup  6. Select the “_Client Information” query under the ConfigMgr and supply any credentials required to access the database. Credentials 7. If prompted, Click OK on the encryption support message. Encryption 8. Close the Query Editor and load the data 

Publishing to the Web

The desktop version of Power BI is free to use and I used this without publishing the report up to the web just to produce a quick report. The data is on this report is not live as its only from the last time you load the data but you can easily reload the information on startup. For an even better experience, you can publish the file up to the web and create a dashboard.  though there can be cost implications but there is a free version.  Check on Power BI’s website for further information on what best suits you.                       Web Dashboard The great thing about publishing is you can utilise the ask a question feature which is awesome!  

                              Natural Query

 Power Bi also comes with a mobile app which allows you to access the report from your mobile device anywhere too. Mobile Dashboard  For advanced support, customisations or consultancy contact the PowerON team 

If you are looking for managed IT support and think you could benefit from PowerON’s consultancy services and solutions, please get in touch on +44800 302 9280.

Related resources

What Makes a Secure PKI Solution? Access Control

Apart from obvious server security aspects such as patching, with PKI solutions there are also considerations relating to cryptography and even physical access. These are rarely documented as a consolidated list, so we decided to try and lay out what we look for and why in a PKI solution.

A Blog About the C Word

Every seems to be talking about virtual Christmas parties at the moment – but how on earth are we supposed to hold virtual parties without our colleagues dying of boredom? Here’s a few ideas for bringing people together…

What Makes a Secure PKI Solution? RSA vs ECC

Apart from obvious server security aspects such as patching, with PKI solutions there are also considerations relating to cryptography and even physical access. These are rarely documented as a consolidated list, so we decided to try and lay out what we look for and why in a PKI solution.

What Makes a Secure PKI Solution? Multiple Tiers

Apart from obvious server security aspects such as patching, with PKI solutions there are also considerations relating to cryptography and even physical access. These are rarely documented as a consolidated list, so we decided to try and lay out what we look for and why in a PKI solution.