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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

How to identify scheduled reports using Query Builder


 
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
bob2210
Forum Associate
Forum Associate



Joined: 23 Sep 2010

Posts: 679



PostPosted: Thu Aug 17, 2017 9:07 am 
Post subject: How to identify scheduled reports using Query Builder

Hello,

I have hundreds of reports among them I need to identify which one are scheduled ones

I pulled out SI_INSTANCE of two reports - one scheduled and another unscheduled , for both SI_INSTANCE value is coming as 'False' , I am confused icon_rolleyes.gif how to differentiate between two reports

I want to do this through Query Builder, is there way to identify?
Back to top
tom_kar
Senior Member
Senior Member



Joined: 30 Jun 2015

Posts: 70
Location: Czech Republic / Austria


flag
PostPosted: Tue Aug 22, 2017 3:38 am 
Post subject: Re: How to identify scheduled reports using Query Builder

Hi,
yes because the field SI_INSTANCE reffers if the object is an instance or not.
the report itself is not.

for reports ther is a SI_children and si_haschildren to know if there migh be some childern/instances but you cant know which.

this query should you return the scheduled instances:
select * from CI_INFOOBJECTS where SI_RECURRING=1 and SI_SCHEDULE_STATUS=9

you should query the instances and get know what are the parrents.. but I never know if the query builder is able to process more complex queries - I always used a Java SDK to know more..

BR Tomas
Back to top
tweety2000
Forum Member
Forum Member



Joined: 02 Nov 2018

Posts: 1



PostPosted: Fri Nov 02, 2018 12:50 am 
Post subject: Re: How to identify scheduled reports using Query Builder

I find the best query to run in QueryBuilder is:
SELECT
SI_NAME, SI_SCHEDULEINFO.SI_SUBMITTER,
SI_PARENTID, SI_KIND, SI_NEXTRUNTIME,
SI_PROCESSINFO.SI_DBNEEDLOGON,
SI_PROCESSINFO.SI_LOGON_INFO,
SI_PROCESSINFO.SI_PROMPTS,
SI_PROCESSINFO.SI_RECORD_FORMULA,
SI_FORMAT_INFO, SI_DEPENDENCIES,
SI_SCHEDULEINFO.SI_DESTINATION
FROM
CI_INFOOBJECTS
WHERE
SI_RECURRING = 1

add the following if you only want instances scheduled to email addresses:
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.0291 seconds using 17 queries. (SQL 0.0024 Parse 0.0009 Other 0.0259)
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