If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Administering Schedules - Receipient List

Started by keating101, 25 Feb 2019 03:59:17 AM

Previous topic - Next topic

keating101

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


Nikhil Shenoy

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 :)

keating101

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

Nikhil Shenoy

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 :)

dougp

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.