Report on change Approvers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2025 06:09 AM
How to create a report on changes that have the same approver for both the ABC Group and the XYZ Group.
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2025 08:07 AM
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.