CA Service Management

  • 1.  Groups List and Its Members

    Posted May 31, 2018 04:13 PM

    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.

     

     

    thank you

    Katherine



  • 2.  Re: Groups List and Its Members
    Best Answer

    Broadcom Employee
    Posted May 31, 2018 04:47 PM

    Katherine.........

     

    See if the SQL query listed in the following Community Post meets your requirements

    SQL query for contact details page 



  • 3.  Re: Groups List and Its Members

    Posted Jun 01, 2018 08:39 AM

    Thanks Paul ... I was able to use several of the listed queries to get all the information I needed.



  • 4.  Re: Groups List and Its Members

    Broadcom Employee
    Posted Jun 01, 2018 09:44 AM

    Thanks for the feedback Katherine.

     

    Glad the information helped.



  • 5.  Re: Groups List and Its Members

    Broadcom Employee
    Posted May 31, 2018 04:55 PM

    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