
General Notice: BOB is going to retire...please see details here. General Notice: No events within the next 45 days. |
Author |
Message |
bob2210 Forum Associate


Joined: 23 Sep 2010
         Posts: 679

|
Posted: 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 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


Joined: 30 Jun 2015
    Posts: 70 Location: Czech Republic / Austria

|
Posted: 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


Joined: 02 Nov 2018
 Posts: 1

|
Posted: 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 |
|
 |
|
|