Report on change Approvers

GBS
Tera Contributor

How to create a report on changes that have the same approver for both the ABC Group and the XYZ Group. 

5 REPLIES 5

Hi @GBS,

Okay.. You can achieve this with a script include and later call that script include in report.
I tried with background script and I'm able to get the approvers and groups of a change.
Later you can write a code where you will check if the approvers are same from both the groups.

 

var approvers = [];
var groups = []
var cm = new GlideRecord("sysapproval_approver");
cm.addEncodedQuery("sysapproval.numberSTARTSWITHCHG0030001^state=approved");
cm.query();
while(cm.next()){
approvers.push(cm.approver.toString());
groups.push(cm.group.assignment_group.toString());

    }

gs.log("approvers : "+approvers);
gs.log("Groups "+groups );

 

If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.