Help exporting Change Request with approval data...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-27-2020 11:12 AM
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.
- Labels:
-
Change Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-27-2020 11:46 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-03-2020 09:16 AM
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.