BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

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  Previous TopicPrint TopicNext Topic
Author Message
sapaa
Principal Member
Principal Member



Joined: 21 Feb 2014

Posts: 217



PostPosted: 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
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6563
Location: Connecticut, USA


flag
PostPosted: 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  Previous TopicPrint TopicNext Topic
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:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0268 seconds using 17 queries. (SQL 0.0020 Parse 0.0008 Other 0.0240)
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 Moments of Light Logo