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!

BSides Splunk 2022 - The Call for Papers is now Open!

TLDR; Main Site: CFP Site: CFP Opens: December 15th, ...

Sending Metrics to Splunk Enterprise With the OpenTelemetry Collector

This blog post is part of an ongoing series on OpenTelemetry. The OpenTelemetry project is the second largest ...

What's New in Splunk Cloud Platform 9.0.2208?!

Howdy!  We are happy to share the newest updates in Splunk Cloud Platform 9.0.2208! Analysts can benefit ...