Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...DNN user API knownDNN user API known
Previous
 
Next
New Post
6/24/2010 10:58 AM
 
Carlos Adolfo Ortiz Quirós

Joined: 2/22/2010
Posts: 18
All of you know that DNN uses some kind of Tables and APIs to manage user registration. Question is simple, does anyone of you know how do I get to know all of this information, that is, what are the tables, how and where it stores the additional user defined profile properties, etc.

I need this information because I have a requirement that states that I need to consult that information and know all user records that belong to the Subscribers Role. 
Well, all I need to know is where  to find this information or if anyone of you have made a module or anything else

Thanks in advance.
 
New Post
6/24/2010 11:39 AM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212
  • to get to know all users in a role use
    SELECT USERID FROM UserRoles WHERE RoleID IN (SELECT ROLEID FROM Roles WHERE RoleName = 'Subscribers' AND PortalID = 0)
  • UserID, username, displayname and email are stored in Users table.
  • User Profile data is stored in UserProfile table, while profile properties are defined in PropertyDefinition table
  • Password and last login are stored using MS membership component in aspnet tables
Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
6/24/2010 4:16 PM
 
Carlos Adolfo Ortiz Quirós

Joined: 2/22/2010
Posts: 18
Thank you very much but this is not what I would have liked, hope another reply would tell me so.
 
New Post
6/24/2010 4:26 PM
 
Chris Paterra


Joined: 4/5/2003
Posts: 4377
You can see the results for Subscribers through the user interface via Admin -> Security roles. Sebastian told you where the majority of the tables are, but the there is a UserRoles is where the UserID and RoleID relation is stored (with foreign keys to Users and Roles tables). As for the "API" part, your providers set in the web.config tell you where to look (ie. which providers are in use). If it is default, these will all be within the DotNetNuke solution itself (once open, see Membership and Profile Providers section in the solution). 
Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
New Post
7/1/2010 9:38 AM
 
Carlos Adolfo Ortiz Quirós

Joined: 2/22/2010
Posts: 18
Thank you Chris

In fact that helps very much as well for what Sebastian told. And you are right. If one needed to know more about the Membership and Profile and Users what is the best way to know than to dig into the source code, that is one and the best resource ever.

I consider this thread closed as it is enough for me.
 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...DNN user API knownDNN user API known


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out