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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...