I've created a useful report that displays all the users in a particular role that displays First Name, Last Name and Email address. If anyone can tell me how I'd also extract the users phone number I'd be greatful!

SELECT    
  U.FirstName,
  U.LastName,
  U.Email
 FROM UserPortals AS UP
   RIGHT OUTER JOIN UserRoles  UR
   INNER JOIN Roles R ON UR.RoleID = R.RoleID
   RIGHT OUTER JOIN Users AS U ON UR.UserID = U.UserID
  ON UP.UserId = U.UserID 
 WHERE ( UP.PortalId = 1)
  AND (R.RoleName = 'Registered Users')
  
 ORDER BY U.FirstName + ' ' + U.LastName

There is a function (depending on your version) called

GetProfileElement

OK, It appears that I am missing something fairly basic. I am on DNN 04.05.01.

Does anyone have information on where to find and how to use the GetProfileElementfunction?