All Apps and Add-ons
×

Are you a member of the Splunk Community?

Sign in or Register with your Splunk account to get your questions answered, access valuable resources and connect with experts!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ask a Question

Splunk DB Connect - Strip space from CHAR fields?

andreasknutsson
Engager
‎04-27-2020 11:23 AM

We have Splunk DB Connect tailing a table in an Oracle DB. Everything is working fine except that the events end up in Splunk with space characters filling out the fields of CHAR type up to the configured length.
ex:

2020-04-27 19:28:59.000, ACTION="replace    ", STATUS="OK   ", TYPE="FRAC        "

Is it possible to configure DB Connect to remove these extra space characters?
is it possible to add something to the SQL statement to accomplish this?

0 Karma
Reply
Get Updates on the Splunk Community!

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...

September Community Champions: A Shoutout to Our Contributors!

As we close the books on another fantastic month, we want to take a moment to celebrate the people who are the ...

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...