Cognos Scheduled report e-mail changes

[ghostraider]

Hello All, my client's email domain name has changed and we would like update all the e-mail addresses in the scheduled reports with the new domain names. I have identified NC_MESSAGELINE_ELEMENT table in content store which contains the email ids and ran a script to update the domain name change, however they don't seem to reflect in the Cognos portal. We still have the old e-mail ids. Please let me know if there is a parent table linked to the NC_MESSAGELINE_ELEMENT table or if there are other ideas to do a bulk update of this change. Thank you for your time.

[Grim]

What is your authentication source? If the email address is stored there it should have updated based on that. You may have to renew credentials to force it though.

[ghostraider]

Hi Grim, thanks for the response. We are using Series 7 authentication. Our Cognos BI version is 8.1.2. E-mail addresses are not stored in our authentication server. Please let me know of any other ideas. Thank you

[Grim]

Series 7, then that would mean that each user's profile will have their address added manually under the My Preferences>Personal tab...yes?
You may have to ping IBM Cognos Support and have them collaborate with the SDK support team to see if you can program a solution using the SDK since you want this to be a global change.

I tried to find something already out there and this is the closest thing I could find. You might be able to use this code as a base to do the above.
http://www-01.ibm.com/support/docview.wss?uid=swg21341648

Hope that helps.