How can we find out if a user has added comments on issues
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Scenario
In some situations it is necessary to confirm if a user has added comments on issues, eg: when deciding to permanently delete a user or anonymize it.
Solution
This can be checked on Jira database, by running the following query:
select * from jiraaction where author = 'vargadav' and actiontype = 'comment'
Relates to:
How to change the author of a comment in Jira
LDAP user deletion effect in Jira user base