COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: ITEvilWoman on 23 Jul 2015 03:46:03 AM

Title: Default Schedule Owner
Post by: ITEvilWoman on 23 Jul 2015 03:46:03 AM
Hi All,

Does anyone know if there is a way to set the default schedule owner to another AD user?

When we're settin up a schedule we need to set the owner to our service account rather than any of the developers.
Is there a way to do this automatically without having to login with the service account and change them (we have SSO switched on and it's an inconvenience  >:( )
Title: Re: Default Schedule Owner
Post by: sunosoft on 23 Jul 2015 04:04:17 AM
I believe login is the very simple and straightforward way, i am not sure whether this is the only way or not. But I think this is the only way.

Its not that much inconvinient even if you have SSO. Do you know password of your service  account ?

You can simple open the IE with service account on your machine and open cognos there. Use the below script to open the IE with different user credentials.

runas/user:domain\username"\"c:\program files\internet explorer\iexplore\" "

Copy above line in notepad, change username, domain and save it as .bat file. Run the file, it will prompt you password for user and new IE window will be opened where you can open cognos with desired user.
Title: Re: Default Schedule Owner
Post by: Michael75 on 23 Jul 2015 08:16:28 AM
I had to do a lot of testing in a SSO environment, impersonating other users. Initially I used the .bat technique as suggested by sunosoft, but it was a bit of a PITA. A colleague put me on to embedding the user coordinates in the URL. Here's an example:

http://domain/cognos8/cgi-bin/cognosisapi.dll?b_action=xts.run&m=portal%2fcc.xts&gohome=&CAMUsername=UserName&CAMPassword=YourPassword (http://domain/cognos8/cgi-bin/cognosisapi.dll?b_action=xts.run&m=portal%2fcc.xts&gohome=&CAMUsername=UserName&CAMPassword=YourPassword)

Just change domain/cognos8, UserName and YourPassword to your service account values.

HTH
Michael
Title: Re: Default Schedule Owner
Post by: Andrew Weiss on 23 Jul 2015 11:48:56 AM
ITEvilWoman,

MetaManager's Object Editor module has a user interface for setting schedules credentials and owners to different accounts. 

The technique is described here:
http://www.bspsoftware.com/kb/how-to-update-schedules-in-bulk/

And you can download a trial and try it for yourself here:
http://www.bspsoftware.com/products/metamanager/Download/

If you would like some more information on MetaManager please let me know.

Thanks,
-Andy