where are the member properties stored in umbraco

Question

I'm trying to export member properties like first name, last name from the database but I can't seem to find it. I see that there is a loginUser table with the right columns, but it seems to only hold 5 entries instead of the full list of people that I see in the admin interface.

Answer 1

The member properties are stored in the cmsPropertyData table. The contentNodeId will correspond to the id of the member.

It may be easier to use the api to export your data. Umbraco uses the standard ASP.NET Membership Provider model. See Membership providers for more details.