Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating users spent time from the issues export

Ahmed Mounir
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 6, 2022

The all-fields excel export of the issues contains a column labeled "Log Work". The column includes four components separated by semicolons. What is the definition of the third component that starts with "ug:"? Can it be used to get the name of the user who logged the time?

Following an example of the export data:

First session;06/Jul/22 12:50 PM;ug:3dd49f4e-62b7-4d4e-a7e2-a87016ad431e;3600

1 answer

0 votes
Deepak Rai
Community Champion
July 6, 2022

Third component in this export is user id which is generated in jira and time spent is last one that is 3600

Ahmed Mounir
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 19, 2022

Thank you Deepak. How can get the user name using this user id.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events