Hi guys,

I'm trying to do the SQL Export as specified in Issue 32 :

http://www.dnncreative.com/Tutorial...fault.aspx

But have noticed that in my DNN 4.9 install the table names have changed.  I now have Membership instead of UserRoles, and its Membership where most of the user data is stored.  And therefore the below query doesnt work:

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)

My table names are also appended with dbo.aspnet_Users etc

My SQL isnt that good, any chance you have a new version of the Query that works on DNN 4.9?  Im looking to export usernames and emails so I can setup a newsletter with iContact.

Thanks for your help,

Simon

The tables whose names begin with dbo.aspnet_ ... are not the ones at which you should be looking. Those table are partly used by the authentication part of DotNetNuke. "Most" of the data is not stored in those tables.

You should have dbo.Users and dbo.UserProfiles. If you don't have those tables, so look again. If those tables really don't exist in your database, something is wrong, and it is surprising that you site should be running.

Please check and let me know what you find.

Ah yes, rookie mistake! Should have figured that one out.

SELECT UserID, Username, FirstName, LastName, Email FROM dbo.DNNWOB_Users

This query gave me everything I needed. Thanks for your help