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: [email protected]
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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Detection Engineering Office Hours: Real-World Troubleshooting & Q&A

[REGISTER HERE] This thread is for the Community Office Hours session on Detection Engineering Office Hours: ...

Developer Spotlight with Mika Borner

From Hackathon Winner to Enterprise Leader    Mika Borner, CEO and Founder of Datapunctum AG, has been ...

Continue Your Federation Journey: Join Session 3 of the Bootcamp Series

To help practitioners build a stronger foundation, we launched the Data Management & Federation ...