3 Replies Latest reply: Apr 1, 2009 2:10 PM by vitodc RSS

    Space / File Count

    vitodc
      Hello,

      I am looking to find out if there is any way to get the number of files store in Content Services as well as the total size of all the files.
      Does anybody have an example?

      Thanks in advance.
      VC
        • 1. Re: Space / File Count
          user6372894
          This might help. I'm trying to find where the name of the WorkSpace folder is located.


          column ALLOC_IN_MEG format 999,999,999.00
          column CONSUMED_IN_MEG format 999,999,999.00
          column USED_IN_MEG format 999,999,999.00


          select ID,
          ALLOCATEDSTORAGE / (1024 * 1024) as ALLOC_IN_MEG,
          CONSUMEDSTORAGE / (1024 * 1024) as CONSUMED_IN_MEG ,
          ( CONSUMEDSTORAGE / ALLOCATEDSTORAGE ) * 100 as USED_IN_MEG
          from content.ODM_CONTENTQUOTA order by 3 desc;
          • 2. Re: Space / File Count
            user6372894
            This will show the total size of the WS.


            set linesize 200
            column ALLOC_IN_MEG format 999,999,999
            column CONSUMED_IN_MEG format 999,999,999
            column USED_IN_MEG format 999,999,999
            column WORKSPACE_NAME format a50
            column WS_OWNER format a40

            select a.name as WORKSPACE_NAME,
            c.UNIQUENAME as WS_OWNER,
            b.ALLOCATEDSTORAGE / (1024 * 1024) as ALLOC_IN_MEG,
            b.CONSUMEDSTORAGE / (1024 * 1024) as CONSUMED_IN_MEG ,
            ( b.CONSUMEDSTORAGE / b.ALLOCATEDSTORAGE ) * 100 as USED_IN_MEG
            from content.ODM_PUBLICOBJECT a,
            content.ODM_CONTENTQUOTA b,
            content.ODM_DIRECTORYUSER c
            where a.id = b.ASSOCIATEDPUBLICOBJECT and
            c.id = a.LASTMODIFIER
            order by 5 desc;
            • 3. Re: Space / File Count
              vitodc
              Thank you that is great.
              It answered my question