Extract worklog into an excel using API

[Balu All]

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 URL	http://localhost:8080
System Date	Friday, 04 Oct 2019
System Time	18:49:47 -0500
Current Working Directory	C:\Users\abc\Atlassian\JIRA
Java Version	1.8.0_202

[Earl McCutcheon]

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

[Balu All]

Thank you, I will check this out.