Splunk Search

How can I join and group data from 2 different hosts.

jimjohn
Path Finder

How can I join and group data from 2 different hosts.
Say I have HostA , HostB and ID as common field in 2 hosts.
I want to join 2 hosts by Id and group them and do further processing on grouped result.
Ex:
In HostA I have id 10 repeating 1 time and in HostB id 10 is repeating 10 times.
I want to know how may times id 10 occurs in HostA and HostB. How can I achieve this.
Like this different Ids are in 2 hosts. For each ID I want to find the value.

0 Karma

kristian_kolb
Ultra Champion

How long is a piece of string? There are normally a few different ways of solving most problems, but here is one way;

host=hostA OR host=hostB | chart count over ID by host

and another way;

host=hostA OR host=hostB | stats count by ID, host

and yet another way;

host=hostA OR host=hostB | top 20 ID by host

Hope this helps,

K

Get Updates on the Splunk Community!

Aligning Observability Costs with Business Value: Practical Strategies

 Join us for an engaging Tech Talk on Aligning Observability Costs with Business Value: Practical ...

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...

Splunk Up Your Game: Why It's Time to Embrace Python 3.9+ and OpenSSL 3.0

Did you know that for Splunk Enterprise 9.4, Python 3.9 is the default interpreter? This shift is not just a ...