Avatar

Level 3

Hello All,

I found the Query:

SELECT prin.commonname,
       prin.email,
       refparentprincipalid
FROM   edcprincipalentity AS prin,
       edcprincipalgrpctmntenti AS gr
WHERE  prin.id = gr.refchildprincipalid
  AND  refparentprincipalid =
            (SELECT id
             FROM edcprincipalentity lcuser
             WHERE lcuser.principaltype = 'GROUP'
                  AND lcuser.commonname = '<String Name of the Group>')

Thanks a lot to Paul for helping.

Deepak.