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,