How many historical instances in a report?

security CMC
1

Hi there,

I am fast running out of disk space in my Output repository.

A quick overview of my system:

Business Objects XI 3.1

of reports: Approx 7000

of Schedules: Approx 9500

of historical instances: In excess of 100,000

Are there any tools available that will allow me to identify how many instances each report is holding in the history?

This will be extremely useful in allowing me to target instances to delete, and instances where I can redefine limits in terms of how many reports/how long instances are retained for.

Appreciate any assistance you can provide!

Many thanks,

Corinne

creeno (BOB member since 2011-04-05)

2

You may need SDK for detail analysis of your report kinds, size and other details.

or

Use this query in Query Builder to get brief info:

SELECT SI_ID, SI_NAME 
FROM CI_INFOOBJECTS
WHERE SI_INSTANCE > 1 AND SI_KIND='CrystalReport'

Change the SI_KIND to WebI or FullClient etc… to get the details for other kind of reports in your environment.

BO_Chief :us: (BOB member since 2004-06-06)

3

Hi there,

Many thanks for your reply!

I entered the SQL that you suggested into the query builder but got the following response:

Number of InfoObject(s) returned: 0

Which seems a little odd because there should be thousands!!

Any further ideas please?

Thank you!!

creeno (BOB member since 2011-04-05)

4

Change the criteria to the following:

WHERE SI_INSTANCE = 1 AND SI_KIND='CrystalReport'

When the value of SI_INSTANCE=1 is set, It will only bring instances.

BO_Chief :us: (BOB member since 2004-06-06)

5

This query was for Crystal documents. You can try it using Deski and Webi documents as well …

You can also setup instances limits on your folder allwing you to avoid those kind of side effects …

6

Thanks BO_Chief.

This has given me a rather extensive list of instances, but I guess I need something that consolidates it for me.

In Crystal 10, I used to be able to go to the Objects list, and it would give me a list of:

Report Name
Report Folder

of Instances

Oh how I miss this functionality in BusinessObjects XI :frowning:

creeno (BOB member since 2011-04-05)

7

Check the Download Section of this forum…

You may find a utility that might help you.

BO_Chief :us: (BOB member since 2004-06-06)