Splunk Search

How to calculate SLA?

Sekhar
Explorer

my query below

(Index=x source=xtype valid) or (index=y source= ytype  passed) | eval which=if(match(_raw, " valid"),"valid", "passed") | stats values( which) as msg by manid |  stats count(eval(msg=" valid")) as total_ count count(eval(msg= "passed"))   

getting  out like total count 54 respons count 58

But i want check this condition too 

Eval msgconur = mvcount(msg) | where >1 

Need to check duration time > 30 count duration time <30 count 

 

Labels (1)
0 Karma

Sekhar
Explorer

My SLA calculating  like this 100-(count of duration<30/total count)*100

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

| stats values( which) as msg count(eval(duration>30)) as gt30 count(eval(duration<30) as lt30 by manid | where mvcount(msg) > 1

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud's AI Assistant in Action Series: Auditing Compliance and ...

This is the third post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...