saved searches

[raomu]

I have schedule report"AAA" which runs once in a month ( pulls huge number of records for last 6 months)

I have another dashboard where I have one panel showing "AAA" data.

my code is :

      <query>| loadjob savedsearch="username:search:Domain_Controllers_Status_In_Splunk"</query>

    </search>

    It use work fine till last month, and now I don't see any data pull in Dashboard panel. Although the schedule reports works fine. 

Any idea how long the saved searches are accessible is there ant time frame like a week or some time is set, I am assuming if the saved is not getting expired.

Any suggestion.

[cmerriman · Accepted solution]

run this and look at the dateExpire field that is calculated. that should give you an idea.

|rest /services/search/jobs|search  isSavedSearch=1 delegate="scheduler" label="Domain Controllers Status In Splunk"|fields author label earliestTime latestTime runDuration isDone isFailed isSaved sid ttl published|eval publishedepoch=strptime(published,"%Y-%m-%dT%H:%M:%S.%3N%:z")|eval dateExpire=strftime(publishedepoch+ttl,"%Y-%m-%dT%H:%M:%S")

the ttl is the time to live. you can change the settings in savedsearches.conf under dispatch.ttl
https://docs.splunk.com/Documentation/Splunk/7.0.1/Admin/Savedsearchesconf#dispatch_search_options

[raomu]

Thanks, I am able to find the expire date/Time.

[mayurr98]

hey

you can definitely extend the job life time as mentioned in this doc
https://docs.splunk.com/Documentation/Splunk/6.6.3/Search/Extendjoblifetimes

but what i would suggest is try this search command savedsearch and use this is dashboard instead of loadjob
https://docs.splunk.com/Documentation/SplunkCloud/6.6.3/SearchReference/Savedsearch
| savedsearch your_report_name
let me know if this helps you!

[cmerriman]

I'll agree that you could run the savedsearch command, however, it will run the entire saved search when the dashboard is ran, instead of pulling in the results from the report. as stated above, it is a huge amount of data, and could take a while. I'd recommend extending the life of the job under the savedsearches.conf for ongoing runs of this report.

[mayurr98]

here i am assuming that saved search is accelerated 😛

[andrey2007]

You cas specify and increase job lifetime period

https://docs.splunk.com/Documentation/Splunk/latest/Search/Extendjoblifetimes