{}

Vores varemærker

Impact-Company-Logo-English Black-01-177x54

Velkommen til Schneider Electrics website

Velkommen til vores website
Hvordan kan vi hjælpe dig i dag?
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'

Schneider Electric Danmark

Se mere
Område:
Artikler som kan være nyttige
Se mere
Område: