Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Report on change Approvers

GBS
Tera Contributor

How to create a report on changes that have the same approver for both the ABC Group and the XYZ Group. 

5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @GBS 

 

What is your use case? i dint think it is not easy way to get or need some script.

*************************************************************************************************************
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]

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

Hi @GBS 

 

Create a report on the 'sys_approval' table and then group it by the 'Approval For' field.or group by Approver.

 

DrAtulGLNG_0-1751462765457.png

 

*************************************************************************************************************
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]

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

Mohammad Danis1
Giga Guru

@GBS , Please elaborate with example.

@Mohammad Danis1 I want to create a report which shows the changes that are approved by the same person from both the groups