Version 1
    select u.username, u.lastname, u.firstname, u.email  
    from jivedw_user u  
    where userenabled=1;  
    
    

     

    This is another handy query for if you want to do something not-social like send a mail to all members

    If you concatenate in Excel to add on a semicolon to the end of the email address they cut/paste into Outlook well.