PowerBI SCCM Imaging Dashboard

Here’s some simple PowerBi dashboard to give quick insight into Imaging and Distribution point usage in your environment.

A Few months back I came across this awesome SCCM Dashboard on Technet by Raf. If you haven’t seen it you need to get it! He makes it really easy to get quick insights into your SCCM environment and Client health.  My dashboards or kind of an extension to Rafs. After playing with it I found there were a few dashboards that needed to added for Client imaging and Distribution point reporting! I wont go into detail about how to edit the dashboard but Raf’s post lays it all out very clearly.

 Client Imaging dashboard

Imaging Summary

You’ll need to edit a few things in this code specific to your environment. first is the Deployment ID for each of your Task sequence deployments. This is easy to find int he Console.  I also have some custom inventory views there for where we write our OEM info into the registry with our Image version. You can remove this view or point it to where you inventory your image version info. Also because we use the country ISO code in the  first part of the computer name, i am able to use that to create the Geo location map. If you don’t have somethign in the name to identify the location of the computer I’ve seen some put Location information on their AD sites or create custom WMI values to specify this information.  As with all things SCCM, every environment is different. Let me know what works best for you!

Hardware Summary

I like to keep tabs on what hardware is getting imaged the most in the environment which helps me know what models to prioritize when updating driver packs and software packages. The data for this dashboard is collected by the same query as the Client imaging. Its just filtering for the make, model and chassis info.

ImagingHardware

DP Usage Summary

Another set of data I find to be very useful in my environment is DP usage. I only place distribution points where there is a lot of Imaging going on or there a large amount of Clients but not a lot of bandwidth.  This dashboard helps me keep an eye on whats being used the most or not enough which helps me ask the question.. do we still need it there?  The nice thing is all the data is already being collected by the DP’s and its easy to see how much Bytes are sent by each DP, how many clients are making requests, etch.

Dp Imageing Usage

You shouldn’t have to modify too much here. The only thing might be the Sub-string Selection to tie the PKGServer name to the V_R_Systems name. This is how i pull in more information about the DP like Model information and OS.

 

Thats it for now. Let em comment if you have any questions. Im NOT a sql or PowerBI guru but i hope this helps you

Leave a Reply