A report of all the instances in the file repository

building reports webintelligence
1

I am trying to create a report that will list out every file in the repository along with its size.

I understand that Query Builder will only return 1000 but I would like everything so I attempting to write a vbscript that will handle this request.

Is anyone familiar w/ this type of scenario?

I’ve found some helpful hints so far but nothing solid.

Thanks in advance.

pburns13 (BOB member since 2009-04-16)

2

I am aware of a similar requirement that was solved using SDK. However that does require some significant coding effort.

ramaks (BOB member since 2009-03-31)

3

You can use the “top ###” qualifier in the QueryBuilder query to force it to return any number of records, it just defaults to 1000. I used the following query to get a list of all repository objects that had files associated with them. The actual file repository location(s) are shown in the “si_files” result set.

SELECT top 64000 si_name, si_kind, si_size, si_files, si_id, si_instance, si_owner, si_creation_time FROM CI_INFOOBJECTS WHERE SI_FILES > 0 order by si_creation_time

gacjm68 (BOB member since 2007-11-16)