How to create a Report that shows RITM's waiting Approval by Group Approval Name.

[michelle kirk]

Hi,

I have tried and failing miserably to create a report that I can add to a Dashboard that shows the following:-

No Of RITM awaiting Approval

Status is not Approved, Rejected, Completed, Closed

By Group Approval - must be able to select the Group Approval Name

By Age 

Could someone please advise the table that I need to use please,  I have tried 

sysapproval_group

sc_req_item

Whilst they nearly give me what I want it doesn't give me the full output.

Anyone able to help whether I can report on the above please ?

[Brad Bowman · Accepted solution]

Hi Michelle,

It sound like a Database View will get you going in the right direction.

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/use/reporting/concept/c_Databa...

You would join the sc_req_item and sysapproval_group tables on the RITM sys_id, and this will give you access to every field on both tables for your report - which will now use the database view name as the table.

Here's what your database view will look like:

[michelle kirk]

Hi

We do not have that view as it will be owned by out platform providers.

is a way of running a report that will give me this information and I can then just add it as a widget  ?

If not I will ask our providers to create a report for me.