Is it possible to report on which Request Forms are associated to which Approval Group?

[michelle kirk]

Hi

Does anyone know a way of extracting from Service Now, all the Approval Groups together with the Request Catalogue item it is associated with ?

[OlaN]

Hi,

There is not a 1-1 relationship between an approval group and a Request, a Request can have zero, one or more approval groups associated to it.
What is it you want to show with the report?

[michelle kirk]

Hi thank you for your response, 

I am trying to understand which approval groups are aligned to which Request Type and extract the info out of service now, without having to manually go into each request type and look at the workflows. 

[OlaN · Accepted solution]

I would start by looking at reporting on the Group approval table [sysapproval_group]

Then filter the results to only show records that has the parent task type as Requested item.

Then select to show data from the Requested item table on the results and work on from there.

[michelle kirk]

thank you - will have a go