Extract worklog into an excel using API

Question

Hello experts, can someone PLEASE help me with a way to extract the following information into an excel :

For e.g.,

Story XYZ

Task 1 - User A - 4h (logged)

Task 2 - User B - 2h (logged)

I need User A and User B logged hours each day in a spreadsheet. I have downloaded a trial version of JIRA on my PC. Here are some additional details:

Base URLhttp://localhost:8080System DateFriday, 04 Oct 2019System Time18:49:47 -0500Current Working DirectoryC:\Users\abc\Atlassian\JIRAJava Version1.8.0_202

Balu All · Answer

Thank you, I will check this out.

Earl McCutcheon · Answer

Hello Balu,

Natively Jira stores the worklog on the issue and does not put together a list of the information per user, so the sum of the worklog not a directly queryable data point meaning it must be retrieved across all the issues and calculated manually from the avaliable data set.

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 looks like it would fit your needs here, and would be a really good starting point:

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

Also, there are a lot of Time Tracking apps that can be added to the Jira instance that do extend this functionality, and provide various reporting options on user time tracking entries, and a list to review can be seen in the marketplace HERE, I recomend checking these out as an alternative method.

Regards,
Earl