support group with email

support group with email

Hello, 
i need to retreive the list of group and email of this group, 
first to check which one does not have a email adress and create it. 
second to create a file that will be use as input in a python scripts.
any idea ? 
SQL, report etc...
regards,

                    New to ADSelfService Plus?