Getting Data In

configure time based lookup table

nagarjuna560
New Member

I have a CSV lookup table with a field that contains latest_event and the value is in format "12/25/2019 12:10" (%m/%d/%Y %H:%M) and the time zone is CST. I am comparing latest_event filed with some other fileds (_time

Tags (1)
0 Karma

nagarjuna560
New Member

I mentioned the name of the filed as "latest_event" and time format as "%m/%d/%Y %H:%M" ( 10/12/2019 10:12)

and I ran search | inputlookup lookupname.csv | table latest_event
I got the results as "10/12/2019 10:12", as per the documentation default time is in UTC, then the result should be like "10/12/2019 05:12"

0 Karma
Get Updates on the Splunk Community!

Earn a $35 Gift Card for Answering our Splunk Admins & App Developer Survey

Survey for Splunk Admins and App Developers is open now! | Earn a $35 gift card!      Hello there,  Splunk ...

Continuing Innovation & New Integrations Unlock Full Stack Observability For Your ...

You’ve probably heard the latest about AppDynamics joining the Splunk Observability portfolio, deepening our ...

Monitoring Amazon Elastic Kubernetes Service (EKS)

As we’ve seen, integrating Kubernetes environments with Splunk Observability Cloud is a quick and easy way to ...