Power BI – SCCM Dashboard Reporting

Update 07/07/2016

Version 1.4 is now out, please refer to below link to view the latest version.

PowerON Power BI – ConfigMgr Dashboard

So I’ve recently joined the PowerOnPlatforms team and I’ve been working with SCCM and Power BI to develop some reporting dashboards I wanted to share :). This report displays some overview information for visually seeing a sites SCCM configuration through the free Power BI desktop.

Client Overview

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

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 goes off to a technet page so you may need internet access when initially loading your data.

Client Health Summary
Contains summary information on your clients health and activity status.
Update Compliance
This view contains a breakdown for update compliance, showing you missing updates by bulletin ID.

EndPoint Compliance

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

Site Admin

Now this is the cool part… The site admin view queries the configmgr dogs technet post for the latest SCCM release. It also queries the Microsoft support life cycle site and checks for expired or expiring operating systems currently deployed which you will need to address.

The Deployed Expired/Expiring Operating Systems slicer also allows you to filter the OS to give you an indication of whats expiring by count.

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.
The great thing about publishing is you can utilise the ask a question feature which is awesome!
Power Bi also comes with a mobile app which allows you to access the report from your mobile device anywhere too.
Hopefully you’ll love the dashboard as much as I do now :). Feel free to leave feedback or if you have any ideas which may improve or add to this, feel free to contact me via twitter at @Raf_Delgado or comment below.

Update 1.1

Added DB Fragmentation Report into the dashboard. SQL query from Kent Agerlund’s NIC 4th Edition.

16 thoughts on “Power BI – SCCM Dashboard Reporting”

Leave a Reply

Your email address will not be published. Required fields are marked *