Skip to main content
K
KU_106709466-Contributor
6-Contributor
May 4, 2023
Question

WTGroup To Memebr Relation From windchill database table

  • May 4, 2023
  • 2 replies
  • 1137 views

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"

KU_10670946_0-1683235530695.png

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

 

 

 

 

 

 

2 replies

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
May 5, 2023

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
    21-Topaz I
    Marco Tosin21-Topaz I
    21-Topaz I
    May 5, 2023

    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

     

     

     

     

    Marco
      Terms & ConditionsAccessibility statement