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