Solved

Users in DotNetNuke and Registration date

Posted on 2006-11-23
8
384 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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
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

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

728 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