on 08-04-2017 12:41 PM
Hello Everyone,
We used to run recurring report schedules daily/weekly which is delivering to hundreds of users. Accidentally 3 recurring schedules got deleted and we don't have Audit enabled in the environment since it is used only for distribution.The issue here we need to reschedule the 3 recurring instances.Is there any way to get the recurring schedule configurations(like to which group its being delivered,format etc..)of the deleted recurring schedules.
Thanks in Advance,
Manhoj
Does the report itself got deleted or only the instance?
If it is only recurring instance, You can always get the schedule information from either success/failure instance from the history of the report?
If not you need to rely on your BIAR backup, email that is already distributed,etc..
Thanks
Mani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mani,
First of all Thanks you for all your blogs,it's has been very very helpful.
Only the recurring schedule got deleted.
From the Success/Failed instances in the history, only the details of the user(User's mail id) is available because that particular instance corresponds to that particular user only.But our requirement is to get the groups configured in that recurring instance for rescheduling back to original.
Thanks in advance,
Manhoj
For me, I will try to run the query to quickly get theedetail
SELECT SI_ID, SI_NAME, SI_SCHEDULEINFO.SI_DESTINATIONS FROM CI_INFOOBJECTS WHERE SI_RUNNABLE_OBJECT = 1 and SI_D = Report SI_ID
Alternatively you can also run this Scheduler utility from here.
http://www.forumtopics.com/busobj/viewtopic.php?t=231832
Hi,
You need to have an instance in the history. Only then you can get the schedule configuration by clicking on the status - Success/Failed etc.
And what version of BO are you using? Just in case if you are on 4.2 you can check under CMC-> Recycle bin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your response.
The recurring schedules are distributing to multiple outlook groups containing hundreds of users.So the success instance corresponds to a particular user(each successful instance created for every member in the group) and we are not able to get the configured group those users belong to.
have you checked in the successful instance history.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.