SCOM Data Source for Grafana: Ping Dashboard Example Part 3

In this article we will build a Dashboard solution for our Ping MP. You need to have the Data Source installed and configured and aslo our Ping MP to be able to follow this. You also need the plugin Polystat installed.

In the last part of this series of articles we created an Status pane to display number of instances with different Health Status. In this article we will extend the dashboard and create a pane with the status of each instance (which we in later articles will do clickable so we can see more details about each instance).

1. Start by editing the Dashboard we created in part 1 and 2 by click the Edit button.

PingDashboardp3-1

2. Then press the Add button and choose Visualization.

PingDashboardp3-2

3. Make sure you have th SCOM Datasource selected for the Query and then press Health.

PingDashboardp3-3

4. For the Class we choose "Target Host" and for the Instances we choose "*". Then we press Search.

PingDashboardp3-4

5. Now we change the Visualization to the installed plugin Polystat. And as you can see we get each instance displayed but not in a very good way.

PingDashboardp3-5

6. In order to display it in a better way we need to do some transformation on the data. Go to the Transformations tab and press "Add transformation"

PingDashboardp3-6

7. Choose the transformation "Organize fields by name".

PingDashboardp3-7

8. Disable everything except "Healts state int" and "Class instance name".

PingDashboardp3-8

9. Like in the last part where we get the data in the wrong format we need to do yet another transformation to change the rows to fields. Click the "Add another transformation"

PingDashboardp3-9

10. Choose the transformation "Rows to field". No other configuration is needed for this transformation.

PingDashboardp3-10

And as you can see we now get the instance name as we wanted. Now we will hide the value for the Health State int.

PingDashboardp3-11

11. To hide this value we go to the Panel Option and scroll down to the "Global" section. In there we disable the "Show Value" option.

PingDashboardp3-12

Now it only shows the instance name.

PingDashboardp3-13

12. The next step is to change the colours of the hexagons so they show red for Error, yellow for Warning and green for Success. Yet agin we go to the Panel Option and scroll down to the "Global" section. A bit further down we have the option for "Global Thresholds". Here you press "Add Threshold" 3 times and configure it like the picture which will result in the correct colours.

PingDashboardp3-14

13. You can now save the dashboard an reorganize it to your preference.

PingDashboardp3-15

In the next part we will create a complete new dashboard for which will be used to show more dtailed data for each instance. This dashboard will be used when we later add the ability to click each instance in the pane we created in this part.

Links to all parts

Part 1

Part 2

Part 3

Part 4

Part 5