Building for the Splunk Platform

Help with Event Search based on custom time field


i found for below query  the search is happening based on default time field which is  _time  , so when ever i am choosing the date and time based on default time which is '5/26/22 7:40:00.000 AM' then the events are populating but if i am selecting any date and time which is align with my custom time field which is 'originaltime'  then i am not getting any event , am i doing any thing wrong here

index="summary_carrier_service" originalsource="*gps-request-processor-dev*" originalsourcetype= "*eu-central-1*" event="*Request"
| fields event category labelType documentType regenerate businessKey businessValue sourceNodeType sourceNodeCode geoCode jobId status sourcetype source originaltime
| addinfo
| eval ts=strptime(originaltime,"%Y-%m-%d %H:%M:%S")
| where (ts>info_min_time and ts<=info_max_time)



0 Karma


The AND operator in the where command must be in upper case.

If you still don't get results, use the table command to examine the ts, info_min_time, and info_max_time fields.

If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...

Cloud Platform | Migrating your Splunk Cloud deployment to Python 3.7

Python 2.7, the last release of Python 2, reached End of Life back on January 1, 2020. As part of our larger ...