Splunk Search

How to write regex to extract a field from a log?

Bhuavana
Explorer

Hi,

I have a below log :

INFO com.wu.channelservices.businesslogic.impl.ChannelServicesLogicImpl S:METHOD_NAME=GwpCreateSession : WebAppSessionId= : ChannelSessionId= : ClientIp=027050022090 : - databases.database[0].info.name: CAN_STATE_LIST

From above message i need to extract the value of database name[CAN_STATE_LIST] alone from below full text :

databases.database[0].info.name: CAN_STATE_LIST

Could you please share me the corresponding regex for the same?

Tags (2)
0 Karma

ulrich_track
Path Finder

You can find it out by copying that section in regex101.com and playing around. I found this:

During searchtime:

| rex "name:\s(?<DBname>\S+)"

Or in the field-extractor

(?m)name:\s(?<FIELDNAME>\S+)
0 Karma

Ayn
Legend

This should be possible to extract using the Interactive Field Extractor.

Get Updates on the Splunk Community!

AppDynamics Summer Webinars

This summer, our mighty AppDynamics team is cooking up some delicious content on YouTube Live to satiate your ...

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...