In this article, we will discuss the process of retrieving the Group details of the User according to the Group they belong to.

Windows

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. 

• 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;

Note: Modify the queries mentioned in this article according to your deployment.
 

How to retrieve the Group details of a User based on the Group they belong to in TIBCO Data Virtualization?

How to connect to TIBCO Data Virtualization (TDV) repository via PGadmin/ DBvisualizer?