Technical FAQs

Ask a Question

How to get a list of users within a user group

A SQL query against the database may be used to retrieve a list of users within a particular user group. The particular example below uses the group name as filter. The SQL query in the example retrieves a list of all users within the Administrator group.

SELECT
    U.NAME, U.USERGROUPIDS, G.NAME, G.ID
FROM
    CDBUSER AS U CROSS JOIN CDBUSERGROUP AS G
WHERE
    G.ID IN ( U.USERGROUPIDS ) AND G.NAME = 'Administrator'
Was this helpful?
What can we do to improve the information ?