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!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...