how to get report on all the catalog items and its respective approvers, approver groups
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2022 09:14 AM
I want to create report on all catalog items and respective approvers for the catalog items. Can anyone help me out with this?
- Labels:
-
Service Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2022 09:35 AM
Hello,
You can configure the report on "sysapproval_approver" table and keep the condition for report as source table is "sc_req_item" and if you want to do group by approver in group by column select group by approver and run the report . You can select type of report as bar graph.
please see the attachment attached for clarification.
This is for getting only approvers report. But if you want to do for groups as well create another report on the same table with the same mentioned condition above and do group by "Group field" and type as bar and run the report. You can see multiple bars and they are divided by groups
please mark this helpful if you find it useful.
Thanks ,
Mohith Devatte.