1 Reply Latest reply: Nov 20, 2009 9:53 AM by user6372894 RSS

    Query to List members(users) of a WorkSpace

    user6372894
      Has anyone created a sql query that shows the members (users) of a WorkSpace ?

      I have a business requirement to show which WorkSpaces is assigned to a specific user.
        • 1. Re: Query to List members(users) of a WorkSpace
          user6372894
          I found the soluction to my Problem.



          Assumption: Connect to the Content DB Database or the MRDB



          01). Find the user exact name:


               select unique MEMBERDISPLAYNAME from cwsys.cw$workspace_members where upper(MEMBERDISPLAYNAME) like '%SMITH%';


               Output
               ===============

               MEMBERDISPLAYNAME
               ---------------------
               John SMith



          02). Extract the Workspaces they beling to



               set linesize 9999
               set pagesize 200
               column MEMBERDISPLAYNAME format a60
               column WORKSPACENAME format a60

               select b.MEMBERDISPLAYNAME
               from CWSYS.CW_WORKSPACES_TABLE a,
                    cwsys.cw$workspace_members b
               where a.WORKSPACEID = b.WORKSPACEID and
          b.MEMBERDISPLAYNAME = 'John SMith'
               order by 1