Dashboards & Visualizations

How do I compare fields in 2 different indexes and return results only if values are not matching?

spl_unker
Explorer

I would like to construct a query by comparing 2 fields (hash values) in 2 different indexes.(A&B).........

If Hash Value in Index A matches Hash value in Index B then ignore those  results else return results if hashes not matching 

 

 

Labels (1)
0 Karma

spl_unker
Explorer

@ITWhisperer  I have updated my question.....I have removed my example for better understanding. Let me know if that is clear . TIA

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
index="A" OR index="B"
| eventstats count by hash
| where count < 2
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
index=A OR index=B
| stats dc(index) as indexes by hostname
| where indexes < 2
0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

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