In ServiceNow, gather all approval requests created last week (sysapproval_approver records)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2025 06:15 AM
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