Extracting worklog for all users who logged into a single issue

[Rohit Sodhi]

Hi,

Is there a way to extract or create a report which provides a worklog of all the users who are logging work on a single story?

The JQL is reporting consolidated work log for the assignee of the story, but in my case there are multiple users who are logging work in the same ticket(Not traditionally correct but doing so due to the nature of work we do) .

Let me know if there is a way or will have to continue extracting this manually.

Thanks,

Rohit

[Deniz Oğuz - The Starware · Accepted solution]

Hi,

To the best of my knowledge, obtaining a user-based worklog report in Jira Cloud without utilizing a timesheet application is currently not possible. The majority of timesheet apps available on the marketplace, including our own app called WorklogPRO, offer reports that are organized by user.

[Dániel Ballabás - catworkx · Accepted solution]

Hi Rohit!

If you are interested in app based solutions to your question, please allow me to show you our app's, Timetracker's answer:

If you need quick information, you can look at the right sidebar glance view on each Issue, which will show you a summary like my screenshot.

If you need more detailed information, you can use the Summaries or Timesheet views on our Reporting panel.

We are happy to show you a full demo if you are interested.

Daniel

Disclaimer: I'm from EverIT, the vendor developing Timetracker.

[Aron Gombas _Midori_]

It is not rare that multiple users log work on the same issue.

What exactly would be your desired output? The list of users per issue who logged work on that? Or the list of users per issue and the total hours per user per issue? Or what?

[Rohit Sodhi]

It's the latter.. List of users per issue and the total time logged per user during a specific time period, possibly grouped by month

[Aron Gombas _Midori_]

With the Better Excel Exporter app, you can get a list of issue and worklogs:

...or even create a pivot table using users, year, month, date, project, issue type or any other issue field as dimension:

Using the standard Excel features you will be able to extract that exact piece of information you're looking for.

[IT Kobe]

Hello @Rohit Sodhi 

For Jira Cloud we have prepared app Friendly History for Jira . App allows you to get issue history log and user activity as a transparent, easy-to-use categories such as: Views, Assignee, Status, Worklogs, Comments, Links, Subtasks and Attachments.

Here example of Worklogs tab 

[Shridhar]

One another app based solution you can try:

Jira Assistant is one of the free (Open Source) alternate which not just helps generating worklog and sprint report but also supports time tracking with calendar and timer.

This is available as web version, browser extension, App for Jira Cloud, etc. and has lot more other useful features:

For web version: https://app.jiraassistant.com/

For Chrome extension: https://chrome.google.com/webstore/detail/jira-assistant/momjbjbjpbcbnepbgkkiaofkgimihbii?src=atls_ans

For Firefox extension: https://addons.mozilla.org/en-US/firefox/addon/jira-assistant/

For Edge: https://microsoftedge.microsoft.com/addons/detail/jira-assistant-worklog-/aoenpdbabcjnjbjpegeenodfknllmaoi?utm_source=atls_ans

Visit https://www.jiraassistant.com for more details and other install options.

Disclaimer: I am the developer of this extension.

[RVS_Support]

Hi @Rohit Sodhi  

Welcome to the community !!!

As others suggested, a mktplace app can help you to get this data. You can try out our add-on 

Worklogs Time Reports

Disclaimer : I am part of the app development team

[Wojciech Wardaszko]

Hi @Rohit Sodhi

Welcome to the community! As others have mentioned, this is not really supported in native Jira, so going with a timesheet app is your best choice.

I can assure you that our app, Clockwork Pro, can do what you need - show you and export the information about time tracked across the whole company against a single issue. 

It looks like this:

There are many other options and features that make time reporting an easy task that gives great versatility and insights.

I would like to encourage you to give the app a try - you can try it for free for at least 30 days with no strings attached, and if you need more time before making a decision, you can always submit a ticket with us and we'll see what can be done.

Cheers!