Is there an easy way within SDM to get a list of groups and its corresponding members or do I need to write a sql statement against the db via SQL Mgmt Studio (getting data and joining from grpmem and ca_contact tables?)
We are using v14.3 with SQL Server database.
See if the SQL query listed in the following Community Post meets your requirements
SQL query for contact details page
Thanks Paul ... I was able to use several of the listed queries to get all the information I needed.
Thanks for the feedback Katherine.
Glad the information helped.
Katherine, indeed there is no easy way in SDM UI to list all groups with their members. And even customization won't be an easy one. So yes you may need to write sql query to query and join mdb tables ca_contact and grpmem. Thanks _Chi