post banner

Power BI Dashboard for System Center Configuration Manager

Author: Sakaldeep

July 13, 2017

Business Intelligence(BI) application is in high demand for every business as it helps decision makers to take a better decision. IT infrastructure management and monitoring cannot be left untouched. Microsoft has built the System Center Configuration Manager(SCCM) Power BI Solution Template, the template contains everything needed for an SCCM dashboard with actionable analytics. The System Center Configuration Manager (SCCM) Power BI dashboard provides detailed information of your SCCM instance including client and server health, malware protection, software updates, and software inventory across your organization to give you a clear picture of your IT infrastructure.

The expertly designed Power BI reports satisfying all skill levels. Summary pages are targeted at managers and executives and detail pages are designed for experts to drill down and take action. Below is the summary dashboard based on that you can identify which area is up-to mark and which area needs improvements.

 

Details dashboard for Software Updates Missing. These dashboards are smart enough to help you, for instance, if you click on update id MS10-013 then it will show all the computers/servers missing the particular update. If you click on a machine called WIN7 then it will show all the missing updates for the WIN7 computer.

High level Step to deploy SCCM Solution Template

  1. Download the SCCM Solution Template and install.
  2. Configure SCCM Solution Template
  3. Download Power BI Desktop
  4. Dashboard

Prerequisite

Power Shell 5.0 is required to run SCCM Solution Template, to check the Power Shell version run Get-host command.

Download the SCCM Solution Template

Now, download the SCCM Solution Template setup file from here and install on the server. In this case, let's install on SCCM server.

Click on Sign In button of you have Power BI account else click on Sign up free button. You required business email id for free sign up.

Once you have signed in you will need to allow access to the Business Platform Solution Template. Click Accept to do this.

Click on Download Button to download the setup file.

Right click on installation file and run as administrator.

Click on Install button.

Installation in progress.

SCCM Template has successfully installed. After the installation, you need to configure it to access the data from the database.

Click on Next button to start the configuration.

Provide credentials to connect to SCCM database and validate it.

Provide host name of the database server and select database after validation. In this case, SCCM database server is localhost and database is CM_KTM.

Provide a target database server and database name. Here, source and target server and DB is the same, you can use different if you have more than one server.

Customize data synchronization time and retention policy.

Click on Run button to generate report file.

Click on Download button to download the reports.

Save the reports to the local server. The report will be saved in pbix format, to the report you need to install an application called Power BI Desktop.

Install Power BI Desktop

Download from here and install.

Run the installation file and click on Next button.

Accept the license agreement.

Choose installation path.

Click on Install button to start the installation.

Click on Finish button.

This is Power BI Desktop console, now open that pbix file to see all the dashboard.

Click on Apply Changes and wait to load the data.

Data has populated from DB and Power BI Dashboard is here. The beauty of this dashboard is if you click on the particular server name then all the data of dashboard will be changed respect to that server. For instance, if you click on ENADOC Server then the dashboard will show all the software installed on ENADOC Server and so on.

Dashboard for Endpoint Protection.

Dashboard for all the malware detected by SCEP.

Total visits : 4466