How to Delete or Update work notes or additional comments ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-01-2020 04:01 AM
How to Delete or Update work notes or additional comments ?Please Provide any examples also
Scenario: we entered wrong comments in work notes , we want delete that work notes.
Note:i tried delete and update at sys_audit table but not deleted.
Please help me.
Thanks
Ram

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-01-2020 04:39 AM
Hi there,
It's not something I would advice, though yes of course possible.
Just have a look at these 3 tables, it's a combination of these. Replace the instance name, and replace the record id:
https://your-instance.service-now.com/sys_journal_field_list.do?sysparm_query=element_idSTARTSWITH09c0744b37f28300a4d212c543990e64&sysparm_first_row=1&sysparm_view=&sysparm_choice_query_raw=&sysparm_list_header_search=true
https://your-instance.service-now.com/sys_audit_list.do?sysparm_query=documentkey%3D09c0744b37f28300a4d212c543990e64&sysparm_first_row=1&sysparm_view=&sysparm_choice_query_raw=&sysparm_list_header_search=true
https://your-instance.service-now.com/sys_history_set_list.do?sysparm_query=id%3D09c0744b37f28300a4d212c543990e64&sysparm_first_row=1&sysparm_view=
If my answer helped you in any way, please then mark it as helpful.
Kind regards,
Mark
---
LinkedIn
Community article list
Kind regards,
Mark Roethof
Independent ServiceNow Consultant
10x ServiceNow MVP
---
~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-01-2020 08:30 AM
1 Obtain the sys_id of the record
- Open the record containing the insecure SEI.
- Right-click in the record header, and choose Copy sys_id.
2 Remove from sys_journal_field
- Use this URI to query the journal entries: https://your-instance.service-now.com/sys_journal_field_list.do?sysparm_query=element_id=sys_id
- Replace sys_id with the sys_id of the record.
- Replace your-instance with your instance name.
If there are a lot of records, you may want to refine the query, adding a "Value contains SEI" condition. Replace SEI with the text you seek.
- Edit the Value field of each record to remove the SEI.
3 Remove from sys_audit
- Use this URI to query the audit entries: https://your-instance.service-now.com/sys_audit_list.do?sysparm_query=documentkey=sys_id
- Replace sys_id with the sys_id of the record.
- Replace your-instance with your instance name.
It may be helpful to add conditions to the query for "Old value contains SEI" OR "New value contains SEI".
- Edit the text of the Old value and New value fields, removing the SEI.
4 Delete the sys_history_set record
- Query the sys_history_set table using this URI: https://your-instance.service-now.com/sys_history_set_list.do?sysparm_query=id=sys_id
- Replace sys_id with the sys_id of the record.
- Replace your-instance with your instance name.
- Delete the record that is returned.
Reference:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-01-2021 07:30 PM
Thank you Harshvardhan!
The method that you provided above helped my organization in a urgent situation tonight involving one of our Problem record work notes sections.
Much appreciated!
Terry Carter - Synovus
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2023 05:40 PM
Thank you Harshvardhan. The resource was very useful to resolve my issue.