How we can mass delete comments from records?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2026 08:15 AM
We recently bulk loaded comments on around 10000+ cases. Unfortunately the work notes as well got loaded as comments and now internal work notes are visible to the customer through portal. We are trying to delete all comments now. We removed the entry from sys_journal_field table but still the comments are visible.
Went through below Kb as well
How to delete or edit sensitive comments in ServiceNow records - Support and Troubleshooting
But is there any script that can help with mass deletion?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2026 09:54 AM - edited 03-20-2026 09:55 AM
Hi @gazalagrawa ,
So already you have checked I guess, that this kind of mass deletion of Comments of records is not recommended.
In our project we did delete comment activity when someone mistakenly added sensitive info in comments.
As per this post :
YOu can do this export all records in xml-> using truncate command delete all record -> reimport clean record xml As background script is pretty slow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2026 03:36 AM
Deleting comments from sys_journal_field table is not deleting them from the record activity.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2026 10:16 AM
Hello @gazalagrawa ,
You can also refer this also , may this help you :
If this helps you then mark it as helpful and accept as solution.
Regards,
Aditya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2026 03:38 AM
I earlier referred the KB mentioned in that post, I could not find history_set table.
