List of Failed Reports in CMC

[system]

Hi Everyone,

I know the CMS database is cryptic or unclear but does anyone have a sql to list out all the failed reports or any view code which converts all cryptic information to some readable information?

Thanks in advance
Kum

---

kum007 (BOB member since 2007-06-08)

[system]

Hi,

If you are talking about scheduled reports then this utility may help:

XIR2 scheduling instances viewer

Author: Rachidb Author notes: This macro generates information about instances finished/running/pending. It accepts a date range. If start date is omitted it shows instances statuses for a given day starting 12AM until time of run. End date is also option and will default to current date/time. Rows returned is limited to 64000 rows. But please be careful not to run for a big date range as it may overload your CMS. Platform: Excel 2003 Version: Initial release 1.0 Feel free to give feedback …

---

Marek Chladny (BOB member since 2003-11-27)

[SebastienGoiffon]

Information stored within the CMS are readable using CMS sdk. You can also have a look to the instance manager.

[system]

In Query Builder, for scheduled reports, SI_SCHEDULE_STATUS=3 means a scheduled report has failed, and SI_SCHEDULE_INFO.SI_OUTCOME gives the further information about the error.

---

newgun (BOB member since 2007-08-01)

[system]

Looking for something like this but i’m also looking for an email option. I want all list of failed reports in some excel spreasheet with detail description why they failed and want this file to be sent to an email address.

Thank you
Kum

---

kum007 (BOB member since 2007-06-08)

[system]

The only way to do that is to use SDK.

---

newgun (BOB member since 2007-08-01)