How we can mass delete comments from records?

[gazalagrawa]

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?

[Tanushree Maiti]

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.

[Aditya_hublikar]

Hello @gazalagrawa ,

You can also refer this also , may this help you :

https://www.servicenow.com/community/itom-forum/how-to-delete-modify-edit-work-notes/m-p/945188/page...

If this helps you then mark it as helpful and accept as solution.

Regards,
Aditya