Hi there

I'm new to DNN so forgive me if this is a dumb question.  

I've been asked to take over the management of a  DNN site.  I've been tasked with contacting all of the owners of the portals in a community DNN install.  

What would be the best way of doing this?  I was hoping there would be a way of seeing what users (the user info contains contact details) were attached to what portals, then using the user info to contact the portal owners.  

Is this possible?  

Thanks

Scoopy

You can create a SQL view or use the Reports module to add a list of Administrators (I use this as a hidden module on my main site so that I can find ALL Administrators).

SELECT DISTINCT dbo.Users.Email
,dbo.Roles.RoleName, dbo.PortalAlias.HTTPAlias
FROM dbo.Roles INNER JOIN
dbo.UserRoles ON dbo.Roles.RoleID = dbo.UserRoles.RoleID INNER JOIN
dbo.Users ON dbo.UserRoles.UserID = dbo.Users.UserID INNER JOIN
dbo.PortalAlias ON dbo.Roles.PortalID = dbo.PortalAlias.PortalID
WHERE (dbo.Roles.RoleName = N'Administrators')

Comment out line 2 if you only want to return the e-mail addresses.