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'
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
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales inquiry online and en expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Center
Find support resources for all your needs, in one place.