COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: squish88 on 21 Oct 2016 01:54:23 PM

Title: Bulk changing of a scheduled report's owner
Post by: squish88 on 21 Oct 2016 01:54:23 PM
Hi all,

   Running 10.2.1 FP11.   I have/had boneheaded users who scheduled reports for our external customers....  but did so under their own credentials rather than using a generic user.  We recently had a round of layoffs...  Most of those boneheaded users were caught up in the wave, and I ended up w/the admin responsibilities.   So, as a result, I have a bunch of schedules that need a new (preferably generic) owner.   If at all possible, we'd like to be able to just re-assign them without having to go through one by one, and changing the owner by hand.   Does anyone know of a way to do this in bulk??   Like, is there a quick SQL update kinda statement I could run in the content store or whatever??   Just curious.

Thanks in advance for the help!!
Title: Re: Bulk changing of a scheduled report's owner
Post by: BigChris on 25 Oct 2016 02:04:50 AM
I think there are tools that can do that sort of thing, but you might have to pay for them. Take a look at Motio PI Pro for example.