This discussion is archived
1 Reply Latest reply: Nov 20, 2009 7:53 AM by user17591 RSS

Query to List members(users) of a WorkSpace

user17591 Newbie
Currently Being Moderated
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
    user17591 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points