question Re: How I can automate sending CAB invitation by system itself every week in ITSM forum

How I can automate sending CAB invitation by system itself every week

Priyanka Sadhw1 — Tue, 09 Jun 2020 10:24:47 GMT

What I thought was job should run every week and send mail.

There are 2 UI action which should run

I am looking for script in Job which can hit/click these 2 links

May be 2 different job which pick CAB meeting record for current week and click 2 links

1)Refresh Agenda items- once we click on this , decision box like this come lets say if I press No every time

2)Send meeting request to attendees- next when this link is clicked- Another decision box- where I say send all.

Re: How I can automate sending CAB invitation by system itself every week

MrMuhammad — Tue, 09 Jun 2020 10:41:39 GMT

Hi Priyanka,

If I am following you correctly, then I believe you only need server side code of the mentioned UI actions. I would suggest wrapping the server side functionality of both the UI actions inside a new script include and calling it from your scheduled job.

I hope this will help.

Please mark this accepted/helpful, if applicable.

Thanks & Regards,

Sharjeel

Re: How I can automate sending CAB invitation by system itself every week

Priyanka Sadhw1 — Tue, 09 Jun 2020 11:19:12 GMT

Hi Muhammed,

As I am not good at scripting and sorry to ask such question

But i am not sure what these highlighted lines are- where Do i check this code.

Re: How I can automate sending CAB invitation by system itself every week

MrMuhammad — Tue, 09 Jun 2020 11:43:01 GMT

So, there are three parts of the script. In the first part we have a function name ShowConfirmationPopup.

This function is running on client side and generating a nice Send Meeting Notification popup with two buttons Send to all and Send to New. When you click on Send to new below function called and executes.

Above function is running on server side and it first remove the popup from the screen and trigger event which in response send notification to all the new attendees.

If user clicks on Send to All then third function called and executes.

This function is also running on server side and it triggers event that send notification to all the attendees.

In your case if you write a scheduled job that runs on server so you cannot leverage client side code (first function) rather you can only use next two functions that is running on server side and supported by Scheduled job.

I hope this will help you get an idea of how UI action is working and how you can leverage the script in job.

Please mark this accepted & helpful, if you applicable.

Thanks & Regards,

Sharjeel

Re: How I can automate sending CAB invitation by system itself every week

Priyanka Sadhw1 — Tue, 09 Jun 2020 12:33:05 GMT

Hi Sharjeel,

I cant see event -sn_change_cab_notify_all_attendees

Re: How I can automate sending CAB invitation by system itself every week

MrMuhammad — Tue, 09 Jun 2020 14:29:04 GMT

sn_change_cab_notify_all_attendees is action name being used in Notify All Attendees Ui action and which is getting called from Send meeting request to attendees via that action name. Events are getting triggered by Notify All Attendees UI action. See screenshot below.

Above Ui action is calling CABMeeting() script include and that script include calling another script include.

I would recommend not to go that deep into the script as you are not very into scripting so will be lost.

If you know how to script a scheduled job, just wrap two server side functions I explained in the first UI action into the Script include and call from the job with minor tweaks. It will do the job.

Please mark this accepted & helpful, if it helps.

Thanks & Regards,

Sharjeel

Re: How I can automate sending CAB invitation by system itself every week

Priyanka Sadhw1 — Tue, 09 Jun 2020 14:34:09 GMT

Actually Job I was trying since your first reply

See- after if section- not able to understand what is happening

Re: How I can automate sending CAB invitation by system itself every week

MrMuhammad — Wed, 10 Jun 2020 01:47:17 GMT

CABMeeting script include is in scoped app so you have to give fully qualified name domain + script include name.

sn_change_cab.CABMeeting(gr)

Also, here is the sample code I just ran for quick testing in the background script and its working fine.

var gr = new GlideRecord('cab_meeting');
gr.addQuery('sys_id', <sys_id>); // replace sys_id with any Cab meeting sys id.
gr.query();
gr.next();
gs.print(gr.getRowCount());

var notifiedAttendeesCount = new sn_change_cab.CABMeeting(gr).createCABAttendeeNotifyEvents();
var infoMessage = notifiedAttendeesCount > 0 ? gs.getMessage("Notifications sent to all attendees") : gs.getMessage("No notifications sent as there are no attendees");
gs.print(infoMessage);

Replace <sys_id> with one of your Cab meeting sys ID in the above code and test in background script and see the output for reference. after that you can modify this as per your need

Let me know if you face any issues.

Please mark this accepted & helpful, if it helps.

Thanks & Regards,

Sharjeel

Re: How I can automate sending CAB invitation by system itself every week

Priyanka Sadhw1 — Wed, 10 Jun 2020 06:35:21 GMT

Hi Sharjeel,

It is working by hardcoded sysid.Now I need to fetch meeting sys_id weekly- may be in encoded query, which is not happening

Re: How I can automate sending CAB invitation by system itself every week

Priyanka Sadhw1 — Wed, 10 Jun 2020 07:32:19 GMT

It is wrking now after removing @

Re: How I can automate sending CAB invitation by system itself every week

Bhagyashri Sort — Wed, 10 Jun 2020 10:48:53 GMT

Hi,

You can use the schedule job for such type of repeated notification. Refer below links

Schedule Job

Schedule Script and Event

If my response helps you, make it correct and helpful.

Thanks

Bhagyashri Sorte.

Re: How I can automate sending CAB invitation by system itself every week

MrMuhammad — Wed, 10 Jun 2020 11:13:51 GMT

Glad It works! Happy Coding.

Kindly mark the appropriate response accepted and helpful so that others can be benefited by this and this thread can be closed as solved.

Thanks & Regards,

Sharjeel

Re: How I can automate sending CAB invitation by system itself every week

Swapnil Soni1 — Wed, 10 Jun 2020 11:22:02 GMT

Hi Priyanka,

Please check the link this helps you

https://community.servicenow.com/community?id=community_blog&sys_id=e30d6ea5dbd0dbc01dcaf3231f96190d

Mark correct or helpful if this works to you.

Thanks

Swapnil

Re: How I can automate sending CAB invitation by system itself every week

MrMuhammad — Wed, 10 Jun 2020 11:47:02 GMT

@Priyanka Sadhwani one thing I noticed is that you should wrap your line 6,7 inside While loop so that it trigger notifications for all the cab meetings retrieved as part of our query.

while(gr.next()){
 var notifiedAttendeesCount = .....................;
 ..................

}

Re: How I can automate sending CAB invitation by system itself every week

Priyanka Sadhw1 — Fri, 12 Jun 2020 06:13:29 GMT

In Automated Job- may mails are sent than expected..it should send approx 18 mail

Re: How I can automate sending CAB invitation by system itself every week

MrMuhammad — Fri, 12 Jun 2020 08:10:38 GMT

You are expecting 18 emails and it triggered 16 right? Can you show me the latest code?

Re: How I can automate sending CAB invitation by system itself every week

Priyanka Sadhw1 — Fri, 12 Jun 2020 08:47:45 GMT

Hello,

Issue was with encoded query, i changed to - gr.addEncodedQuery("active=true^startONThis week@javascript:gs.beginningOfThisWeek()@javascript:gs.endOfThisWeek()");

Seeems Working , testing in progress

Re: How I can automate sending CAB invitation by system itself every week

MrMuhammad — Fri, 12 Jun 2020 10:31:19 GMT

Cool. Let me know if you need any help.