BO4 - Audit of scheduled reports which didn't start

[former_member272336]

Hi,

On occasion a scheduled report may not run e.g. if the job server overloaded and we have needed to restart the job servers.

Whilst we have a report of what is scheduled and reports if runs or not, is it possible to have a report which lists what due to have ran but not actually ran?

Thanks

[Former Member · Accepted solution]

Hi Philip,

Please search on instance management.

I think this is what you need.

Regards,

Ashvin

[former_member272336 · Accepted solution]

Hi,

Thanks for advice.

Whilst we can go into Instance Manager and look at pending reports, is it possible to view this data via the audit universe.

We want to have a report which lists what is scheduled and when and then we could query compare results of this to our audit report which lists what has ran and succesful and ran and failed and what is Pending.

Thanks

[Former Member · Accepted solution]

Philip,

To query the database, you have to go through the CMS via the SDK.

The main roadblock is that the CMS tables are all encrypted and not a lot of useful info is stored as plain text in the tables.  The CMS uses a binary field to house most of the data and only the CMS service itself can decrypt that data.

Please refer to the discussion below for more information:

Regards,

Ashvin

[former_member272336 · Accepted solution]

Thanks for information.

Is there no easy other way to report on what is set up as scheduled without using SDK - not being a java programmer.

[Former Member · Accepted solution]

I am not sure but do not think so.

regards,

Ashvin

[former_member272336 · Accepted solution]

Thanks for update.

[former_member272336 · Accepted solution]

Does anybody have such SDK which could be used for such circumstances.

[former_member185603 · Accepted solution]

Post it in SDK forum to get faster response.

[former_member272336 · Accepted solution]

Hi,

Do you have the link to the sdk forum?

Thanks

[former_member272336 · Accepted solution]

Thanks