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

Community Alums — Tue, 24 Jun 2025 13:15:41 GMT

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));

}

question In ServiceNow, gather all approval requests created last week (sysapproval_approver records) in Community Central forum

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