topic Re: Field Extraction from Raw Data in Splunk Search

Field Extraction from Raw Data

Dandanos — Tue, 19 May 2020 21:10:24 GMT

Hello,

Im new to splunk and just started learning it and im having little issues extracting some fields from a raw data

ex: of Ram Data
04/12 15:50:38 [LOGON] [1860] Domain: SamLogon: Network logon of Domain\test1$ from machine1 Returns 0xC0000064

I would like to extract the following

SamLogon : Network logon of Domain\test1$ from machine1
Returns : 0xC0000064

im trying to use the regex in props.conf in SH

Any help would be appreciated . Thanks

Re: Field Extraction from Raw Data

richgalloway — Wed, 20 May 2020 00:51:49 GMT

Can you share what you've tried in props.conf?
How fixed is the data you're parsing? Are there any pieces of text a regular expression can key on?

Re: Field Extraction from Raw Data

codebuilder — Wed, 20 May 2020 02:14:14 GMT

Run your search as you have it, pipe your results to erex (may favorite hidden gem in Splunk).

The first "SamLogon" value is what you name the field, it's arbitrary. The second is the value that Splunk searches for.
Run the search, the examine the Job Inpspector, it will provide the regex that Splunk used to find the value.
You can fine tune it from there, but it is a fantastic starting point...

| erex SamLogon examples="SamLogon"

Documentation: https://docs.splunk.com/Documentation/Splunk/8.0.3/SearchReference/Erex#Examples

Re: Field Extraction from Raw Data

to4kawa — Wed, 20 May 2020 02:19:56 GMT

I'm trying to use the regex in props.conf in SH

in SH?
see: https://answers.splunk.com/answers/6820/search-head-props-conf.html

You're probably using it as a standalone,
props.conf

EXTRACT-fields = SamLogon: (?<Samlogon>.*) Returns (?<Returns>\S+)