Business Intelligence(BI) application is in high demand for every business as it helps decision-makers to take better decisions. 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 satisfy 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 which 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
- Download the SCCM Solution Template and install it.
- Configure SCCM Solution Template
- Download Power BI Desktop
Power Shell 5.0 is required to run SCCM Solution Template, to check the Power Shell version run the Get-host command.
Download the SCCM Solution Template
Now, download the SCCM Solution Template setup file from here and install it on the server. In this case, let's install it on the SCCM server.
Click on the Sign In button of you have a Power BI account else click on the Sign up free button. You required a 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 the installation file and run as administrator.
Click on the Install button.
Installation in progress.
SCCM Template has been successfully installed. After the installation, you need to configure it to access the data from the database.
Click on the Next button to start the configuration.
Provide credentials to connect to the SCCM database and validate it.
Provide the hostname of the database server and select the database after validation. In this case, the SCCM database server is localhost and the database is CM_KTM.
Provide a target database server and database name. Here, the source and target server and DB are the same, you can use different ones if you have more than one server.
Customize data synchronization time and retention policy.
Click on the Run button to generate the report file.
Click on the 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 the Next button.
Accept the license agreement.
Choose the installation path.
Click on the Install button to start the installation.
Click on the Finish button.
This is the Power BI Desktop console, now open that pbix file to see 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 the dashboard will be changed with 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.