SQL code lists email addresses of all members of DNN security role by name
June 29th, 2009
This is a very simple (and portable) SQL statement that will list the email addresses of all members of a DNN security role by the security role name.
This is useful if you use 3rd party newsletter or email listserv software and need the email addresses of all members of a DNN security role.
SELECT u.Email FROM Users u, UserRoles ur, Roles r WHERE r.RoleID = ur.RoleID AND ur.UserID = u.UserID AND r.RoleName = 'Registered Users'
You can replace 'Registered Users' with any Security Role name.
This can be executed from the Host>SQL page or using the Microsoft SQL Server Management Studio.