Find Modified Recurring Schedules/New Schedules

[Former Member]

Hello Experts,

Is there any way to find out if any new report was scheduled or if any existing recurring scheduled report was modified?

For example: I need to find out if any of the existing recurring scheduled was modified or if any new recurring scheduled is created?

If I have to write a query on query builder, how would I do it on XIR 3.1 SP4

Thanks,

Izak

[Former Member · Accepted solution]

I think I figured out the query...This is the close I got and I verified the result sets and they look good

SELECT

SI_NAME,

SI_OWNER,

SI_CREATION_TIME,

SI_SCHEDULEINFO.SI_DESTINATIONS

FROM

CI_INFOOBJECTS

WHERE

SI_RUNNABLE_OBJECT = 1

AND SI_PROGID_MACHINE = 'CrystalEnterprise.Webi'

AND ((SI_SCHEDULE_STATUS = 9 AND SI_UISTATUS = 12 ) OR (SI_SCHEDULE_STATUS = 8 AND SI_UISTATUS=8))

AND SI_CREATION_TIME BETWEEN '2013.11.25' AND '2013.12.02'

This query is basically pulling the WEBI instance details which are scheduled to emails only.

I noticed when a crystal report is scheduled to email, it uses different si_progid_machine and if a report is scheduled to default, then it has SI_PROGID alone and not SI_PROGID_MACHINE. This si_progid_machine appears only when it is being scheduled to emails. The si_scheduled_status and uistatus has to do something with the schedule being sent in webi or xcel or pdf format and their status. I may be wrong, but these were my observations.

Thanks,

Izak

[former_member182521]

Can we try this Select * from CI_INFOOBJECTS where si_kind='WebI' and si_recurring=1 You can always differentiate the schedules based on their creation and modified time. If creation time is same as modified in most of the cases its a new recurring schedule and if modified time is different it would be modified schedule.

[Former Member]

Hi Mani,

Thanks for the reply

How should I write the where clause with SI_UPDATE_TS between two dates?

I tried different formats but so far I'm not successful.

Please help.

Thanks in advance

[former_member182521]

Have a look here especially working with dates part http://scn.sap.com/community/bi-platform/blog/2013/06/12/businessobjects-query-builder-best-practice...

[Former Member]

Query builder is available in BOXI 3.1 and the link will be http://Servername:8080/AdminTools

However I am not sure on the query that will get you the reports with modified instance ; may be some other SCN members will be of more help with that query you will beed to run....

I will suggest to go through the query builder blog by Mani if you are new in query builder

http://scn.sap.com/community/bi-platform/blog/2013/07/26/businessobjects-query-builder-whats-new-in-...

[Former Member]

When you run the query in query builder similar like select * from ci_infoobjects where si_kind='webi' and si_instance=1, you will see "SI_UPDATE_TS" field will tell you what date the schedule is modified.

[Former Member]

Thanks Durgamadhab for the information.

[Former Member]

Hi Jawahar,

How should be the where clause when I'm looking for information between two dates?

I mean I want to find out the updated instance between last monday and this monday.

I tried

SI_UPDATE_TS BETWEEN ( 11/25/2013; 12/2/2013)

and also tried

SI_UPDATE_TS > 11/25/2013 AND SI_UPDATE_TS < 12/2/2013

I tried with single quotes as well as double quotes but I'm not able to get any data...

Please suggest

Thanks

[Former Member]

Try in this format. SI_UPDATE_TS>=’2011.01.01.16.00.00′