How to monitor for the size of the assets in the C&DS repository?

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:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Collaboration and Deployment Services
Content Repository

Software version:

5.0

Operating system(s):

Platform Independent

Reference #:

1616393

Modified date:

2013-01-22

Translate my page

Machine Translation

Content navigation