Single log line:
{kpiMuleMS=12, kpiSecurityCheckMS=230, kpiGetQuoteMS=56, kpiGetLegalEntityMS=0, kpiOIILookupPersonaMS=0, kpiCreateSubscriptionMS=40, kpiGetOfferMS=0, kpiProcessSubscriptionMS=23, kpiPayAuthMS=9, kpiOIIFindRealmMS=1, kpiUpdateAccountMS=40, kpiGetAccountMS=10}
How do I graph the avg values of all the keys in a single graph?
Unfortunately, I do not have the log line in the following format..
key=kpiSecurityCheckMS latency=230
key=kpiMuleMS latency=12
Try this (if the fields are already extracted, ignore the extract
segement)
base search | extract pairdelim="," kvdelim="=" | stats avg(kpiMuleMS) as kpiMuleMS avg(kpiSecurityCheckMS) as kpiSecurityCheckMS <<similarly for rest of your fields
The kv or extract command would work well here.
But, do you want an average of each kpi,
or an average of all kpis?
Try this for the former.
| kv pairdelim="=", kvdelim=","
| fields - _raw
| stats avg(*)