Hi,
Does anyone know if it is possible to transfer a scheduled report from one user to another? We have had someone get married and I've created a new log-in for her with her new name, but is there any way of updating all her scheduled reports so they have her new name? Or will she have to reschedule them with her new User Id?
Thanks,
Paul.
Hi Paul,
You can change the ownership of reports. I use the SQL all the time to do so, but I would still check in Test to make sure you have picked up the correct report etc.
If it is only specific reports then you can use this to find the reports you need to change based on the name of report etc.
Normal 0 false false false EN-GB X-NONE X-NONE MicrosoftInternetExplorer4
select top 10 * from gooesoft_report_schedule where name like ('%totals%')
You can then take the request_id from that and put it into this query, but as you want to change all the reports assigned to one user id to another you can just set the user_id replacing the old user_id with the new :
update gooesoft_request
set user_id = 'aedlich' -- New User ID
where user_id = 'cfflurjo' -- Old User ID
and id in (73991,73994,120625,120627)
Hope this helps,Caryl
That's ace. Thank you Caryl!