Forum Discussion

johnagillespie's avatar
johnagillespie
Icon for Advocate I rankAdvocate I
10 years ago
Solved

System Center Configuration Manager

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.aspx

 

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

 

 

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    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.

  • sandralynn's avatar
    sandralynn
    Regular Visitor

    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.

  • 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.