Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Users in DotNetNuke and Registration date

Posted on 2006-11-23
8
Medium Priority
?
406 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
6 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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 1000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

564 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