nectarios777
asked on
Users in DotNetNuke and Registration date
Hello all,
could someone please send me the SQL script to get the users from DotNetNuke
portal database along with their registration date?
Thanks
could someone please send me the SQL script to get the users from DotNetNuke
portal database along with their registration date?
Thanks
ASKER
Hi,
thanks for your response. Well its more complicated than this since many tables are involved.
The problem is that the users are stored in asp.net membership/profile tables and its hard to decode the data.
thanks for your response. Well its more complicated than this since many tables are involved.
The problem is that the users are stored in asp.net membership/profile tables and its hard to decode the data.
Have a look at http://www.dotnetnuke.com/About/Documentation/ProjectDocuments/tabid/478/Default.aspx
You can download the full ERD for the version you are using.
You can download the full ERD for the version you are using.
For example, the ERD for version 4.3.3 shows (amongst other things)
1. Users table
2. Linked to Profile table on UserID and UsersOnline table on UserID
3. Profile table has a CreatedDate
4. UsersOnline has a CreationDate
5. Portals table linked to UsersOnline table on Portal ID
6. Portals table has a UserRegistration column (not quite sure what it relates to)
This is just an educated guess, but then I don't know the application, functionality, data or structure.
Is the UserName encrypted? Or is it stored in clear text?
1. Users table
2. Linked to Profile table on UserID and UsersOnline table on UserID
3. Profile table has a CreatedDate
4. UsersOnline has a CreationDate
5. Portals table linked to UsersOnline table on Portal ID
6. Portals table has a UserRegistration column (not quite sure what it relates to)
This is just an educated guess, but then I don't know the application, functionality, data or structure.
Is the UserName encrypted? Or is it stored in clear text?
ASKER
I appreciate your quick responses but it would be hard for me to explain
how asp.net profiles and membership work in conjunction with the users table.
It wouldn't be hard for someone who has experience in DotNetNuke.
Thanks
how asp.net profiles and membership work in conjunction with the users table.
It wouldn't be hard for someone who has experience in DotNetNuke.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What does the table schema look like?
Is there a table called tblUsers?
If so, run SELECT * FROM tblUsers WHERE 1=0 and post the results (column names) here.
If you want to get a list of all the tables in the database, run
SELECT name FROM sysobjects WHERE xtype='U'