How to notified to a knowledge author about expiry article in a month advance?

[Deepika61]

Hi All,

Actually my requirement was every first day of each month, an email notification to a list of authorized recipients to remind them about articles that are scheduled to expire in the next month

Like if up to 10 – The email notification includes a list of article links displayed in a tabular format and arranged in ascending order by their Valid to date. Clicking a link opens the article in Now Platform?

if More than 10 – The email notification includes a View the list of expiring articles link, which when accessed opens a list in Now Platform of all articles expiring in the next month.?

Please help to achieve this

Thanks

Deepika

[Community Alums]

Hi Deepika,

You can try various ways to Notify the Knowledge author, with  the likes of

1. Scheduled Job

2. mail scripts

3. using the OOTB notifications

4. Use a flow designer

Refer to these threads for your code and ways of implementing the same, just change the code or logic as per your requirement :

https://community.servicenow.com/community?id=community_question&sys_id=9778cb39db7adb4067a72926ca96...

Flow Designer Demo: Automate Knowledge Expiration Warning 

https://community.servicenow.com/community?id=community_question&sys_id=a4099096db4e2c90a08a1ea66896...

https://community.servicenow.com/community?id=community_question&sys_id=eb7443a9dbd8dbc01dcaf3231f96...

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

[Deepika61]

Hi Sandeep

Thanks For the response

So if i understood the trigger point but other concern was display the links of artcles in the email body like

Like if up to 10 – The email notification includes a list of article links displayed in a tabular format and arranged in ascending order by their Valid to date. Clicking a link opens the article in Now Platform?

if More than 10 – The email notification includes a View the list of expiring articles link, which when accessed opens a list in Now Platform of all articles expiring in the next month.?

How can i achieve that?

Thanks

Deepika

[Harish KM]

HI you can have a scheduled job with following script:

var gr = new GlideRecord('kb_knowledge');
gr.addQuery("workflow_state", "published");
gr.addQuery("valid_to", "=", gs.daysAgoStart(-30));//less than 30 days
gr.addQuery("valid_to", ">", gs.now());
gr.query();
while (gr.next()){
gs.eventQueue("kb.expired20", gr, "", ""); // fire event to author
}

[Deepika61]

Hi Harish,

Thanks for the response

So like i mentioned, i need to trigger notification like

Like if up to 10 – The email notification includes a list of article links displayed in a tabular format and arranged in ascending order by their Valid to date. Clicking a link opens the article in Now Platform?

if More than 10 – The email notification includes a View the list of expiring articles link, which when accessed opens a list in Now Platform of all articles expiring in the next month.?

How can i achieve this email notification contains links?

Thanks

Deepika