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.
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.
Try this plugin.
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.
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
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.
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 !!
See how to use Jira on the go! Demo Den Episode 5 is here: meet Jira Mobile with Jira Product Manager Rayen Magpantay. Demo Den is in our monthly series where a Jira PM demonstrates...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events