Has anyone written a report to identify recipients of scheduled reports?

[MPritchard55]

We've created some tables from the Cognos 11 Audit package (c111_audit) and the content store (c111_content), but haven't cracked the nut on getting a report of all the people a report is scheduled to.  Anyone figured this out yet?  (No, I'm not going to buy a service or tool or engage anyone to figure it out.  Just trying to save a little time.)  Thanks.

[dougp]

In the content store database, look at CMOBJPROPS26.DELIVOPTIONS.  Good luck pulling that apart reliably.  You'll need to use a lot of SUBSTRING, CHARINDEX, and probably some XPATH.  And you'll probably encounter a lot of      Invalid length parameter passed to the LEFT or SUBSTRING function.      along the way.  I just dug up an ancient script I had used at one time.  Apparently it is now broken by new data that hits edge cases I hadn't considered at the time.

[MPritchard55]

Thank you.  I'll have a look there.  Do you mind sharing your broken script....just as a starting point?

[dougp]

https://github.com/dougpulse/Cognos

Use it at your own risk.  It is really just for my reference.  There's a lot of outdated and broken garbage in there.  I don't maintain all of it anymore.  Lately I just update content and push when today's issue was painful enough to remember to save.

[MPritchard55]

 :)  Thank you!  I appreciate it!!