Login as Host, go to Host > SQL and paste the following script.  Once it runs (I've only tested this on DNN 07.04.02 (216))  you'll see a green success notification on the page and the table of user data will appear below. I suggest copying and pasting into your favorite spreadsheet program, because clicking the icon to Save Query prompts you to name your query, and then save it and you'd think you'd get a prompt to download a usable file, csvs are always easy, but it doesn't download, so you'd think that it might save a copy of the query results to the server, maybe in the root. I even looked in there, and searched Admin and Host File Managers... the icon just saves the query so you can run it again later in the loader. lol.

Looking for Hotcakes Support (for both open source and commercial editions)?  Talk to us... 

Sebastian Leopold explains how to soft and hard delete spam registration users...

Security Roles (Manage Services) Not Working? Here is the fastest fix that ever fixed a bug in DotNetNuke (DNN7, DNN8)! Thank you Sebastian Leupold (TurboScripts for DNN)

Yup... it's true... the HTML PayPal generates does not work with DotNetNuke because there is a tag.

Lots of people ask, "What exactly is DotNetNuke?"... and the answer can often come out rather technical. Here is an easy set of slides that should help you articulate how DNN has evolved and the stack upon which it resides.

Ever notice that DotNetNuke shows "Root" in the breadcrumb trail instead of "Home"? Here's how to fix that in 20 seconds (or less)!

Want to get MailChimp up and running on your DotNetNuke portal, but can't get the code to work? Here's an easy modification!