Splunk Search

How do you convert time in EPOCH Scientific Notation for Props.conf TIME_FORMAT on a universal forwarder?

dsbruce
Explorer

We have a sevone network monitoring a JSON data time field formatted as EPOCH in Scientific Notation format. All the examples do not show how to take into account for Scientific Notation. Any assistance would be appreciated. time=1.539895001846788E9

We currently have this setup for DATETIME_CONFIG=CURRENT but then all the events are off and it looks like they are being batch loaded every 4 hours in the search time line.

raw data in filesystem log file. Using inputs.conf with props.conf on the UF on the syslog servers:

{"deviceId":2911,"deviceName":"SS-L1-AGNEW-2","deviceIp":"10.10.14.68","peerId":5,"objectId":227468,"objectName":"Ethernet1/30","objectDesc":"Ethernet1/30","pluginId":1,"pluginName":"SNMP Poller","indicatorId":1420925,"indicatorName":"s1_TotalErrors","format":0,"value":"0.0","**time**":**_1.539895001846788E9_**,"clusterName":"NMS","peerIp":"10.10.30.46"}

I have in props.conf TIME_PREFIX=\"time\": , but I have not found any entry for TIME_FORMAT that works.

If this will not work for PROPS, any suggestions on how to get the correct time for indexing would be appreciated.

TY

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...

Design, Compete, Win: Submit Your Best Splunk Dashboards for a .conf26 Pass

Hello Splunkers,  We’re excited to kick off a Splunk Dashboard contest! We know that dashboards are a primary ...

May 2026 Splunk Expert Sessions: Security & Observability

Level Up Your Operations: May 2026 Splunk Expert Sessions Whether you are refining your security posture or ...