How do I use the AUDITING reports in SAP CMC to identify CR that are scheduled?

[former_member597784]

I am trying to identify any reports in SAP CMC that have an Event Type of Scheduled. I have found other Event Types but not scheduled. Any help would be appriciated.

[former_member597784]

By your answer I cannot get this data using auditing reports out of the objects -Events folder.Thank you and I will go the route you indicated.

Glen

[DellSC]

You have to query the CMS database using QueryBuilder, one of the SDKs, or, if you're in 4.2 SP3 or newer, the "BI on BI" universe that connects to the CMS database to look for SI_INSTANCE = 1 and SI_SCHEDULE_STATUS = 9 (pending) or 8 (paused). However, you can't look at the schedule object for SI_KIND = 'Crystal' because the schedule may be exporting to some other type of document. So, you have to look at the SI_KIND value for the schedule's parent object to determine whether it's a Crystal report or something else.

-Dell

[former_member230921]

http://www.forumtopics.com/busobj/viewtopic.php?p=1048949