In ServiceNow, gather all approval requests created last week (sysapproval_approver records)

Vignesh Muthusa
Tera Contributor

In ServiceNow, gather all approval requests created last week (sysapproval_approver records). Group them by approver and collect the list of tickets each person was asked to approve.

 

This solution script is intended to help others.

 

var approvallist={};
var gr=new GlideRecord('sysapproval_approver');
gr.addQuery('sys_created_on','>=',gs.beginningOfLastWeek());
gr.addQuery('sys_created_on','<=',gs.endOfLastWeek());
gr.query();
 
while(gr.next()){
 
var approver=gr.approver.toString();
var approvalFor=gr.sysapproval.getDisplayValue();
 
if(!approvallist[approver]){
approvallist[approver]={
emailname:approver,
approvaltikcets:[]
};
}
 
approvallist[approver].approvaltikcets.push(approvalFor);
 
}
 
for(var user in approvallist){
var information=approvallist[user];
var infolist=information.approvaltikcets.join(' , ');
 
var eventParms={
'Approver Name': information.emailname,
'List information':infolist
};
 
gs.eventQueue('Event_name',null,information.emailname,JSON.stringify(eventParms));
}

 

 

0 REPLIES 0