Splunk Search

How to map extracted field name (e.g actual_time) with _time field?

pm2012
Explorer

Hi SMEs, I have a unique requirement which need one of my extracted filed name = actual_time to be mapped with _time field. As while searching past 30 days data i am also getting the older data while looking at actual_time field. I think if i map actual_time with _time or by other mean i should be able to get the actual outcome. thanks in advance

Labels (3)
Tags (1)
0 Karma

glc_slash_it
Path Finder

Hey!

Try this out to search for a time interval based on the actual_time. 

(your search)
| eval _time=actual_time
| search earliest=<epoch_time> latest=<epoch_time>

 

If the actual-time is not in epoch, you must convert it before the search command:

| eval _time=strftime(actual_time, "%Y-%m-%d %H:%M:%S")

 

------------
If this was helpful, some karma would be appreciated.

0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

What’s New & Next in Splunk SOAR

Security teams today are dealing with more alerts, more tools, and more pressure than ever.  Join us for an ...

Observability Unlocked: Kubernetes Monitoring with Splunk Observability Cloud

 Ready to master Kubernetes and cloud monitoring like the pros? Join Splunk’s Growth Engineering team for an ...