Splunk Search

How do I table a transactionid value using regular expression?

ppanchal
Path Finder

Below is my log,

[ERL_ROUTE_ACK_INTERFACE] 2018-08-27 11:06:02 DEBUG [callUpdateERLRouteStatus] ERLRouteAckServiceImpl at line ? | Successfully updated the HDR record for transactionId : 869584588

I want to table the transactionId value.

Can somebody please help?

0 Karma
1 Solution

skoelpin
SplunkTrust
SplunkTrust

Try adding this to your query

| rex transactionId\s\:\s(?<transactionid>\d+)
| table transactionid

View solution in original post

0 Karma

skoelpin
SplunkTrust
SplunkTrust

Try adding this to your query

| rex transactionId\s\:\s(?<transactionid>\d+)
| table transactionid
0 Karma

ppanchal
Path Finder

Works Perfect! Thanks.

Get Updates on the Splunk Community!

Building Reliable Asset and Identity Frameworks in Splunk ES

 Accurate asset and identity resolution is the backbone of security operations. Without it, alerts are ...

Cloud Monitoring Console - Unlocking Greater Visibility in SVC Usage Reporting

For Splunk Cloud customers, understanding and optimizing Splunk Virtual Compute (SVC) usage and resource ...

Automatic Discovery Part 3: Practical Use Cases

If you’ve enabled Automatic Discovery in your install of the Splunk Distribution of the OpenTelemetry ...