Count the number of comments made by user

Goal:

We want to track the number of unique comments our users are making in Jira.  We have reporting on the number of issues resolved, but we are trying to track details on a more granular level.  User make comments whenever they have logged some work or have new information for a ticket.  Having reporting on the number of comments a user is making will give a more accurate picture as to how much work a user is accomplishing.

What I have attempted:

We currently have  script runner and custom field "comment count".  However these return incorrect results because JQL is only capable of returning a list of issues.  From issue lists I can see the number of comments on each ticket, but often a ticket will have varying levels of collaboration resulting in comments made by different users.  A total count benefits the assingee not the individual user that made the comments.  

Can anyone think of a method to get the a total count of comments made by a user across all issues? 

We use eazybi for reporting as well but can't find a method to display the info correctly there.

Thanks.

 

 

 

3 answers

Hello,

Try this plugin.

https://marketplace.atlassian.com/plugins/com.atlassian.jira.toolkit

You can get a comment count of each issue. (Also attachment count ,as added bonus  if you need)
Further you can write a JQL to find the comment count  by each user.
(I haven't tried this plugin, i just found it while looking for something else) 

 

Thanks this is a good addon, but does not solve my exact issue correctly. I currently have this addon installed. It gets close to the problem but is still limited by only returning the total comments on an issue or the total issues a user has contributed on. It does not show how much contribution users have made to the issue ie number of comments per user.

One other suggestion i could give is Database Custom Fields Plugin. You can create a custom field and query JIRA database to find the count of comments per each user. I am currently trying achieve this in my Test JIRA and i will let you know how it goes.

Well this is what i tried and it looks like it might be close to what you are looking for.

https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.databasecf


Using database Custom Fields Plugin, i have created a custom field "Comments Count"
of type 'Data Table Information'. And i used a T-SQL query to get the data from JIRA Database.

Here is the query i used. You can modify it to get data specific to the projects you need, because the query i wrote now is getting the data from all projects in my JIRA instance.

SELECT AUTHOR AS User_Name, COUNT(*) AS Comment_Count
FROM Database_Name.jiraaction
WHERE actiontype = 'comment'
GROUP BY AUTHOR HAVING Count(actiontype) > 0

(Replace Database_Name with the name of the database your JIRA uses.)
Hope this works for your problem. Lemme know if you need any help. 

I'd start with a description of the desired report. It sounds like you want be able to specify a jql filter and the produce a histogram of userids and the number of comments by each user in that set of issues. Personally I'd write a report plugin that does this or a gadget. I suppose a groovy script could also produce the same report but that's for JIRA admins only. Or a JIRA python script though it would be much slower.

With the help of IT we were able to access the database and found a table that showed the total amount of comments made by each user. It looked correct and exactly the type of data I am looking for. I am still working on setting up the configuration so that Kepler is able to display that info into JIra. I am hopeful that this solution will work. This is the resource I am using to configure the data source. http://confluence.kepler-rominfo.com/display/DBCF/Data+Source+Configuration Matt: My Team leads are looking for the ability to review the number of tickets each user has resolved. What number of those tickets were closed within our SLA goals. And the total number of comments each user made. The current limitation of any JQL search is that it returns issues. Thus creating problems getting an accurate count of a users comments across all of Jira. Currently the SLA and resolved issues is easily adjusted to review different time periods. I am worried with Kepler how difficult it will be to adjust the time frame that comments were made. I don't know yet if that is something Jira admin only will be able to adjust or if team leads will be able to adjust that info easily. I don't have the skills to be able to write a report plugin so I am hoping Kepler it be a solution.

Matt: I am a SQL Developer/DBA myself, so i find it comfortable to work with solutions involving Query's or Databases rather than Groovy or other Scripts. But i had to write a few Groovy scripts too for some customization. Greg: The table i found is "jiraaction", i don't know if that's the same table you found. But, Once you configure the context.xml file, you can play around with SQL queries to suit your requirements.

I was having several issues with kepler and ended up having to remove that addon.  I found that Eazybi had the option to import from SQL.  I used a search similar to what Uday suggested and was able to import the information.  

Eazybi worked great because I was able to have that info in reports and in dashboards right away.  It was also nice because team leads can sort comments by date and other metrics if necessary. 

https://docs.eazybi.com/display/EAZYBI/Import+from+SQL+SELECT

Thanks for your help. 

Good to hear that. I Never used Eazybi, but will check it out now. Glad i could help you. If you think my answers helped you, Do please Up-vote. Thanks in Advance. Cheers !!

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

Meet the AUG leaders of Northern Virginia

@Rachel Wright (Jira Genie), @Billy Poggi (AUG NOVA, DC), and @Dana Jansen (Confluence Queen) are just some of the folks that lead one of the world's most active Atlassian User Group (AUG)....

154 views 5 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you