We need a report on who has approved a list of changes

[Melvyn Jacobs]

We are looking to get a report on who the approvers are, for a given list of changes. The change list is derived from filtering on a set of Assignment groups and Planned Start dates

[Shubham_Shinde]

Hello @Melvyn Jacobs ,

Probably you can create a Report with the source table set to "Approval (sysapproval_approver)", and configure it to be grouped by Approver. You can then filter the data based on your required conditions like below (please make sure to add this condition: source_table is change_request ) (You can add conditions for change request fields by using dot walking: Approval For -> Change Request -> Planned Start Date AND Approval For -> Assignment Group ). The below shown report will return the number of changes each approver has approved after the planned start has passed and will show change requests assigned to the assignment groups mentioned in the condition:

After clicking the bar for each user, you will be redirected to a list view showing the change requests approved by that particular user.

Please mark this comment as helpful/correct if it helps you.

Regards,

Shubham