File Size by container

[RajeshBalasunda]

We are currently on 8.0 M050.

Trying to figure out how to get the file size from the vaults in MB or GB for the products, libraries and projects. Does anyone have a sql or qml for that.If so can you please provide the same to me.

Regards,

Rajesh Balasundaram

[PreetiGupta]

Rajesh,

Here is sql for getting WTDocument file size in any product container. You can get same for EPMDocuments as well and do the UNION ALL in sql to have it a same query.

Thanks,
Preeti

[avillanueva]

Try modifying this:

SELECT P.IDA2A2 CONTEXT_ID, P.NAMECONTAINERINFO CONTEXT_NAME, COUNT(*)
TOTAL_PURGABLE_FILES, (SUM(A.FILESIZE)/1048576)
TOTAL_BLOAT_FILESIZE_IN_MB

FROM

( SELECT M.DOCUMENTNUMBER, M.IDA2A2 MASTERID, E1.IDA2A2 ITER_ID,
E1.ITERATIONIDA2ITERATIONINFO ITERATION, E1.BRANCHIDITERATIONINFO BRANCH

FROM PDMLINKPROD.EPMDOCUMENT E1, PDMLINKPROD.EPMDOCUMENTMASTER M

WHERE

E1.IDA3MASTERREFERENCE = M.IDA2A2) ITERATIONS,

PDMLINKPROD.EPMDOCUMENT E2, PDMLINKPROD.PDMLINKPRODUCT P,
APPLICATIONDATA A, HOLDERTOCONTENT H

WHERE

E2.IDA3MASTERREFERENCE = ITERATIONS.MASTERID AND

E2.LATESTITERATIONINFO = 1 AND

E2.BRANCHIDITERATIONINFO = ITERATIONS.BRANCH AND

E2.STATESTATE = 'RELEASED' AND

E2.IDA3CONTAINERREFERENCE = P.IDA2A2 AND

ITERATIONS.ITERATION < (E2.ITERATIONIDA2ITERATIONINFO - 1) AND

H.IDA3A5 = ITERATIONS.ITER_ID AND

H.IDA3B5 = A.IDA2A2

GROUP BY P.IDA2A2, P.NAMECONTAINERINFO



Its for identifying purgable items but if you remove the where clauses,
you can get all items. You can also modify it or union it for libraries
and projects.