Splunk Enterprise Security

how do i get complete list of ip address ? is there any query ?

naveenyadav99
Explorer

i need to create a dashboard with complete information of IP address

0 Karma

kmorris_splunk
Splunk Employee
Splunk Employee

If you are just trying to get a distinct list of all IPs in your data, then you could do something simple like:

YOUR BASE SEARCH |
| eval allips = coalesce(src_ip,dest_ip) 
| stats count by allips 
| fields - count

This is an example giving a unique list of all IPs that showed up in the two fields in the coalesce command. Coalesce merges the fields specified into the field you create in the eval.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

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