Yes. DNN Platform is a free, open-source CMS under the MIT License.

What is the tech stack for DNN?

DNN runs on ASP.NET (.NET Framework 4.8+) with Microsoft SQL Server (2017+ or Azure SQL).

DNN Platform is community-led and a member project of the .NET Foundation.

What’s the difference between DNN and Evoq?

DNN Platform is the open-source core that's been wildly popular and adopted for over 20 years. Evoq is a commercial offering maintained by DNN Software (IgniteTech) that builds on DNN.

DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

Custom query about users within a website

4 Replies

1 Subscribed to this topic

24 Subscribed to this forum

Sort:

Author

Messages

Marco Alvarado

Veteran Member

Posts: 363

Helpful Replier

New Poster

Engaged Reader

Avid Reader

Most Liked

2/3/2026 12:03 AM

Hi Community,

I've a client that is actively using the users module, they asked me to generate a report that shows the list of users that belong to an specific role level and next to the name they also would like the deadline specified on each user for this role (all users have a deadline specified with this specific role).

Can some one point me in the direction of which tables should I use to generate my custom SQL query? I don't know where the deadline for a customize role is located within the DNN database tables.

Regards,

David Poindexter

Veteran Member

Posts: 360

Helpful Replier

MVP

2/3/2026 1:05 AM

Standby and I'll whip something up for ya...

David Poindexter

Veteran Member

Posts: 360

Helpful Replier

MVP

2/3/2026 1:24 AM

Let's try this (and see if it gets whacked):

[code]
SELECT
u.Username,
u.DisplayName,
u.Email,
r.RoleName,
ur.ExpiryDate AS RoleDeadline
FROM
dbo.Users u
INNER JOIN dbo.UserRoles ur ON u.UserID = ur.UserID
INNER JOIN dbo.Roles r ON ur.RoleID = r.RoleID
WHERE
r.RoleName = 'YourSpecificRoleName' -- Replace with actual role name
AND ur.ExpiryDate IS NOT NULL
ORDER BY
ur.ExpiryDate, u.Username;
[/code]

Marco Alvarado

Veteran Member

Posts: 363

Helpful Replier

New Poster

Engaged Reader

Avid Reader

Most Liked

2/3/2026 8:50 PM

Dave, thank you! that query worked just fine! Thank you so much for the BIG help.

David Poindexter

Veteran Member

Posts: 360

Helpful Replier

MVP

2/3/2026 9:21 PM

Happy to hear it worked Marco!

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

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

If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy.
No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved