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!

Index This | What is broken 80% of the time by February?

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

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization uses ...