I am working on a threshold value dashboard for many index and sources, i want to show whether those parameters running under a threshold value or not. so i have created a lookup file with two fields , first fields describes kpi name and second field is a query to determine threshold value.
lookup file format is something like this,
KPI_Name Query
KPI_001 "index=ph3 sourcetype=dbmon| timechart avg(TransactionsPerSec) as avg_trans | eval "Threshold value" = 10100 |eval comd_val=if(avg_trans<="Threshold value","Under_Control","Critical")|table comd_val"
KPI_002 "index=ph3 sourcetype=CPUmon|........................etc"
KPI_003 "index=ph3 sourcetype=unix_top|........................etc"
. .
. .
KPI_050 "index=ph3 sourcetype=unix_cpu|........................etc "
so the field query value in lookup file is different in every case but output is either critical or under control.
i want to show each kpi and correspondent threshold value either critical or under_control in a same panel. please help me.
... View more