PDMLink: Report Manager for link user/group

Just import this report:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE qml SYSTEM "/wt/query/qml/qml.dtd">
<qml>
 <statement>
 <query>
 <select>
 <object alias="wt.org.MembershipLink" heading="Идентификатор" propertyName="roleBObject">
 <property name="roleBObject"/>
 </object>
 <column alias="User or Group (wt.org.WTPrincipal)" heading="Name" propertyName="name" type="java.lang.String">
 name
 </column>
 </select>
 <from>
 <table alias="wt.org.MembershipLink">
 wt.org.MembershipLink
 </table>
 <table alias="User or Group (wt.org.WTPrincipal)">
 wt.org.WTPrincipal
 </table>
 </from>
 <orderBy>
 <orderByItem>
 <columnTarget heading="Name"/>
 </orderByItem>
 </orderBy>
 <referenceJoin>
 <join name="roleAObjectRef">
 <aliasTarget alias="wt.org.MembershipLink"/>
 <aliasTarget alias="User or Group (wt.org.WTPrincipal)"/>
 </join>
 </referenceJoin>
 </query>
 </statement>
</qml>

According to the PTC knowlege base this is not possible.

See https://www.ptc.com/appserver/cs/view/solution.jsp?n=CS22167

But I had a simular problem. I needed to get a list of the groups and its members.

Since the User-Group Information is stored win windchillDS I tried a LDAP search.

Maybe this helps you further.Here is an example (groupname & users are in bold):

C:\ptc\Windchill_10.0\Windchill>ldapsearch -h vm-net297p -p 389 -D cn=Manager -w <LDAP_ADMIN_PASSWORD> -b o=ptc -z 30 "(objectclass=

groupOfUniqueNames)" uniqueMember

cn=Administrators,ou=people,cn=AdministrativeLdap,cn=Windchill_10.0,o=ptc

uniqueMember=uid=wcadmin,ou=people,cn=AdministrativeLdap,cn=Windchill_10.0,o=ptc

...

cn=CAD-User,cn=Public,o=NET,ou=people,cn=AdministrativeLdap,cn=Windchill_10.0,o=ptc

uniqueMember=uid=asterix,ou=people,cn=AdministrativeLdap,cn=Windchill_10.0,o=ptc

uniqueMember=uid=obelix,ou=people,cn=AdministrativeLdap,cn=Windchill_10.0,o=ptc

cn=Gallier,cn=Public,o=NET,ou=people,cn=AdministrativeLdap,cn=Windchill_10.0,o=ptc

uniqueMember=uid=asterix,ou=people,cn=AdministrativeLdap,cn=Windchill_10.0,o=ptc

uniqueMember=uid=obelix,ou=people,cn=AdministrativeLdap,cn=Windchill_10.0,o=ptc

ldapsearch help:

C:\ptc\Windchill_10.0\Windchill>ldapsearch

usage: ldapsearch [options] filter [attributes...]

where:

filter RFC-1558 compliant LDAP search filter

attributes whitespace-separated list of attributes to retrieve

(if no attribute list is given, all are retrieved)

options:

-n show what would be done but don't actually search

-v run in verbose mode (diagnostics to standard output)

-t write values to files in /tmp

-u include User Friendly entry names in the output

-A retrieve attribute names only (no values)

-B do not suppress printing of non-ASCII values

-L print entries in LDIF format (-B is implied)

-X print entries in XML format

-R do not automatically follow referrals

-d level set LDAP debugging level to `level'

-F sep print `sep' instead of `=' between attribute names and values

-S attr sort the results by attribute `attr'

-f file perform sequence of searches listed in `file'

-b basedn base dn for search

-s scope one of base, one, or sub (search scope)

-a deref one of never, always, search, or find (alias dereferencing)

-l time lim time limit (in seconds) for search

-z size lim size limit (in entries) for search

-D binddn bind dn

-w passwd bind passwd (for simple authentication)

-h host ldap server

-p port port on ldap server

-W Wallet Wallet location

-P Wpasswd Wallet Password

-U SSLAuth SSL Authentication Mode

-q prompt for simple bind password

-Q prompt for SSL wallet password

-E charset Character Set Encoding

-Z [enable native authentication]

-M send ManageDsaIT control to server

-G send RequiredAttribute control to server

-C send connectBy control to server

-T [-]sort_attr send serverSort control to server

-j page_size send Paging control to server

C:\ptc\Windchill_10.0\Windchill>