Technical FAQs

Ask a Question

Getting a list of users in a particular user group

The below example shows a SQL query that may be used to retrieve a list of users for a particular user group. In this example, the result of the SQL query would show a list of users for a user group named "Administrator".

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'
ORDER BY
U.NAME ASC
Was this helpful?
What can we do to improve the information ?