Hello,

I use a query to extract all of the users who are in a certain security role:

SELECT Users.UserID, Username, FirstName, LastName, Email, UserRoles.RoleID, Roles.RoleName
FROM         Users INNER JOIN
                      UserRoles ON Users.UserID = UserRoles.UserID INNER JOIN
                      Roles ON UserRoles.RoleID = Roles.RoleID
WHERE     (UserRoles.RoleID = 3)

This will extract all of the users for all portals in your DotNetNuke installation

That works pretty cool.

Do you know of a module that will export all that the Excel?

You can use the Reports module, use Lee's query, and you'll have the report on a DNN page.

As for exporting to Excel, copying and pasting from the Reports Module page into Excel didn't seem to work very well. It looks like you just copy raw text.

On the other hand, executing the query from the host's SQL tab gave me something that I could copy and paste into Excel quite nicely.

If you've only going to do this now and then, the query approach might be the best.