The used space in the assetstore will come close, but will also include extracted plain text, thumbnails, deletia, workspace, etc. 'du' may be including the sizes of the directories too.
Maybe something like this: SELECT sum(size_bytes) FROM bitstream JOIN bundle2bitstream USING (bitstream_id) JOIN item2bundle USING (bundle_id) JOIN item USING (item_id) WHERE bundle_id IN (SELECT bundle_id FROM bundle WHERE name = 'ORIGINAL') AND NOT withdrawn; But that could be broken by schema changes some day (for example, DSpace 2). -- Mark H. Wood, Lead System Programmer [email protected] Friends don't let friends publish revisable-form documents.
pgpDbBl9ioorY.pgp
Description: PGP signature
_______________________________________________ Dspace-general mailing list [email protected] http://mailman.mit.edu/mailman/listinfo/dspace-general
