Getting Data In

True-Client-IP=[12.34.56.78]

daniel333
Builder

All,

I have some header information coming through like so
True-Client-IP=[12.34.56.78]

I'd like to correct the data as it's ingested to be
True-Client-IP=12.34.56.78

Dropping the "[]" from around the IP address. Not sure where to start. I feel like I should be able to use SEDCMD inside props.conf but I am not sure how that would look.

0 Karma

jhall0007
Path Finder

This is old post, but one suggestion would be to create a custom field in props

Search Head props.conf:
[]
EXTRACT-true_ip = True-Client-IP=[(?(\d{1,3}.\d{1,3}.\d{1,3}.\d{1,3}))]

aakwah
Builder

Minor modification, Extract should be in capital letters,

EXTRACT-true_ip = True-Client-IP=[(?(\d{1,3}.\d{1,3}.\d{1,3}.\d{1,3}))]
0 Karma

jhall0007
Path Finder

Thanks you.

0 Karma

somesoni2
Revered Legend

Can you provide the complete event ? Just to ensure the SEDCMD for this doesn't affect any other portion of the data.

0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...