Solved! Go to Solution.
For server tasks, you only have to edit and save them, then ownership would change to you. You don't need to actually make any changes. If there are a large number of them, we can provide a script to change them through sql. That would require finding the user id of the account in question and the one you want to change it to. Once you get that script, you could do the same for the orionquerymt table to change ownership. I don't see where the reports are owned by anyone, just the queries used to run the reports. If the report is not in the shared groups where it is accessible, then you might need to log in as that user and move any private queries and reports.
Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?
For server tasks, you only have to edit and save them, then ownership would change to you. You don't need to actually make any changes. If there are a large number of them, we can provide a script to change them through sql. That would require finding the user id of the account in question and the one you want to change it to. Once you get that script, you could do the same for the orionquerymt table to change ownership. I don't see where the reports are owned by anyone, just the queries used to run the reports. If the report is not in the shared groups where it is accessible, then you might need to log in as that user and move any private queries and reports.
Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?
Hi mate,
would it be possible to provide me with the script?
We are from time to time facing the same problem.
Sent you private message.
Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?