Splunk Search

Compare several fields from 2 indexes

Luninho
Explorer

I have two indexes: INDEX1 and INDEX2. In these indexes have the same fields: FIELD1, FIELD2, FIELD3 but they can have different values. 

For example:
INDEX1: FIELD1=5, FIELD2=8
INDEX1: FIELD1=5, FIELD2=7

I need to get a table where will be show only fields with different values in different indexes. According the previous example:

|INDEX1|FIELD2=8|
|INDEX2|FIELD2=7|
or something similar

Labels (1)
Tags (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Which field or fields is/are used to join the two indexes so that a comparison between the other fields in the event can be sensibly made?

0 Karma

Luninho
Explorer

forget to add these fields in question. I use field @"TIMEIN"

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

see the answer here for hints

0 Karma
Get Updates on the Splunk Community!

Industry Solutions for Supply Chain and OT, Amazon Use Cases, Plus More New Articles ...

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

Enterprise Security Content Update (ESCU) | New Releases

In November, the Splunk Threat Research Team had one release of new security content via the Enterprise ...

Index This | Divide 100 by half. What do you get?

November 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...