How to generate a Users activity tracking report in JIRA?

[Venkatesh]

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

[Earl McCutcheon]

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:

• https://community.atlassian.com/t5/Jira-Software-questions/WorkLogDate-vs-date-work-was-performed/qaq-p/1499385
• https://community.atlassian.com/t5/Jira-questions/How-to-access-total-time-logged-per-release-outside-of-Jira/qaq-p/1185180

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

[Jeanne Howe]

@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?

[Earl McCutcheon]

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:

• https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=user%20history
• https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=user%20activity

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.

[somethingblue]

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

[Venkatesh]

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.

[Marc Demhartner]

Did you manage to find such function/report ? I am also looking for such an option

[Rob Crowell]

As am I. We need to produce a monthly report of all JIRA users for auditing purposes.

[Joshua Sisk]

Anyone figure out a way to do this Jira-wide, not just for one project?

[Oleksii Mikov]

+1 looking for this feature

[Jaco Steyn]

Is there a solution for this request yet?