nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

List of all users in a usergroup

Clare_Turner

does anyone have a report which will list all the people in a usergroup. We have a very large group which I would like to report on.Thanks

Find more posts tagged with

Comments

Evert_Kuiken_(ekuiken_-_(deleted))

Message from Kuiken, Evert <Evert.Kuiken@alliander.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

That is not so difficult:

SELECT NAME /* Add whatever information about the group members you need */FROM livelink.kuaf, livelink.kuafchildrenWHERE kuaf.ID = kuafchildren.childid /* Join KUAF and KUAFCHILDREN to get more information then just ID of group members */AND kuafchildren.ID = (SELECT ID /* Get ID of group members ('children') from KAUFCHILDREN */FROM livelink.kuafWHERE NAME = '<putgroupnamehere>' AND kuaf.TYPE = 1) /* Get groupid from KUAF */Regards, Evert