System Center Configuration Manager

[johnagillespie]

There is a blog post over in Technet about how to access System Center Configuration Manager data using PowerBI

http://blogs.technet.com/b/in_the_cloud/archive/2015/05/04/getting-started-with-sccm-amp-power-bi.as...

However the workbook is no longer available. Is there an System Center Configuration Manager Content Pack or would anyone be prepared to share theirs?

[nageshkumarapp]

The Power BI SCCM 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. Material from blog. Read more 

Thank you.

[sandralynn]

Hello,

This Power BI document enables you to view site information from (SCCM) System Center Configuration Manager 2012. It provides a basic overview for things like client overview, workstation and server breakdown, client health, update, endpoint and site admin.

With a Power BI solution template for SCCM, you can set up the Power BI dashboard with just a couple of clicks.

Thanks.

[johnagillespie · Accepted solution]

Found a Dashboard here and got it working without any problems.

https://gallery.technet.microsoft.com/Power-BI-SCCM-Dashboard-d1b7e688

A nice job - saved us a lot of time.

[RafDelgado]

@johnagillespie thanks for promoting the link.

1.4 is now  out for anyone coming across this, updated for June BI update.

http://www.sysctr.info/2016/07/announcing-poweron-bi-configmgr.html

[Greg_Deckler]

There is no content pack that I am aware of, but SCCM uses Microsoft SQL Server for its database so it is just a matter of connecting to the SQL Server instance and importing the various tables (there are lots and lots) which is probably what you are looking for I presume, for someone to have pulled the important tables and columns. But if it is just a matter of connecting to it, a power query data source of SQL Server will do it.