Im upgrading my DB Connect to 3.0.2 from 2.4.0, but the assigned sourcetype for the data isnt picking up the timezone designation in props.conf. During the effort, I'm also trying to switch from applying timezone by source and instead assign by sourcetype.
The database is plain MS SQL with a datetime column type. The timestamp output is default. Everything is working except the timestamp isnt being picked up as UTC.
My old props.conf on the Splunk instance running DB Connect:
[source::dbx_sourcename]
TZ = UTC
My new props.conf on the Splunk instance running DB Connect:
[name_of_sourcetype]
TZ = UTC
But whenever the data is searched, its displayed in the UI as the UTC.
... View more