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

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.