List of all users in a usergroup

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