Hey guys,

Simple question - I just want to know where the User Information that users give when they register (such as website, street, telephone etc) is stored in the database. I have looked everywhere for it, but cannot find it.

Can anyone help me?

Cheers, Sean

The information you are looking for is in the "aspnet_Profile" table.

Here is a sample SQL statement you can run in DNN to get the information. Also, I might point out that the information is stored in a single field "aspnet_Profile.PropertyValuesString" that can be parsed by the "aspnet_Profile.PropertyNames" field.

SELECT Users.Username, FirstName, LastName, Email, PropertyNames, PropertyValuesString FROM Users JOIN aspnet_Users ON Users.Username = aspnet_Users.UserName JOIN aspnet_Profile ON aspnet_Users.UserID = aspnet_Profile.UserID;

This is just a start for you. You can add to the statement to get just information for 1 user if you'd like. Hope this helps.