Splunk Search

Help extracting alphanumeric string after matching pattern

harishnpandey
Explorer
{"line":"2019-10-05 03:58:11.627 ERROR [xxx-csscsc0sssscs-xxxx] 1 --- [nio-8080-exec-2] c.u.f.b.s.registryImpl  : \u003c\u003c\u003c registryImpl  : registerInformation(): caught NnaException REGISTER_NOT_FOUND productId XA363636363633 requestDate 2020-07-24",

Need help to extract those productIDs (XA363636363633) which printed as REGISTER_NOT_FOUND in log

0 Karma
1 Solution

gkapitany
Explorer

search .. |rex field=_raw ".REGISTER_NOT_FOUND\s+productId\s+(?\w+)."

View solution in original post

0 Karma

gkapitany
Explorer

search .. |rex field=_raw ".REGISTER_NOT_FOUND\s+productId\s+(?\w+)."

0 Karma

harishnpandey
Explorer

Thank you very much . it worked with small modification as

search .. |rex field=_raw "REGISTER_NOT_FOUND\s+productId\s+(?\w+)"|stats count by regNumber

0 Karma
Get Updates on the Splunk Community!

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...

4 Ways the Splunk Community Helps You Prepare for .conf25

.conf25 is right around the corner, and whether you’re a first-time attendee or a seasoned Splunker, the ...