Forum .LRN Q&A: How to find out all admins of all dotlrn groups

Hi,

has someone tried to create a list of all dotlrn administrators before? While classes have 4 different relations subgroups have only two (admin, member). I need to create a mailing list of all administrators.

Greetings,
Nima

Collapse
Posted by Dave Bauer on
Something like this:

select object_id_two from users u, acs_rels a, dotlrn_admin_rels d where a.rel_id=d.rel_id and object_id_two=u.user_id;

You'll want to get unique rows so you only email each admin once.