is there any way we can get the file size of Reports ( both private and public) present in the environment. We are having more then 100,000 + reports and around 1.5 TB of FRS data. we want to delete all the old data and needs to have file size of every reports present in the environment
Current Environment
Business Objects XIR3.1 with Sp3 and FP 3.6
Tomcat 5.5
Oracle 10G
The challenge is that you cannot easily relate the files themselves back to what’s in the repository. If you delete files through the OS, you’ll end up with orphaned records in the repository that don’t point to a file.
As suggested above, it would be a better idea to set limits on your folders and/or reports in the CMC. You can do this two ways - either by setting the number of days to keep reports or the maximum number of instances to keep.