• Replies 8 replies
  • Subscribers 337 subscribers
  • Views 270 views
  • Users 0 members are here
Related

Transfer Scheduled Reports?

Tim Helmer
$organization

Hello,

One of my power users is leaving at the end of the month and owns a fair number of reports that will need to continue after their credentials are inactivated. Is it possible to transfer ownership of a report schedule to another user or does the report simply have to be rebuilt? 

Perhaps someone has a creative way for handling scheduled reports in the interest of business continuity when dealing with staff turn over!

Thanks!

Parents
  • Former Member
    Former Member $organization

    Hi Tim,

    Here's what I use to change owner schedules, I've used it a couple times with success. It's based off old forum posts and edited just a bit.

    declare @newowner char(8) = 'cbauer', --set as userid
    @usergroup char(8) = 'DEV', --UG_id
    @scheduleid int = 124 --id of schedule, visible in Tess

    update gooesoft_request
    set user_id = @newowner,
    ug_id = @usergroup
    where id=(select request_id from gooesoft_report_schedule where id=@scheduleid)

Reply
  • Former Member
    Former Member $organization

    Hi Tim,

    Here's what I use to change owner schedules, I've used it a couple times with success. It's based off old forum posts and edited just a bit.

    declare @newowner char(8) = 'cbauer', --set as userid
    @usergroup char(8) = 'DEV', --UG_id
    @scheduleid int = 124 --id of schedule, visible in Tess

    update gooesoft_request
    set user_id = @newowner,
    ug_id = @usergroup
    where id=(select request_id from gooesoft_report_schedule where id=@scheduleid)

Children
No Data