?
Solved

Users in DotNetNuke and Registration date

Posted on 2006-11-23
8
Medium Priority
?
390 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
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

801 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