Dimensions for Guage

[nigelapt]

Hi All

I just can't figure out how to create a gauge to show a simple status.

I have a table with a list of servers and a comment field showing if they are patched or not.

eg

Server            Patch Status

SERVER01    Patched

SERVER02    Not Patched

SERVER03    Patched

SERVER04    Patched

SERVER05    Not Patched

I want to be able to show the % of servers patched, against the total number of servers displayed in a guage.

So servers which are patched are green on the gauge, and those not patched would be red on the gauge.

Any advice would be really appreciated.

Thanks

Nigel

[krishnacbe]

Hi,

Your Gauge Expression should be as below.

count({<PatchStatus={"Patched"}>}Server)/ count(Server) * 100

PFA the sample that helps