What group approvals are used for Items

[Jacob23]

Hi,

Thanks for taking the time to read. In my company we use group approvals for certain items. I am trying to find out what items uses a specific group approval.

For example, if Service Desk Managers group approval was used on 10 flows/workflows. How do I find out what catalog items these are without having to go through each individual flow and finding the group approval listed.

I tried to do a dot walking from the sysapproval_group table to the ritms and find the item, but I cannot find the item field listed. I think this is because the field is a refecnce field to the catalog table.

I assume I need to create a database view but getting a little stuck here as I have never done one before. Might someone be able to assist.

Thank you!

[shivambitanwar · Accepted solution]

Hi Jacob,

By following this community answer , create a database view by going to System Definition > Database Views

https://community.servicenow.com/community?id=community_question&sys_id=6bbd655cdb39db0058dcf4621f96...

After that create a report using this database view, select data source as table and use name of the database view to search the table needed to be used in report.. you can pull the following columns to have your data.

Regards,

Shivambi

[Jacob23]

Thanks Shivambi, this worked. Much appreciated!