Version 1.4 is now out, please refer to below link to view the latest version.
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.
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.
This view contains summary information on client EndPoint compliance and protection status.
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.
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.
Added DB Fragmentation Report into the dashboard. SQL query from Kent Agerlund’s NIC 4th Edition.