First published on TechNet on Aug 27, 2018
Hello again everyone! Christopher Scott, Premier Field Engineer here. Recently I have been developing a lot of data insight reports for various datasets and customers and thought I would wrap them up and share the wealth.
The first report template I am sharing was made to provide a general overview of the SCOM environment. Below are some important configurations that can be tailored to your environment as well as an outline of the various pages and the data represented within them as well as the download links for the template and PowerBI desktop:
Template can be downloaded from https://github.com/Cj-Scott/SCOM-Dashboard-Report-Template-in-PowerBI/find/main
PowerBI Desktop can be downloaded for free from https://powerbi.microsoft.com/en-us/downloads/
If you are importing from the template file you will be prompted for the "SCOM DB Instance", "SCOM DB", "SCOM DW Instance " and " SCOM DW ". Fill these fields with the appropriate SQL information for your environment and click ok.
If you are using the PBIX file:
Once you open the PowerBI file the first thing you will need to do is configure the data source by editing the parameters. You can do this simply by clicking the "Edit Queries" button on the Home Toolbar and then selecting "Edit Parameters"
Replace the "SCOM DB Instance", "SCOM DB", "SCOM DW Instance " and " SCOM DW " fields with the appropriate SQL information for your environment and click ok. Continue to click OK or Run to allow the Native queries to run and import the data.
There are 3 tables that we have implemented conditional columns to generalize or group data for easier viewing. These settings may need to be altered to meet your needs. Agents Requiring Attention: I use a conditional column here to translate between different health state codes into a friendly name. Below I outline where to find the specific settings.
Application Group Transforms: To limit the number of redundant groups listed ion the filter views we created a conditional column to group like groups by display names. These will most likely need to be edited to fit the needs of your environment. Access to these settings are outlined in the images below.
I hope these reports give you the necessary data points to empower your organization. Please feel free to comment below with any feedback or ideas that you would like to see templated or improved. I also want to thank some fellow PFE's in the SCOM field so shout out to Ted Teknos, and Mark Hawver for your guidance and insight into what data is valuable and what is not.
Thanks for reading!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.