How to find schedules with email destination

How can I find out which reports are set to, or have ran with email as their destination? without going to each report/schedule.

What Audit Query would this be SI_Destination?


sapaa (BOB member since 2014-02-21)

Try this:

select * from ci_infoobjects where si_instance = 1 and si_scheduleinfo.si_destinations."1".si_progid = 'CrystalEnterprise.Smtp'

joepeters :us: (BOB member since 2002-08-29)