Splunk Search

diff between numbers

indeed_2000
Motivator

Hi
need to compare total numbers if they are different show table that present them
23:57:05.253 app module: PACK: Total:[1010000] from server1 Total:[C000001010000]
23:57:05.254 app module: PACK: Total:[1010000] from server1 Total:[C000001000000]

diff=second total - first total

expected output:
Time                                 diff
23:57:05.254        10000

any idea?

Thanks,

0 Karma
1 Solution

indeed_2000
Motivator

after workaround do this with eval command.

index="myindex"

| eval diff=(total2 - total1)

| table _time diff 

View solution in original post

0 Karma

indeed_2000
Motivator

after workaround do this with eval command.

index="myindex"

| eval diff=(total2 - total1)

| table _time diff 

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...