Announcing the Power BI solution template for System Center Configuration Manager

Today we are excited to announce the release of the Power BI solution template for System Center Configuration Manager. The Power BI dashboard provides detailed information of your System Center Configuration Manager including client and server health, malware protection, software updates, and software inventory across your organization. You can compare key System Center Configuration Manager metrics to personalized targets and see how they trend over time. You can also identify trouble spots and get the information you need to understand what needs to be done.

The first page provides a high level overview of key SCCM metrics to quickly identify machines not up-to-date with software updates, failed mitigations to malware infections to be able to act promptly, failed updates and more:

You can click through to get more detailed information in each area. For example, the Missing Updates report lists missing updates by severity and device that can be used to take action:

Extensibility

The solution template is scalable and extensible. This means if you have additional requirements – whether it’s to check deployment status for operating system, identify machines with 3rd party license agreement – they can be achieved by either engaging our partners who are fully skilled up in the SCCM solution template or tweaking things yourself!

Deployment & Cost

With a Power BI solution template for SCCM, you can set up the Power BI dashboard with just a couple of clicks. Behind the scene, we will spin up a ETL pipeline to incrementally pull data out of Configuration Manager database and push the data into a SQL database. All you need is read access to Configuration Manager database, an Azure SQL (preferred) or an on-premises SQL Server instance, and a Power BI Pro subscription. Estimated Azure SQL database sizes with number of devices managed by SCCM are following:

* data retention is set at 180 days

Try it out & let us know

Go ahead and check out the SCCM solution template by visiting our page. Please let us know what you think. You can reach the team by e-mailing us at PBISolnTemplates@microsoft.com or leaving a comment on the Power BI Community page for solution templates.