Getting Data In

Is there a way to define the colon to be a name value pair separator?

ddrillic
Ultra Champion

We have cases such as the ldap audit log file -

dn: dc=<domain name>,dc=com
changetype: modify
replace: ds-sync-state
ds-sync-state: 0000016557BC19A55A110000004D
ds-sync-state: 0000016557BC93E3543100000048
ds-sync-state: 0000016557BC4A5858E300000045
ds-sync-state: 0000016557BCAC641C9300000045
ds-sync-state: 0000016557BCC49E1FF500000045
ds-sync-state: 0000016557BC7AD379F900000065
ds-sync-state: 0000016557BCDCD62ABB00000045
ds-sync-state: 0000016527034D6B075D00000001
ds-sync-state: 0000016557BC629E14FF00000090
ds-sync-state: 0000016557BC3205396F00000049

Is there a way to define the colon to be a name value pair separator? as obviously, none of these fields is being automatically extracted.

Tags (3)
0 Karma
1 Solution

FrankVl
Ultra Champion

Yes, I think you can define a DELIMS based extraction in transforms.conf, specifying that key/value pairs are separated by newline and key is separated from value by colon. Or apply a regex based extraction using something like ([^:]+):\s+([^\r\n]+) with FORMAT = $1::$2. I think that second option is how Splunk_TA_windows does it.

View solution in original post

0 Karma

FrankVl
Ultra Champion

Yes, I think you can define a DELIMS based extraction in transforms.conf, specifying that key/value pairs are separated by newline and key is separated from value by colon. Or apply a regex based extraction using something like ([^:]+):\s+([^\r\n]+) with FORMAT = $1::$2. I think that second option is how Splunk_TA_windows does it.

0 Karma

ddrillic
Ultra Champion

Thank you @FrankVl.

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 2 releases of new security content via the ...

Announcing the 1st Round Champion’s Tribute Winners of the Great Resilience Quest

We are happy to announce the 20 lucky questers who are selected to be the first round of Champion's Tribute ...

We’ve Got Education Validation!

Are you feeling it? All the career-boosting benefits of up-skilling with Splunk? It’s not just a feeling, it's ...