In some of our event logs, the client IP address is recorded with leading information (::ffff:). I would like to trim this data and create a new field, which I can then do a reverse dns lookup on using a scripted lookup.
I'm not looking to modify the index, I'd like all of this to happen at search time.
The field I'm looking to modify is called Client_Address and a sample value would be:
::ffff:192.168.207.88
If I use the following REX at search time, I get a new field called Client_IP that looks good:
rex field=Client_Address "(? \b\d{1,3}.\d{1,3}.\d{1,3}.\d{1,3}\b)"
However, I'd like to use props.conf so this all happens automatically. If I add the following line to my WinEventLog:Security stanza, it doesn't work.
EXTRACT-ClientIP = rex field=Client_Address "(? \b\d{1,3}.\d{1,3}.\d{1,3}.\d{1,3}\b)"
... View more