How to find schedules with email destination

Not endorsed by or affiliated with SAP	Register \| Login
Not endorsed by or affiliated with SAP	Want to sponsor BOB? (Opens a new window)
Index \| About	Sponsors \| Contact Us \| Calendar \| FAQ \| Rules and Guidelines \| Privacy Policy \| Search

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

How to find schedules with email destination

Search this topic... | Search XI Scheduler... | Search Box

Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> XI Scheduler

Author Message

sapaa
Principal Member

Joined: 21 Feb 2014

Posts: 219

Posted: Tue May 07, 2019 10:26 am
Post subject: 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?

Back to top

joepeters
Forum Fanatic

Joined: 29 Aug 2002

Posts: 6634
Location: Connecticut, USA

Posted: Wed May 08, 2019 7:46 am
Post subject: Re: How to find schedules with email destination

Try this:

Code:

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

Back to top

Display posts from previous:

Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> XI Scheduler

Page 1 of 1 All times are GMT - 5 Hours

Jump to:

Index | About | FAQ | RAG | Privacy | Search | Register | Login
Get community updates via Twitter: Follow @BOB_Board

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0301 seconds using 17 queries. (SQL 0.0031 Parse 0.0009 Other 0.0262)
CCBot/2.0 (https://commoncrawl.org/faq/)

Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com