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!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

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

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...