All Apps and Add-ons

DB Connect V3 -Database data: Line breaking, case conversion

steelo_1
New Member

2018-06-13 07:50:45.491, NILL_UPDATE_TS="2018-06-13 07:34:26.390909", NILL_ACCESS_NBR="00000005562065", NILL_EMAIL_ADDR="xxx@gmail.com ", NILL_CHANNEL_CD="HBK", BULL_MODIFIED_TM="2018-06-13 07:51:30.340677", BULL_INT_ACC_NO="1234567878 ", NULL_ACCT_OWNER_UC="BAD CASE ", NULL_RTN="1111111111", NULL_ACCT_NO="56565656565656 ", BULL_TRANS_AMOUNT="500.00", BULL_STATUS="Scheduled ", NULL_MODIFIED_TM="2018-06-13 07:50:45.491481"

Data being pulled out of a database with dbconnect version 3 comes in as a single line per event as shown above.
I need to be able to:

1) convert and index all field names in lowercase
2) break output to have 1 key / value pair per line

Output should look as follows:

2018-06-05 07:50:45.491
nill_update_ts=2018-06-13 07:34:26.390909
nill_access_nbr=00000005562065
nill_email_addr=xxx@gmail.com
nill_channel_cd=HBK
bull_modified_tm=2018-06-13 07:51:30.340677
bull_int_acc_no=1234567878
null_acct_owner_uc=BAD CASE
null_rtn=1111111111
null_acct_no=56565656565656
bull_trans_amount=500.00
bull_status=Schedule
null_modified_tm=2018-06-13 07:50:45.491481

Any pointers?

0 Karma

jcoates
Communicator

that is not currently possible. However, you might enjoy this article: http://my2ndhead.blogspot.com/2017/07/heating-up-data-pipeline-part-1.html

0 Karma

steelo_1
New Member

dbconnect v1 did this automatically

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...