Is it possible to see any Catalog items a person approves?

[deepa231]

Is it possible to see any Catalog items a person approves? For example: Abel Tutor. Which catalog items he is mentioned as a static approval?Do we need to check every table with static values? How we could identify it? What I am looking for is a way to identify where my name is mentioned as a static approval. E.g. as a Application Owner in CMDB apps.

[Mark Manders]

There is no one place to find this. Especially because it can be done through (work)flows and approvals can be set to users/groups and any place where users/groups are used on tables. You will need to check on every (work)flow that is used to see what exactly is set. And because it can be both just referencing to the field, or through scripts, you won't be able to know everything 100% in any other way.
I know of some clients having a custom table containing all kinds of logic around catalog items, including the setting of approvals, the number of approval levels, etc. and if you have something like that, it's an easy query on that custom table, but OOB it's just not simple to find.

[deepa231]

can we create any reports to understand this a combination of multiple reports?

[Mark Manders]

No. Because reporting on those tables isn't even possible OOB (not in the way you want to). Go through everything and document for future reference.

[Ankur Bawiskar]

@deepa231 

you can see limited information on sysapproval_approver table

For determining which catalog item he/she is mentioned as static approval, you will have to search in either workflows  flows manually.

Data for flow is stored in multiple tables so you won't know this data directly.

If my response helped please mark it correct and close the thread so that it benefits future readers.