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!

Deep Dive: Accelerate threat investigation with Splunk’s AI Assistant in Security

AI is one of the biggest topics in the market today, and for security teams, its value goes far beyond the ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Detection Engineering Office Hours: Real-World Troubleshooting & Q&A

[REGISTER HERE] This thread is for the Community Office Hours session on Detection Engineering Office Hours: ...