bulk delete all spam comments of a given user (then the user itself)

Martin64

Hi,

We have an user that is posting spam comment in some of our projects. We would like to delete all its comments (we don't want these to appear). How is it possible to do this in bulk ?

When this required step is achieved we will be able to delete the user completely.

Thanks !

Anna Cardino

Hi Martin,

Deleting directly from the database is not recommended. But you can use the Script Runner plugin and the following script to delete all comments containing a specific text (in this case "Bla Bla Bla") in a specific issue (here TXS-561).

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.issue.IssueManager import com.atlassian.jira.issue.MutableIssue import com.atlassian.jira.issue.comments.Comment import com.atlassian.jira.issue.comments.CommentManager String issueKey = 'TXS-561' IssueManager issueManager = ComponentAccessor.issueManager CommentManager commentManager = ComponentAccessor.commentManager MutableIssue issue = issueManager.getIssueObject(issueKey) List<Comment> comments = commentManager.getComments(issue) comments.each {comment -> if (comment.body.contains('Bla Bla Bla')) { commentManager.delete(comment) } }

Hope it helps.

Monique