Jira Server - TEMPO workglog deleted

[Albert Manuel]

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_]

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

[Albert Manuel]

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_]

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