WTGroup To Memebr Relation From windchill database table

[KU_10670946]

Hi , I Am trying to get all the members related to each WTGroup  <Snap Below> from MembershipLink table but no luck.
Does anyone has any idea how to get this information from windchill database or this information is coming from LDAP?
I need only  Group "CAT Material Planner - Huntersville" has user "KER1232"

As far as i tried to JOIN WTGroup , MembershipLink, WTUsers

[HelesicPetr]

Hi @KU_10670946 

Unfortunately the trouble is that the information can be sored in the LDAP not in the database. So you can not be success if so.

If the groups are managed in Windchill then there can be the link you are looking for. 

try this select.

If you are in Windchill 12 + the groups are managed in Windchill. I tried it now

select GR.name,users.name,* from WindchillDB.MembershipLink link
INNER JOIN  WindchillDB.WTUser users
ON users.idA2A2 = link.idA3B5 
inner join WindchillDB.WTGroup GR
on link.idA3A5 = GR.idA2A2
where GR.name='MYOWN'

PetrH

[Marco_Tosin]

You can't get what you want from Windchill DB

Is it possible to generate a qml report with user-group relationship through ‘Report Manager’

Here a workaround using Java method

https://community.ptc.com/t5/Windchill/Reporting-Groups-and-Users/m-p/220306