Splunk Search

Same ip address in different host

Anto
Explorer

I want to catch from my index=ip the field value ip_address in common in one or more hosts.
I want to get something like this:
This IP ADDRESS is in common with 3 host 

and so have a list or a chart where i can see all the ip address in common in the hosts.

Don't know  how to get it, thank you in advantage.

Labels (4)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Try this

... | stats values(host) as hosts by ip_address
| where mvcount(hosts) > 1
---
If this reply helps you, Karma would be appreciated.

View solution in original post

Anto
Explorer

Really thank you, is exactly what i was looking for. It works

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Try this

... | stats values(host) as hosts by ip_address
| where mvcount(hosts) > 1
---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

How to Monitor Google Kubernetes Engine (GKE)

We’ve looked at how to integrate Kubernetes environments with Splunk Observability Cloud, but what about ...

Index This | How can you make 45 using only 4?

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

Splunk Education Goes to Washington | Splunk GovSummit 2024

If you’re in the Washington, D.C. area, this is your opportunity to take your career and Splunk skills to the ...