1 Reply Latest reply: Mar 31, 2009 10:25 AM by user6372894 RSS

    How to find the workspace name in the content schema

    user6372894
      Does any body know what table contains the Workspace name?

      I'm trying to create a query that identifies when the CONTENT QUOTA is almost full. I can not find the table where the Name of the Workspace is stored in this maize of tables.


      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;
        • 1. Re: How to find the workspace name in the content schema
          user6372894
          I found the information:


          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;