Splunk Dev

Add Values from Rows

dfrench151
Explorer

Hello,

I'm trying to add values from rows. See the picture below. alt text

What I am pretty much trying to do is add the count from unconfirmed_down status to the up status. The thing is is that the unconfirmed_down status isn't always there depending on the source I am pulling from and could vary from month to month, so I need to have an exception included in case it is not there. I have though have saying add field 1 to field 2, but that could produce incorrect results if that particular status is not there...

0 Karma
1 Solution

niketn
Legend

@dfrench151 can you try the following?

index=<yourIndexName>
| eval status=if(status=="unconfirmed_down","up",status)
| stats count by status
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

View solution in original post

0 Karma

niketn
Legend

@dfrench151 can you try the following?

index=<yourIndexName>
| eval status=if(status=="unconfirmed_down","up",status)
| stats count by status
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

dfrench151
Explorer

This only produced that status for up and count unfortunately

0 Karma

niketn
Legend

The above should move unconfirmed_down as up and remaining up and down status intact. So final sum should be only up and down status. Is your expectation different
?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

dfrench151
Explorer

Sorry about that. I re-ran that and it did what I needed. Thank you

niketn
Legend

No problem. Glad it worked!

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

Thanks for the Memories! Splunk University, .conf24, and Community Connections

Thank you to everyone in the Splunk Community who joined us for .conf24 – starting with Splunk University and ...

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...