Technote (troubleshooting)
Problem(Abstract)
Is there a way to monitor the size of the assets added the Collaboration and Deployment Services repository?
Resolving the problem
This select statement returns the object name along with the total size of all versions of that object.
SELECT objname,
SUM([CONTENTLENGTH])
FROM [CADS50].[dbo].[SPSSCMOR_RELATIONSHIP] RELA,
[CADS50].[dbo].[SPSSCMOR__FILEVERSION] FILEVER,
[CADS50].[dbo].[SPSSCMOR_NAMEDOBJECT] NAMED
where RELA.srcobjid = FILEVER.objid
and RELA.tgtobjid = NAMED.objid
GROUP BY objname
order by 1
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.