Splunk Search

How to write a search to get a table of eventstats perc95 and avg by a certain field?

edookati
Path Finder

I need a table which gives me both perc95(response_time) and avg(response_time) by service_name
I am using the below query, but is giving me some weird results...

index=jms_logs sourcetype=perflogs | eventstats perc95(response_time) as response_time_95p, avg(response_time) as avgRespTime | stats by service_name

can someone please help me?
Thanks.

Tags (3)
1 Solution

somesoni2
Revered Legend

Try this

 index=jms_logs sourcetype=perflogs | stats perc95(response_time) as response_time_95p, avg(response_time) as avgRespTime by service_name

View solution in original post

somesoni2
Revered Legend

Try this

 index=jms_logs sourcetype=perflogs | stats perc95(response_time) as response_time_95p, avg(response_time) as avgRespTime by service_name

View solution in original post

edookati
Path Finder

thanks. It worked just great.

0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.