How to retrieve the Group details of a User based on the Group they belong to in TIBCO Data Virtualization?
Article ID: KB0071780
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 8.4.x,8.5.x,8.6.x |
Description
In this article, we will discuss the process of retrieving the Group details of the User according to the Group they belong to.
Issue/Introduction
How to retrieve the Group details of a User based on the Group they belong to in TIBCO Data Virtualization?
Environment
Windows
Resolution
Currently, there are two methods to achieve this:
In the first method, get the User names by Group using the getUsersByGroup() API. Input the result into a view and use the XML extract function to fetch the names in text format (refer to the below sample screenshot). 
In the second method, we can connect to the TDV repo and get the User/Group details from the Metadata tables.
NOTE: Do not make any changes to the TDV Metadata Repository Database.
Note: Modify the queries mentioned in this article according to your deployment.
In the first method, get the User names by Group using the getUsersByGroup() API. Input the result into a view and use the XML extract function to fetch the names in text format (refer to the below sample screenshot).
NOTE: Do not make any changes to the TDV Metadata Repository Database.
- Connect to TDV repo using any JDBC client such as DBVisualizer or PGadmin (refer to the KB article in the reference section).
- Explore cis_repo schema.
- Run the below query to get user_names and their respective groups.
- select gm.group_id, su.name
from cisrepo.security_members su, cisrepo.security_group_members gm
where gm.member_id = su.id;
- select gm.group_id, su.name
Note: Modify the queries mentioned in this article according to your deployment.
Additional Information
Feedback
Yes
No
Powered by
