Hi Susan, To get an estimation of total file size and count, you can do a simple directory listing of dspace/assetstore. In a few minutes you get the answers, with no pain at all. It is assumed you only want to count content files stored locally in dspace. The count may contain some withdrawn/pending items. For our case, the result is accurate enough for most statistical uses.
Allen. HKU Hub Administrator, http://hub.hku.hk Susan Teague Rector wrote: > Hi all, > > I just wanted to run this past the Dspace experts - I'm determining how > many files and the total size of files ingested into our Dspace > installation last year. > Here's the query I'm running. > > Since I don't look at the Dspace database on a daily basis, I needed a > sanity check from you folks - Is this is the best way to get at this data? > > Thanks in advance, > > Susan Teague Rector > Web Applications Manager > VCU Libraries > > > select id.item_id, id.date_issued, ib.bundle_id, > b.bitstream_id, b.name, b.size_bytes, b.source > from itemsbydate id inner join > item2bundle ib on id.item_id = ib.item_id > inner join bundle2bitstream bb on ib.bundle_id = bb.bundle_id > inner join bitstream b on bb.bitstream_id = b.bitstream_id > where name <> 'license.txt' > and (source not like '%Written by Media%') or source is null > order by id.date_issued, ib.bundle_id; > > ------------------------------------------------------------------------------ > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech > ------------------------------------------------------------------------------ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
