Hello
we have a large number of automated cognos reports via schedules to all our end users within the business.
this is administered by our administrator login.
is there any way to easily see what schedules a user is listed to receive, so they can be removed when a user becomes inactive?
at the moment we have to manually review schedule by schedule, and remove when identified. a lot of time schedules are missed, and end user emails u if they are still receiving reports.
Thanks
Shaun
I doubt there is any direct way to it.
The way around to it which I have done is,
1. Create User Groups under Security tab for each schedule
2. Then add each recipient to the that group
3. In the schedule, select the User group as recipient.
The benefit of adding group is that once the employee leaves, the AD would get de-activated and subsequently that person's mail id would not be visible in the group. It would come as #UNAVAILABLE.
Try it out and update :)
HI Nikhil
Thanks for the idea, this can work. like creating an outlook group, but something we can manage ourselves in cognos.
the consistency check can then remove the UNKNOWN users.
Cheers
Shaun
Correct :)
The consistency check can be done once a month. Any which ways, mail would not be sent to those who are displayed as UNAVAILABLE in the groups created :)
It is possible to query the Content Store database for this info. The email address and Cognos accounts that receive emails can be seen in the DELIVOPTIONS column on the CMOBJPROPS26 table.
Of course, hacking the Content Store is not supported by IBM. They prefer you use the Cognos SDK.