Introduction

This dashboard is a new design, has more information and built with current branch in mind...

If you never had the opportunity to use the previous iterations of the ConfigMgr dashboard (Link), it utilises Microsoft Power BI to connect to your Microsoft Configuration Manager database and display powerful visuals and data about your environment. It replaces the old Power BI dashboard and is designed to work on Current Branch versions of Configuration Manager.

 

Power BI desktop is free to download and you can just run that to view the reports. You can also publish them up to Power BI for a full dashboard experience.  

 

Version

   1806.1.0.0.3 Update Version

   1806 Update Version

 


   1802 Release Version

- Completely new design

- Improved SQL Queries


  Pages Includes

- Devices

- Applications

- Collections

- Users

- Client Health Summary

- Update Compliance

- Update Assignment

- EndPoint Compliance

- EndPoint Threat Detection

- Device Encryption

- Device TPM

- Devices Win 10 Servicing

- OS Support LifeCycle

- Admin Center

- Site Updates and Servicing

  

Devices

The Devices page replaces the old workstation and server breakdown page as you can now filter the page by OS type and even by collections respectively.

The devices page contains overview information for your managed devices. View client compliance, see last activity date, drill down from manufacturers right down to Bios manufacturers and installation dates.

 

  

 

Applications

The applications page contains visuals relating to application deployment. It allows you to see the overall deployment state, overview information for the application and creations dates.

 

    

 

Collections

The Collections page allows you to see collections by member count, view collections by scan times and even membership.

Another useful use for this page is gaining visibility over collections which could potentially be causing performance issues by running unnecessary evaluation scans.

 

  

 

Users

The User's page gives you a broader picture of a user's device usage. It contains overview information for the last recorded device user login and primary user status.

We've also included some useful visuals on the number of user logins and average device usage time.

 

  

 

Client Health Summary

The Client Health Summary page returns with enhanced visuals for scan statuses and last management point communication.

 With the improved relationships across the tables, the devices overview also has more information than before.

 

  

 

Update Compliance

Updates have had a significant overhaul in this new dashboard; the Update Compliance page contains overview information for updates where they are deployed, enabled and not superseded.

You can see the overall compliance for an update by devices, get a breakdown for updates by the OS and even a matrix for whether an update is marked as installed or required.

 

  

 

Update Assignment

In addition to Update Compliance, the Update Assignment page gives you visibility over software update group assignments and their compliance.

You can see how many devices the assignment is targeting, the date a software update group was assigned and much more.

 

  

 

 

EndPoint Compliance

The EndPoint Compliance page contains visuals for viewing your devices EndPoint state. The view comprises of visuals for EndPoint client and engine versions, signature age and general protection status.

 

 

EndPoint Threat Detection

The Threat Detection page is another page to have an overhaul, we've added more information about the remediation and threat type.

 

 

Device Encryption

This page requires the BitLocker hardware inventory class enabling. It contains overview information for device encryption, including protection status, encrypted drive letters and the chassis type for the encrypted device.

 

  

 

Device TPM

The Device TPM page contains visuals for check TPM readiness, ownership, activation and more. Note, this page requires the TPM and TPM Status classes in hardware inventory enabling.

 

  

 

Devices Win 10 Servicing

With Windows 10 servicing added as part of Current Branch, the Devices Win 10 Servicing page compliments this by displaying managed Windows 10 devices by branch version and state.

 

  

 

OS Support Lifecycle

The OS Support Lifecycle page contains information about managed workstation devices and their OS support lifecycle. The lifecycle information is retrieved from Microsoft's lifecycle support factsheet and joined with the ConfigMgr database to return the start and expiration for Windows 7 and above operating systems.

 

  

 

Admin Center

This page is a valuable asset for admins. It contains overview information for the ConfigMgr Site and informative blogs from the Microsoft Technet Blog site.

 

  

 

Site Updates and Servicing

The Site Updates and Servicing page is a new page for assisting with the current branch updates and version guidance.

 

 

  


Prerequisites

- Configuration Manager Current Branch (Tested on 1710 or Above)

- Minimum SQL data reader rights to connect to the Configuration Manager Database

- Internet access from the device with Power BI Desktop

- The latest Power BI Desktop (Download Here)

- Download the PowerON Power BI ConfigMgr Dashboard template file

- recommended BitLocker, TPM and TPM Status hardware inventory classes enabling for Device Encryption and TPM information pages

 

Setup

1. Download the latest Power BI Desktop

2. Before attempting to open the template file, open Power BI Desktop first

3. Go to File > Options and Settings > Options > Security

4. Under Native Database Queries, untick Require user approval for new native SQL queries

5. Close the open Power BI desktop and open the template file

6. Enter the SQL server or instance name where the Configuration Manager site database is located

7. Enter the SQL database name for the Configuration Manager site

 

  

8. If prompted, click OK the authentication methods and encryption support prompt.