Reports Purge Tool

general discussion
1

Hi all…

Does BO come with a purge or batch delete tool to delete a set of report instances stored on the app server over a period of time?

Say 2 years worth of reports needs to be deleted, and i beleive deleting them from the frsout would leave their links cmc.

If thats the case, wouldnt Infoview still map these files? and throw an error when accessed?

So is there a tool, excep the admin, that would let us purge these file in a more “Enterprise Friendly” Manner?

Thansk alot guys…

zignaltrack (BOB member since 2008-09-29)

2

Indeed you will have to cope with side effects if you delete instances within OFRS. Why don’t you put instance limits?

3

Hi…

am relatively new to BO. I am not sure where to configure it for…

The main reason for this is that this limit has not been set (as i havent been informed about it) and that the server spaces are already full… so, theres a need to purge reports older than 6 months… so just wanted to know if there was a way we could do it… say delete all report instances between this time period.

Cheers :slight_smile:

zignaltrack (BOB member since 2008-09-29)

4

As Sebastian mentioned - going forward you can implement instance limits in the CMC to prevent future buildup of instances.

For your current cleanup, it sounds to me like the only mechanized approach would be to use the SDK to write a small script that identifies the instances you want to delete (by date), then iterate through and delete them.

crystal01 :us: (BOB member since 2006-08-30)

5

I have set the limit to 90 days for one of our groups. What actually removes the instances and when? Is this automatic or do I have to trigger something?

Greenlee :us: (BOB member since 2005-11-29)

6

It’s automatic, but the 90-day rule will only be in effect for reports created going forward. All old instances that already exist will need to be cleaned up manually.

crystal01 :us: (BOB member since 2006-08-30)

7

I am looking at this same issue and wondering if you or anyone already created a process through SDK.
I am not an SDK guru or actually user so any help is greatly appreciated.

thanks

di652 (BOB member since 2005-02-24)

8

Hi,
what I can think is a process with 2 steps :
1 - Run a Query on Query Builder that brings the id and end_date of the schedules
2 - Use the script attached to delete the instances, where IdDoc is the scheduled document
Regards,
Rogerio
delinstances.txt (2.0 KB)

rgoulart :brazil: (BOB member since 2011-08-21)

9

But does that just delete ‘instances’… I am looking to purge\delete reports in folders

di652 (BOB member since 2005-02-24)

10

Sorry,
I misunderstood your question.
To purge data from reports ( is it ?)
purgereports.txt

Regards,

Rogerio
purgereports.txt (2.0 KB)

rgoulart :brazil: (BOB member since 2011-08-21)

11

yes purging files that may have passed their 100 day value.

This script will work for 4.0 I am assuming.

di652 (BOB member since 2005-02-24)

12

Yes,
at least from SP6 .
Maybe the url has changed , have to check it
Regards,
Rogerio

rgoulart :brazil: (BOB member since 2011-08-21)

13

Thanks rgoulart

di652 (BOB member since 2005-02-24)

14

Did it work ?
Cheers,
Rogerio

rgoulart :brazil: (BOB member since 2011-08-21)

15

I will let you know… have a few more released to get out before I can tackle this one.

I am thinking; maybe Monday or Wednesday next week. In either case will let you know the result and if I needed to modify anything to work with my 4.0 environment.
:slight_smile: thanks again, regardless the outcome :slight_smile:

di652 (BOB member since 2005-02-24)