Query to Calculate the size of only latest versions of the all items

Hi,

Is there a way to Calculate the size of only latest versions of the all items?

Intention is when I'll make copy of the production system then I'll only be keeping the latest version of the documents to save space.

Thanks.

Find more posts tagged with

Comments

Donna Nalls

Hi Baber,

I believe DTree VersionNum is the latest version number. Therefore, you can join dtree.versionnum with dversdata.version to calculate only the current versions:

select sum(b.datasize)
from dtree a, dversdata b
where a.dataid = b.docid
and a.versionnum = b.version

Hope that's correct. You'll have to do the conversion from kb to mb, of course.

Baber_Amin1

Thanks very much Donna.