Approvers in the system

aditya174 · ‎09-12-2023

How to create a report or PA widget in order to calculate the number of approvers(users who have either approved or rejected requests) that are there in the system who have approved or rejected any request for the last 1 year.

SANDEEP28 · ‎09-13-2023

@aditya174 You can create report on "sysapproval_approver" table and add below filters

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

View solution in original post

SANDEEP28 · ‎09-13-2023

@aditya174 You can create report on "sysapproval_approver" table and add below filters

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

aditya174 · ‎09-13-2023

the table name is not coming in my report Where should I make the changes to get it?

Dr Atul G- LNG · ‎09-13-2023

Hi @aditya174

By which role you are trying, it seems there can be ACL on this for a specific role.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

SANDEEP28 · ‎09-13-2023

@aditya174 In which scope are you trying to create report ? Can you share a screenshot