how to kwow size instance

system · May 25, 2012, 4:31pm

Hi,
I must delete some instance of reports in BOXI R2. There is some way to know how could I detect the bigger size instance to can delete them?
Many thanks and sorry for my english!

davidtuti (BOB member since 2012-02-16)

system · May 25, 2012, 5:05pm

Hi,

This utility from the BOB’s Download section might help you:

Marek Chladny (BOB member since 2003-11-27)

system · May 25, 2012, 5:22pm

Thanks,
These excel gives me an error. I put the error on the post of the tool.
There is some other way?
Thanks again,

davidtuti (BOB member since 2012-02-16)

system · June 1, 2012, 3:06pm

Something like this perhaps? Sorry I dont have much time, so this is just something to start you off with:

List of INPUT FRS objects in repository where size > 25MB ordered by last timestamp change date

select

si_name,

si_ID,

SI_OWNER,

SI_UPDATE_TS,

si_size,

SI_PROCESSINFO.si_size,

SI_PROCESSINFO.si_files

from

ci_infoobjects

where

SI_INSTANCE = 0 and

SI_PROCESSINFO.si_size > 26214400 or

si_size > 26214400

Order BY SI_SIZE DESC, SI_PROCESSINFO.si_size DESC

Orange (BOB member since 2006-09-18)