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'
Udgivet til: Schneider Electric Danmark
Brug for hjælp?
Produktvælger
Find hurtigt og nemt de rette produkter og det rette tilbehør til dine anvendelser.
Få et tilbud
Start din salgsforespørgsel online, så vil du blive kontaktet af en ekspert.
Find forhandler
Find den nærmeste Schneider Electric-distributør.
Hjælpecenter
Find supportressourcer til alle dine behov på ét sted.