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!

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

How to find the worst searches in your Splunk environment and how to fix them

Everyone knows Splunk is a powerful platform for running searches and doing data analytics. Your ...

Share Your Feedback: On Admin Config Service (ACS)!

Help Us Build a Better Admin Config Service Experience (ACS)   We Want Your Feedback on Admin Config Service ...