Splunk Search

How to capture multiple lines using rex command

sumagarw
New Member

Hi All,

I am having difficulties capturing Multiple lines of logs from splunk using rex command.

03:25:17.296: SIPTR: Received [0,UDP] 543 bytes from 10.xx.7x.1xx:8080 <<<<<
REGISTER sip:10.xx.7x.1xx SIP/2.0
Via: SIP/2.0/UDP 10.xx.7x.1xx;branch=hkhi8u09uj
From: "Dummy" ;tag=78979uh
CSeq: 68789 REGISTER
Call-ID: xxxxxx-7689-xxxx@10.xx.7x.1xx
Contact: ;methods="INVITE, ACK, BYE, CANCEL, OPTIONS, UPDATE, REFER"
User-Agent: Polycom_r64786r9879r87
Accept-Language: en
Max-Forwards: 70
Expires: 60

I have to capture lines starting from "REGISTER sip:" till "User-Agent: ", is there any way to capture multiple lines in same rex file?

Tags (1)
0 Karma
1 Solution

jplumsdaine22
Influencer

You need to use the dotall modifier to tell splunk to match newlines with '.'

... | rex "REGISTER sip:(?s)(?<new_field_name>.*)User-Agent"

View solution in original post

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi sumagarw,
try something like this

REGISTER sip:(?<your_field>(.|\n)+)User-Agent:

test it at https://regex101.com/r/TlOYUg/1

Bye.
Giuseppe

0 Karma

jplumsdaine22
Influencer

You need to use the dotall modifier to tell splunk to match newlines with '.'

... | rex "REGISTER sip:(?s)(?<new_field_name>.*)User-Agent"
0 Karma

sumagarw
New Member

Thanks @jplumsdaine22
Looks like i am able to capture required lines. Can you also help me to capture "10.xx.7x.1xx SIP/2.0" , "Dummy", and "Call-ID: " from captured data in a table format.

Thing is that data keeps on repeating, now i have to capture specified info from captured line and get in table format.

0 Karma

jplumsdaine22
Influencer

What you should do is create a field extraction for each field in the data. That will make your job a great deal easier!

http://docs.splunk.com/Documentation/Splunk/latest/Knowledge/ExtractfieldsinteractivelywithIFX

0 Karma

sumagarw
New Member

Thanks again,! but for time being, is there anyway to build regex for same?

0 Karma
Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...