Not endorsed by or affiliated with SAP
Register
|
Login
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
Select a search
Explain These Choices...
--------------------
Recent Topics (All Forums)
Unanswered Posts
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:
All Posts
1 Day
7 Days
2 Weeks
1 Month
3 Months
6 Months
1 Year
Oldest First
Newest First
Register
or
Login
to Post
Forum Index
->
Enterprise Scheduling and Distribution
->
XI Scheduler
Page
1
of
1
All times are GMT - 5 Hours
Select a search
Explain These Choices...
--------------------
Recent Topics (All Forums)
Unanswered Posts
Jump to:
Select a forum
BusinessObjects Software
------------------------------------
General Discussion
SAP Analytics Cloud
Building Reports
• Legacy Crystal Products
• Crystal Reports
• Desktop Intelligence
• WebIntelligence 1.x/2.x
• WebIntelligence Version 6
• Web Intelligence
Semantic Layer / Universe Designer
Security and User Administration
• Supervisor (4.x - 6.x)
• CMC
Server Administration, Installation, Upgrades
• Web Intelligence 1.x/2.x Servers
• Web Intelligence 6.x Servers
• XI Server Discussion
Enterprise Scheduling and Distribution
• Broadcast Agent (BCA)
• XI Scheduler
Data Integrator
• DI: Installation, Administration, and Connectivities
• DI: Metadata Reports
• DI: Designer and Job Design
• DI: Performance and Tuning
• DI: Realtime and NRDM
• DI: Data Quality
• DI: Information Steward
• DI: SAP-specific ERP/BW
• DI: Text Analytics
• DI: Rapidmarts and Business Content
Other Products
• Performance Management
• Auditor
• Business Query
• Xcelsius - Crystal Dashboard Design
• Lumira / Visual Intelligence
• Live Office
• Explorer
SDK (VBA/ASP/JSP)
BOB's Downloads
• BOB's Uploads
Regional User Groups and Conferences
------------------------------------
User Groups and Conferences
ASUG BusinessObjects SIG
General Topics
------------------------------------
About BOB
• Forum FAQ
• BOB Projects
Off Topic
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