Link to home
Start Free TrialLog in
Avatar of nectarios777
nectarios777Flag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of Nightman
Nightman
Flag of Australia image

Hi haven't used DotNetNuke, but I can help you find it.
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'
Avatar of nectarios777

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.
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.
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?
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
ASKER CERTIFIED SOLUTION
Avatar of Nightman
Nightman
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial