Solved

Users in DotNetNuke and Registration date

Posted on 2006-11-23
8
376 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Live Storage Vmotion VMs with shared VMDK 10 61
Help in Bulk Insert 9 35
SQL server vNext 18 30
IF THEN WITH A BEGIN END 4 8
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

803 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