Status indicator by colour value

[Abha11]

Hi,

I am looking to build a query based on the service status of 2 hosts and then combine 2 of them into 1 and change colour based on the condition below:

For example:

I want A1 + B1 = x

then i want to check the service status, if both are running then green, if 1 is running then yellow and if none is running then red.

Any idea how can I achieve this?

Any help appreciated!

[ITWhisperer · Accepted solution]

Assign a value to 1 if the host is up and 0 if not, then sum the values and set your colour based on the value of the sum