Getting Data In

field extraction

pavanbmishra
Path Finder

Hi All,

what should be the regex while doing event extraction for srcip

 

eventtime=1604591829395228259 appid=41 srcip=192.168.1.1 dstip=192.168.2.2 srcport=47450 dstport=443

Labels (1)
Tags (2)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi @pavanbmishra,

you shouldn't need to extract the srcip field because Splunk automatically recognizes the pairs "field=value".

Anyway, you can extract the value of srcip using the following regex:

| rex "srcip\=(?<srcip>\d+\.\d+\.\d+\.\d+)"

that you can test at https://regex101.com/r/fJaZwd/1

Ciao.

Giuseppe

View solution in original post

gcusello
SplunkTrust
SplunkTrust

Hi @pavanbmishra,

you shouldn't need to extract the srcip field because Splunk automatically recognizes the pairs "field=value".

Anyway, you can extract the value of srcip using the following regex:

| rex "srcip\=(?<srcip>\d+\.\d+\.\d+\.\d+)"

that you can test at https://regex101.com/r/fJaZwd/1

Ciao.

Giuseppe

pavanbmishra
Path Finder

Thanks,

And what about action field here

applist="sniffer-profile" action="pass" appcat="Network.Service"

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @pavanbmishra,

sam answer: you don't need field extractions, but if you want you can use one or three  similar regexes:

one regex

| rex "applist\=\"(?<applist>[^\"]+)\"\s+action\=\"(?<action>[^\"]+)\"\s+ appcat\=\"(?<appcat>[^\"]+)\""

three regexes:

| rex "applist\=\"(?<applist>[^\"]+)\""
| rex "action\=\"(?<action>[^\"]+)\""
| rex "appcat\=\"(?<appcat>[^\"]+)\""

Ciao.

Giuseppe

 

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 ...

Stay Connected: Your Guide to January Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...

[Puzzles] Solve, Learn, Repeat: Reprocessing XML into Fixed-Length Events

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