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.

List out service catalog items with Approval - User Approvers

Ganesan5
Tera Expert

is there a table which can list out the list of approval which mapped to users ?

1 ACCEPTED SOLUTION

Ok, got it!!
@Ganesan5 
Navigate to - '/wf_activity_list.do?sysparm_query=activity_definition%3D35433da80a0a029a0028c639a1e51eb4%5Eworkflow_version.published%3Dtrue&sysparm_first_row=1&sysparm_view='

Hope this may resolve your query for what you are looking for!!

Please mark my response correct/helpful as applicable!
Thanks and Regards,
Rahul

View solution in original post

5 REPLIES 5

Rahul Talreja
Mega Sage

Hi @Ganesan5 ,
sysapproval_approver is the table which will give you insights about the approvals an individual has.
If you're looking for something else, please let me know.

Please mark my response correct/helpful as applicable!
Thanks and Regards,
Rahul

Hi Rahul, 

Thanks, just to add more details, I am looking to generate a list of workflow with "Approval - User" as one of steps and who is the user currently maintained as approver. 

 

Ganesan5_1-1692074231077.png

 

 

Ok, got it!!
@Ganesan5 
Navigate to - '/wf_activity_list.do?sysparm_query=activity_definition%3D35433da80a0a029a0028c639a1e51eb4%5Eworkflow_version.published%3Dtrue&sysparm_first_row=1&sysparm_view='

Hope this may resolve your query for what you are looking for!!

Please mark my response correct/helpful as applicable!
Thanks and Regards,
Rahul

Hi @Ganesan5 ,
Did it worked for you?

Please mark my response correct/helpful as applicable!
Thanks and Regards,
Rahul