Help exporting Change Request with approval data...

Andrew C2
Kilo Contributor

I have a need to pull out Change Requests along with the approval date and times listed in an .xlsx format is there something I am missing? I can export Change Requests but it does not export the approval data needed. Any help would be most appreciated.

2 REPLIES 2

premer
Giga Expert

Hello,

I think you need to run your report on the Approval table for this (sysapproval_approver). As a filter you could then put something like Approval For.Number starts with CHG, and if you need to add columns from the change itself, you can dotwalk through the Approval For field to access the change fields.

M_rio Rui Castr
Kilo Expert

Hello Andrew,

 

I had the same issues when in need to gather data from different tables into a single xlsx file. ServiceNow didn't seem to have a solution for that. We then decided to develop an application that allows you to get data from a specific change request and then merge it with change task information and even approvers... all in the same excel sheet and based on your preferences.

Maybe it fits your needs... please check the following article for more information: