Powerbi Analyze data and KPI presentation from the SCCM database

Tag: Cloud Platform for Cloud computing

Before the introduction of Powerbi can get data from scom to analyze the beautiful presentation, today you can also introduce Powerbi can get SCCM SQL data for more cool data analysis show, before this site need to download a visual view template

Https://appsource.microsoft.com/en-us/product/web-apps/microsoft-powerbi.pbisolntemplate_sccm?tab=overview

Then download, here you can see the minimum SCCM version requirements and the SQL version requirements, as well as the required prerequisites for Microsoft. NET Framework version 4.5 or later & PowerShell 5.0 or later

Install this microsoft-sccmtemplate.exe on a machine installed with Powerbi desktop after the download is done

Then install the WMF 5.0:https://docs.microsoft.com/en-us/powershell/wmf/5.0/requirements

After the installation is completed, reboot and reboot to open the SQL Manager on the server where Powerbi and Microsoft-sccmtemplate.exe are currently installed, create a new database Cm_001_pbix, Used to extract the data we need from the SCCM SQL database (also understood as data cleansing), and set the option Recovery mode of the database to simple mode

Next open the Microsoft-sccmtemplate application as an administrator

Next

Enter the Windows access account and password that can access the SCCM database

Enter the SCCM database server name and SCCM database information

Enter the server name of the target database and which database (that is, the location and name of the database we extracted, the new Cm_001_pbix database)

Define daily trigger times and data retention times

Click Run

Wait for the run to complete

Do not close the dialog box, wait 10-15 minutes to finish running

Scroll down the slider bar after the run is complete

Download Powerbi report file, save to desktop

This file saved on the double-dot desktop Solutiontemplate.pbix automatically opens Powerbi desktop and clicks "Apply Changes"

Switch to Overview overview, click Refresh

Once the refresh is complete, a visual view of the page's blank has become visible, reflecting the data of the current SCCM metrics

You can also switch to the Protection tab to view the related metrics that are protected

and the safety index of the virus type and overall environment

Update for Windows update

Software Asset situation

These reports feel is not cool, and casually click on any of the items you want to see, all the data will be linked to show, such as I want to see a specific server on the software assets, then tick want to see this server name, immediately other visual view linkage show told me, very cool

Believe this cool, interactive data bi Analytics presentation will make your operations management work even more handy.

Powerbi Analyze data and KPI presentation from the SCCM database