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!

How to Monitor Google Kubernetes Engine (GKE)

We’ve looked at how to integrate Kubernetes environments with Splunk Observability Cloud, but what about ...

Index This | How can you make 45 using only 4?

October 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Splunk Education Goes to Washington | Splunk GovSummit 2024

If you’re in the Washington, D.C. area, this is your opportunity to take your career and Splunk skills to the ...