Create an request item report that shows all approvers

samfrench
Kilo Contributor

Hi All,

I'm trying to run a Request Item report that shows all of the approvers involved.

Currently I have only been able to report on the last person that has approved with the addition of the Approval History.

Is there a way to display all of the approvers?

Regards,
Sam

4 REPLIES 4

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Sam,



What are the filter conditions that you have used in report?


Hi Pradeep,



Thanks for replying on this.


I'm reporting on the Approval[sysapproval_approver] table.


And the only filter I have is on short description as I am trying to see who have approved access to the following service catalogue item.  


Hi Sam,



Can you try to apply the filter by catalog item and see if that makes any difference.


Please refer screenshot for reference. You have to dot-walking to get to those fields.


Screen Shot 2016-04-18 at 10.37.47 AM.png


Pradeep,



How did you dot-walk to the Item on the sysapproval_approver table?



Thanks in advance,


-Marques