Getting Data In

Event Timestamp is combination of 2 fields: StartTime + DeltaTime

woodcock
Esteemed Legend

We need to use as the event timestamp the EndTime of the event but the EndTime is a calculated field from 2 other actual fields: StartTime + DeltaTime. Is this possible?

Tags (1)
0 Karma

sideview
SplunkTrust
SplunkTrust

Hm. Well if you want the events to get indexed with that timestamp, i dont think it can be done. but someone else might know of a way.

If On the other hand, the _time as indexed today is close enough, but you just want to use this other more accurate value when you run reports, then you can modify the _time field itself.

| eval _time = StartTime + DeltaTime | timechart count

Of course, if the indexed _time value is off by enough to push it outside of the search timerange, then it wont show up in the report at all.

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!

Supercharging Windows Security Detection Performance: Introducing Hybrid Field ...

Windows event logs—from Security auditing and Sysmon to PowerShell script blocks—form the operational backbone ...

Ditch the Manual Grind: Building AI Agents with Splunk

Ditch the Manual Grind: Building AI Agents with Splunk Let’s be real: your team’s time is being eaten alive. ...

Cisco Data Fabric from Architecture to Investigation, Better SOC Visibility, and More ...

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...