Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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.