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!

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

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

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...

Introducing the Splunk Community Dashboard Challenge!

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