When a report is created using the Reports and Timesheets for Jira app, it is recommended to follow the instructions given on: How to ensure AIO reports accessibility if the creator is removed, to maintain the accessibility to this report in case the user is not available. If these instructions were not followed before the user is inactive, it is possible to change the ownership through the database (Data Center instance) following the instructions below:
\uD83D\uDCD8 Instructions
Step-by-step guide.
Info |
---|
|
Identify the user who owns the lost reports.
For this is necessary to analyze the content of the
app_user
table and look for theuser_key
that belongs to the user with a particular username. An SQL query example is below:Code Block SELECT "user_key" FROM "app_user" WHERE "lower_user_name" = '<username>';
With the
user_key
, after analyzing the content of theAO_6B9F04_AIO_USER
theowner_id
will be obtained. The SQL example is below:Code Block SELECT "ID" FROM "AO_6B9F04_AIO_USER" WHERE "ACCOUNT_ID" = '<user_key>';
...
List all reports owned by this user, the SQL example is the following:
Code Block SELECT "ID", "NAME", "OWNER_ID" FROM "AO_6B9F04_AIO_REPORT" WHERE "OWNER_ID" = '<owner id for that user>';
Update the owner for all the reports identified in the previous step. An example SQL query is below:
Code Block |
---|
UPDATE "AO_6B9F04_AIO_REPORT" SET "OWNER_ID" = '<new owner id>' WHERE "ID" = '<report id>'; |
Update email subscriptions for all the reports with updated owners:
Code Block |
---|
UPDATE "AO_6B9F04_AIO_SCHED_REP_RCPT" SET "RECIPIENT_ID" = '<new owner id>' WHERE "RECIPIENT_ID" = '<old owner id>'; |
Info | |
---|---|
Jira Legacy | |
server | System JIRA |
serverId | 8382ec9d-abb6-3a29-8d72-95b9a5732a63 | key | ART-172