Solved

Users in DotNetNuke and Registration date

Posted on 2006-11-23
8
379 Views
Last Modified: 2012-08-13
Hello all,

could someone please send me the SQL script to get the users from DotNetNuke
portal database along with their registration date?

Thanks
0
Comment
Question by:nectarios777
  • 4
  • 2
8 Comments
 
LVL 29

Expert Comment

by:Nightman
ID: 18004873
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'
0
 
LVL 1

Author Comment

by:nectarios777
ID: 18004929
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.
0
 
LVL 29

Expert Comment

by:Nightman
ID: 18004950
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.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 29

Expert Comment

by:Nightman
ID: 18004992
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?
0
 
LVL 1

Author Comment

by:nectarios777
ID: 18005046
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
0
 
LVL 29

Accepted Solution

by:
Nightman earned 250 total points
ID: 18005080
Well, you could have a look at these 2 links:
http://www.smart-thinker.com/Other/Newsletters/Other/Articles/DotNetNuke/Resources/SimpleSQL/tabid/267/Default.aspx
and
http://www.dnnstuff.com/Home/tabid/166/ctl/ArticleView/mid/574/ArticleID/43/PageID/8/Default.aspx

Interesting stuff - note the relationships closely match those that I extrapolated from the ERD - of course, they have aspnet_ appended as a prefix, but then I did say that I didn't know the app ;)

Or

http://dnn.polyduck.co.uk/DNNTips/DNNTip1GettingaListofPortalUsers/tabid/234/Default.aspx

Code to create a listbox with all the details. If you just want the SQL, run SQL Profiler against your SQL database to see what stored procedures are called when the statement
ctlUsers.GetUsers(PortalId, false, false);
is executed.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question