Community
Products
Jira Service Management
Questions
How to generate a Users activity tracking report in JIRA?

How to generate a Users activity tracking report in JIRA?

Need to generate the Users Worklog Activity report from JIRA. Purpose is taking the timesheet report.

2 answers

3 votes

Hello all,

There has been a lot of views on this thread recently meaning that a lot of people are still looking for a good solution, And I have recently discussed a few options in two newer but related threads as possible solutions viewable at the links below:

And I particularly wanted to draw attention to this portion as I believe it lines up as the best solution here:

There is a really good exe on how to do this on a per user basis from the API with example scripts linked via github repos in the following community post, which could be easily modified to exclude the user specific worklog and focus on the full release details, and would be a really good starting point to pull and collate the data set:

https://community.atlassian.com/t5/Jira-questions/How-can-I-generate-a-report-of-time-logged-per-person-and-not/qaq-p/3093

Hope this info help y'all out

Regards,
Earl

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Earl McCutcheon

The reports you reference only report on time logged. I am looking for a report to show all activity by user i.e. hours logged, comments added, issue transitioned. Does Atlassian have anything along these lines?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

Hello @Jeanne Howe ,

A few options to look into would be that you can use an activity stream gadget on your dashboard and adjust the filter of this gadget to "Add a global filter" using saved filters for the specific users you want to track for a dashboard-style reporting option. this would be good for a quick view status update report.

Next, if you wanted a more detailed report you could look into third party add-ons such as Issue History for Jira Cloud. as mentioned in this comment on a related thread:

https://community.atlassian.com/t5/Jira-questions/Re-Viewing-a-user-s-history/qaq-p/1074295/comment-id/342782#M342782

With some other related apps listed at the link below for user tracking:

And another option is to use the google sheets add-on "Jira Cloud for Sheets" or the Excel Add-on "Jira Cloud for Excel (official)" using a time-based polling effort with something like a "Custom Functions in Google Sheets" or "Excel VBA macro" to update the reports on an interval for the periodic view with a compare between reports.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

3 votes

Hi Venkatesh,

You can generate the report by going to the Project, clicking on Reports on the right. In the window scroll down to User Workload Report under Forecast & management.

Hopefully that helps!

Cheers,

Branden

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks Branden.

This option gives me to generate only for the particular project, but i required to generate the User's Activity report for all the user's across the projects with monthwise.