Schedule properties

[dougp]

Does anyone here have a script that will provide schedule info in a bulk dump?  I'd like to avoid inspecting each of thousands of schedules one-at-a-time.

I realize the SDK may be useful for this.  I've been avoiding SDK so far.  Plus, we're a Microsoft/C# shop and IBM has abandoned C#.  (The dlls have not been updated in about 8 years.)  They provide documentation and support only for Java.

I don't see the REST API being very helpful.  I've been poking at it, but for content (reports and such) all I can seem to get is the object name.  I can't get any details, like report specs or schedule email recipients.

How about the Content Store db?  I know querying the Content Store database directly is not supported.  But I can find schedules and see when they are scheduled to run and who receives the emails.

But what I'm interested in today is inspecting the body of emails.  We recently migrated Cognos Analytics 11.2.4 from one machine to another.  I need to be able to identify and adjust every schedule that has in the body of it's email a reference to the old server name.

Any idea how I can do this? (...without purchasing 3rd party software like metamanager or motio products)