Displaying the group an approver belongs to

[KB15]

I'm looking to add the name of an approver's approval group in a change request. We have a few groups approving and it's hard to keep track of who's approval is for what group. Is this a script or can it be done a simpler way? I'd also like to add this into a notification as well.

[KB15]

Thanks Michael. So I added this column but strangely, this is what shows up as the listed groups. They're definitely not what these groups are called though they point to the correct groups.

[marcguy · Accepted solution]

you would need to add the 'assignment group' column from that group record, which is misleadingly a task record on the sysapproval_group table.

so group.assignment group is the actual group whom this users has approved on behalf of.

Marc

[KB15]

Thanks for the tip. That worked out.

[Kalaiarasan Pus]

Isn't the approval history helpful?

http://wiki.servicenow.com/index.php?title=Task_Table#Important_Task_Table_Fields