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!

Think Like an Architect: Introducing the Splunk Certified Cybersecurity Defense ...

In cybersecurity, defenders respond to threats. Architects design the systems that stop them.    As ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...

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 ...