HI Bart,
We did something similar in our environment. We have 3 knowledge bases, each w/ 100-300 articles in each. We have 3 scheduled jobs, one for each knowledge base. First, you'll want to grab the URL of the filter by going to the kb_knowledge list and applying a filter like this:
Once you grab the URL (right click URL and select Copy URL, create a scheduled job. Here is what ours looks like:
Next create an event. Our event is called 'knowledge.articles.expiring.customerService'
Then create an email notification which is fired by an event
In the When to send tab, ensure the Advanced condition is 'answer = true;'
In the Who will receive, add your recipients
In the What it will contain, point to an email template.
In the template, in the Message HTML, you'll want to include a mail_script. The mail script will look like this:
(function runMailScript(current, template, email, email_action, event){
var article = new GlideRecord('kb_knowledge'); //create a query to retrieve knowledge articles
article.addEncodedQuery('workflow_state=published^valid_to<=javascript:gs.endOfNextMonth()^kb_knowledge_base=05ff44289f011200550bf7b6077fcfa3');
//only retrieve articles that are published and valid to next month and are assigned to knowledge base Customer Service
article.query();
while(article.next()){
template.print....
<add your content here>
}
}})(current, template,email, email_action,event);​
Hope this helps. Feel free to ask any questions.
Oh, you'll need to create a scheduled job for each knowledge base and an event for each knowledge base and a notification for each knowledge base
