Splunk Search

How to use regex determine whether a field is an IP address

xsstest
Communicator

I extracted a field named "apche_zhuji_sip", but the content is not accurate, some are not IP, how do I use regular expressions to filter non-IP contentalt text

Tags (1)
0 Karma
1 Solution

DalJeanis
Legend

It will be something like this

(your extract)
| regex apche_zhuji_sip="^\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}$" 

That's the basic, simple version that makes sure the IP has 1-3 numeric digits. You could also do a more complicated version that limits the nodes to 001-255...

| regex apche_zhuji_sip="(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3} (?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)"

View solution in original post

DalJeanis
Legend

It will be something like this

(your extract)
| regex apche_zhuji_sip="^\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}$" 

That's the basic, simple version that makes sure the IP has 1-3 numeric digits. You could also do a more complicated version that limits the nodes to 001-255...

| regex apche_zhuji_sip="(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3} (?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)"
Get Updates on the Splunk Community!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

Watch On Demand the Tech Talk, and empower your SOC to reach new heights! Duration: 1 hour  Prepare to ...

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...