Avatar

Level 6

Hello,

edcprincipalentity table has field named principaltype where group has paramater GROUP.

Try this SQL:

select lcuser.commonname, lcuser.email
from edcprincipalentity lcuser
where lcuser.principaltype = 'GROUP' and lcuser.email is not null

Best regards,

Paul Butenko