Products

Solutions

Resources

Partners

Community

Blog

About

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 ...Download list of all user accountsDownload list of all user accounts
Previous
 
Next
New Post
10/29/2010 11:26 AM
 
Is it possible to download (to Excel or other) the list of all users?
 
New Post
10/29/2010 1:05 PM
 
If you have a small list of users and if you have Host access you can run a simple SQL script from the Host -> SQL tool.  Copy and past to excel.
If you have a large list of users I would suggest  SGSV (www.tressleworks.ca)
It's a great tool and chores like this become as easy as making a peanut butter sandwhich. :)
 
New Post
10/29/2010 1:30 PM
 
I've used the Host > SQL Tool and I've used the Reports module.

Here's a couple variations of a sample script:
DECLARE @PortalID int;
DECLARE @authorized bit;
SET @PortalID = 0
SET @authorized = 1
SELECT U.UserID
, (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'CustomPropertyName1' AND PortalID = @PortalID)) AS MyCustomProperty1 -- Used to get a profile field
, (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'CustomPropertyName2' AND PortalID = @PortalID)) AS MyCustomProperty2 -- Used to get a profile field
, (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'CustomPropertyName3' AND PortalID = @PortalID)) AS MyCustomProperty3 -- Used to get a profile field
, U.Username
, U.FirstName
, U.LastName
, U.Email
, U.DisplayName
, UP.CreatedDate
, UP.Authorised AS Authorzied
FROM USERS AS U
LEFT JOIN UserPortals AS UP
ON (U.UserId = UP.UserId)
WHERE ( UP.PortalId = @PortalId OR @PortalId IS NULL )
AND Authorised = COALESCE(@authorized, Authorised)
ORDER BY U.FirstName + ' ' + U.LastName

------------------------------------------------------------------

SELECT  
-- u.UserID
u.FirstName + ' ' + u.LastName AS FullName
-- , u.LastName
, u.Email
, u.DisplayName
, pr.PropertyValue AS MyCustomProperty1
, prn.PropertyValue AS MyCustomProperty2
FROM [Users] AS u
JOIN UserPortals AS up
ON (u.UserID = up.UserID
AND up.PortalID = 1
AND up.IsDeleted = 0
AND Authorised = 1)
JOIN UserProfile AS pr -- Used to get a profile field
ON (u.UserID = pr.UserID
AND pr.PropertyDefinitionID = ##somenumber##) 
JOIN UserProfile AS prn
ON (u.UserID = prn.UserID
AND prn.PropertyDefinitionID = ##somenumber##)

Hope this helps.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Download list of all user accountsDownload list of all user accounts


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