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'

Released for: Schneider Electric Canada