Splunk Search

How to compare CutoffTime with current time?

pradeepkm
Explorer

 I have created a lookup table with filename and cutofftime within which we have to receive the file. I have to compare Cutofftime to check if its falling within 30 mins of current time and retrieve that particular file name from lookup  and search for it. Please help me with query

Labels (4)
Tags (1)
0 Karma

somesoni2
Revered Legend

Assuming your lookup field for cutofftime has epoch value, you can retrieve the filename based on your condition like this:

| inputlookup yourLookupName.csv | table filename cutofftime | where abs(cutofftime-now())<=1800 | table filename

If it's in some specific string timestamp format, replace "abs(cutofftime-now())" with "abs(strptime(cutofftime,"Your Time Format")-now()".  Find your Timeformat here.

Once you finalize your above query, your search data for your retrieved file like this:

index=YourIndex sourcetype=YourSourcetype [| your finalized query | which will give filename. your may have to rename field 'filename' to field name that your index/sourcetype has] 

pradeepkm
Explorer

I was able to figure out working query.Yes I have used similar logic mentioned by you.Thanks for the response.

0 Karma
Get Updates on the Splunk Community!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...