Join the Conversation
- Find Answers
- :
- Splunk Administration
- :
- Admin Other
- :
- Knowledge Management
- :
- Re: Column names with Oracle and DB Connect
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have a DB Connect input: SELECT EVENT_ID, EVENT_TYPE, ... FROM table WHERE EVENT_ID > ? ORDER BY EVENT_ID ASC.
The fields in the result all come with a column name, eg:
EVENT_ID="225894621", EVENT_TYPE="QUERY_BILLS",...
EVENT_ID="225894620", EVENT_TYPE="CONN_SERVICE",... etc.
It seems to me that it's an unnecessary overhead. Can I get rid of the column names?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No, DBConnect method of collection is to create a KV pair out of each field, no way around that
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No, DBConnect method of collection is to create a KV pair out of each field, no way around that
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Too bad. What's the best way to get usefull fields out of the results - use field extraction or something else?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Assign the events to a sourcetype which has KV_MODE=auto to get the fields and values automatically extracted. If not, use REGEX to get them on the sourcetype level too
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great, will do that, thank you!
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
Index This | What travels the world but is also stuck in place?
Discover New Use Cases: Unlock Greater Value from Your Existing Splunk Data
Continue Your Journey: Join Session 2 of the Data Management and Federation Bootcamp ...
