How to Download / Export the Work Notes from ServiceNow to Excel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2020 12:09 AM
Hi! I am writing the Work Notes of the ticket on a daily basis, and preparing a report about the status. I would need to download them and number of activities since their check is useful to understand how many times I am woking on the same ticket. If I use "Comment and notes" as field required in my report, it is not downloading the work notes. At the moment, I am opening ticket by ticket and updating the excel tracker manually. I was thinking to create a bot but I do not know from where to start. Thank you, any help is much appreciated!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-03-2020 11:19 PM
In order to get your worknotes try to use sys_journal_field table. If there is needed more data you might need to create database view connecting this table and ticket table.