Getting all the Users and their EmailIDs of a Group from database

hello all,

 

i'm using lc 8.2.  requirement need send email members of particular group.  dont want hardcode email ids.

 

think in workbench, there no way email ids of member of particular group (if please let me know).  think better approach data database.

 

have written query able email ids database, thing i'm not able restrict particular group; i'm not finding table having group name in string format.  please in completing query.

 

select lcuser.canonicalname, lcuser.email
from edcprincipalentity lcuser, edcprincipalgrpctmntenti lcgroup
where lcuser.id = lcgroup.refchildprincipalid

 

thanks

deepak

hello,

edcprincipalentity table has field named principaltype group has paramater group.

try sql:

 

select lcuser.commonname, lcuser.email
from edcprincipalentity lcuser
where lcuser.principaltype = 'group' , lcuser.email not null

 

best regards,

paul butenko

More discussions in Workbench FAQs

adobe