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!

AI for AppInspect

We’re excited to announce two new updates to AppInspect designed to save you time and make the app approval ...

App Platform's 2025 Year in Review: A Year of Innovation, Growth, and Community

As we step into 2026, it’s the perfect moment to reflect on what an extraordinary year 2025 was for the Splunk ...

Operationalizing Entity Risk Score with Enterprise Security 8.3+

Overview Enterprise Security 8.3 introduces a powerful new feature called “Entity Risk Scoring” (ERS) for ...