All Apps and Add-ons

DB Connect: How to load database timestamp data in to Splunk?

nagaraju_varkal
Engager

when i am trying to load DB data in to splunk. Timestamp column ( TIMESTAMP(6) WITH TIME ZONE ) data is loading as empty.
Do i need to do any settings for the column in splunk DB input?

0 Karma

sroback_splunk
Splunk Employee
Splunk Employee

Hi. You might want to have a look at these docs, which discuss best practices for timestamps and database output:
http://docs.splunk.com/Documentation/DBX/1.1.4/DeployDBX/Configuredatabasemonitoring#About_timestamp...

theouhuios
Motivator

Which type of DB is this? SQL? You might want to try

cast( <TIMEfield>AS DATETIME)<fieldname>
0 Karma
Get Updates on the Splunk Community!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...