All Apps and Add-ons

Can you help us with our DB_Connect timestamp timezone issue?

apezuela
Explorer

Hi,

I am having some issues indexing a database.

We are using a database column as a timestamp for events. This "DateTime" column is is UTC time so we added a line in props.conf to specify time format TZ=UTC (we are using CET time).

When we check the events _time field shows us UTC time for that event, so it seems props.conf is not working.

Any idea about this issue?

Best regards

0 Karma
1 Solution

jcoates
Communicator
0 Karma

jcoates
Communicator

It won't work that way because it's using HEC internally.

Do this instead: http://docs.splunk.com/Documentation/DBX/3.1.3/DeployDBX/Createandmanagedatabaseconnections#Create_a...

0 Karma
Get Updates on the Splunk Community!

.conf25 Community Recap

Hello Splunkers, And just like that, .conf25 is in the books! What an incredible few days — full of learning, ...

Splunk App Developers | .conf25 Recap & What’s Next

If you stopped by the Builder Bar at .conf25 this year, thank you! The retro tech beer garden vibes were ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...