Jira Server - TEMPO workglog deleted

Question

Hi guys,

I'm using jira server and we have the tempo plugin.

How do we find a log or something about a deleted worklog? where should I look? Are tempo tables tied up to the jira tables?

Susanne Götz _Tempo_ · Answer

Hi @Albert Manuel

As far as I am aware, it is only possible to get the ID of a worklog that has been deleted. You could then user this information with an earlier backup of your database to find exact information. 
Atlassian might be able to give you more detailed information or information if there are other options.

The REST API to retrieve id's of deleted worklogs is 
GET /rest/api/2/worklog/deleted
(see also https://docs.atlassian.com/software/jira/docs/api/REST/8.13.6/#api/2/worklog-getIdsOfWorklogsDeletedSince)

Best regards,
Susanne

Albert Manuel · Answer

Hi @Susanne Götz _Tempo_

Unfortunately, we have lots of hours logged over the years, The History or Activity tabs are loading 10 minutes and after that, it crashes.

Is there any SQL query or something else we could use to see the details about a deleted worklog? We have the name of that person...and a period...

Thanks

Susanne Götz _Tempo_ · Answer

Hi @Albert Manuel

On Server, all worklogs created via Tempo are stored in the JIRA worklog table.

When a worklog is deleted, the information about the change to the "Time spent" field is shown in the "History" tab and in the "Activity" tab of the Issue the work was logged on.

Best regards,
Susanne Götz
Tempo team