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
