Run report to include an Approval Group column

[mgoodwin12]

Hi,

I have a client who is asking me to run a report with the following columns:

Change request #

short description

planned start date

planned end date

application

application service

approval group?

and approval

I'm able to pull everything into the report except "approval group". Would this come from another table? Do I need admin access to pull this data? If so, is there a way I can pull it without admin access?

Thanks in advance,

Maria

[SAI VENKATESH · Accepted solution]

Hi @mgoodwin12 

Yes , the "Approval Group" information in ServiceNow will comes from the sysapproval_group or sysapproval_approver table,

Thanks and Regards

Sai Venkatesh 

[SAI VENKATESH · Accepted solution]

Hi @mgoodwin12 

Yes , the "Approval Group" information in ServiceNow will comes from the sysapproval_group or sysapproval_approver table,

Thanks and Regards

Sai Venkatesh 

[mgoodwin12]

So how would I run the report to include Changes from 6/1/24 to now and include all of the columns I mentioned?

[AndersBGS · Accepted solution]

Hi @mgoodwin12 ,

you need to run the report based on sysapprovel_approver table, and then dot-walk to change_request table… this should solve the query.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders