Splunk Search

Querying two indexes with same field name

sriramsb
New Member

I have two indexes indexA and indexB . IndexA contains userID and Salary , IndexB contains userID, Name i want to print a dash board with Name , salary ( matching userIDs from both indexes

Tags (2)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

There are a number of ways to do that, but the simplest is

index=indexA OR index=indexB 
| stats values(*) by userID
| table Name, Salary
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Observability Unlocked: Kubernetes Monitoring with Splunk Observability Cloud

  Ready to master Kubernetes and cloud monitoring like the pros?Join Splunk’s Growth Engineering team for an ...

Wrapping Up Cybersecurity Awareness Month

October might be wrapping up, but for Splunk Education, cybersecurity awareness never goes out of season. ...

🌟 From Audit Chaos to Clarity: Welcoming Audit Trail v2

🗣 You Spoke, We Listened  Audit Trail v2 wasn’t written in isolation—it was shaped by your voices.  In ...