Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more!
When reporting group membership using any of the CLI calls or api, identify which groups the user is a direct member of and which they are a member of due to a nested group.
Reviewed by PTC Community Member
Integrity Lifecycle Manager Administration
Users and Group Management
Related Working Group:
Standard Functionality validated:
Standard Functionality available in Release 11.2:
A simple SQL query will return the data you are looking for. see below
Other knows solutions:
Pull out all group details using CLI or API, and analyse programmatically the direct assigned groups. But this approach is quite complex, and you would always read data which you don't need to answer this question.
Related other Ideas:
Administration Configuration Reports
Next review Milestone:
Use the following SQL Command to list the direct group assignments (Oracle version): select PrincipalName||';'||GroupName from MKSDomainGroupMembers where IsGroup=0 and PrincipalName='<username>'; Side effects: When you execute this SQL using "im diag --runsql", this call will be tracked in the server.log
@VolkerEckardt Please allow me the Question: If it is as easy with the Workaround, why didn't had PTC R&D implemented that change in the meantime?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.