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.
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...
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
(see also https://docs.atlassian.com/software/jira/docs/api/REST/8.13.6/#api/2/worklog-getIdsOfWorklogsDeletedSince)
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events