In module settings of user accounts module you should be able to select columns to display.
there are modules in the DNN store to provide you with export feature, e.g. PHDObson user manager.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

I was able to create the script I needed my host to execute. This script will reset the User Account 'Default Display Mode' to the correct value. The problem was caused by DNN 'User Accounts Settings' module not having edits on the 'Default Display Mode' value and their documentation indicating the value for this attribute to be alpha instead of numeric. When logged in as a "host" this attribute value is a drop down box; when logged in as an admin, it is a text box.

There are two lines of SQL script. The first will return one row with a "SettingValue" of "all". The second line of script will reset the column value to "2" for portal 6.

SELECT SettingValue FROM PortalSettings WHERE PortalID=6 AND SettingName='Display_mode'

UPDATE PortalSettings SET SettingValue = 2 WHERE PortalID=6 AND SettingName='Display_mode'

Finally, please go to Host-->Host Setting--> and click "Restart Application". This will recycle the application pool, with no effects on other active applications.

I hope this helps someone else.

Thanks.

David