Splunk Search

Can you help me with a question about a search using the loadjob command and an earliest time modifier?

jiaqya
Builder

i have a saved query that can show data up to 90 days.

But, when i run the search using the loadjob command, i would like to provide an option to view only 30/60/90 days data based on a users choice.

I see that i cannot use "earliest" with the loadjob command. Any ideas how to do it?

Basically, use user chosen days ( i.e -90d@d -60d@d etc ) on the loadjob savedsearch..

|loadjob savedsearch="testuser:testapp:testsavedsearch_ss" = this gives me 90 days data

i want to have an option to show only 30/60/90 days data based on user choice from a drop down.

0 Karma

adonio
Ultra Champion

| loadjob returns the result of the search you ran. you can not filter the results per-se
however, lets imagine your search is something like this:
... index=some_index sourcetype=some_sourcetype ... | stats(something) by something_else as something
you can add the _time field after your by clause and then have a search / filter after your | loadjob
... where _time > .... complete the rest and have 30 60 and 90 in a drop-down (form input) or something

hope it helps

0 Karma
Get Updates on the Splunk Community!

CX Day is Coming!

Customer Experience (CX) Day is on October 7th!! We're so excited to bring back another day full of wonderful ...

Strengthen Your Future: A Look Back at Splunk 10 Innovations and .conf25 Highlights!

The Big One: Splunk 10 is Here!  The moment many of you have been waiting for has arrived! We are thrilled to ...

Now Offering the AI Assistant Usage Dashboard in Cloud Monitoring Console

Today, we’re excited to announce the release of a brand new AI assistant usage dashboard in Cloud Monitoring ...