Thanks again for the help! Surprisingly I was able to figure it out. :)
I combined a query that selected security roles with a forum query to select profile properties - here's the forum entry for select profile properties:
http://www.dnnsoftware.com/forums/threadid/435402/scope/posts/sql-query-for-user-profile
(Thank you Josh Wheeler and Sebastian Leupold!)
and, guess what -- it worked! I'm sure it can be made more efficient, for sure (I'd love for you SQL gurus to modify!), but I wanted to share this for those like me struggling with this issue.
Query is below, and thanks again!
Select
U.UserID,
U.Username,
U.DisplayName,
U.Email,
Case UP.IsDeleted When 1 Then 'Yes' Else 'No' End As IsDeleted,
(Select
UserProfile.PropertyValue
From
UserProfile
Where
UserProfile.UserID = U.UserID And
UserProfile.PropertyDefinitionID = (Select
ProfilePropertyDefinition.PropertyDefinitionID
From
ProfilePropertyDefinition
Where
ProfilePropertyDefinition.PropertyName = 'Company' And
ProfilePropertyDefinition.PortalID = 0)) As Company,
(Select
UserProfile_2.PropertyValue
From
UserProfile As UserProfile_2
Where
UserProfile_2.UserID = U.UserID And
UserProfile_2.PropertyDefinitionID = (Select
ProfilePropertyDefinition_2.PropertyDefinitionID
From
ProfilePropertyDefinition As ProfilePropertyDefinition_2
Where
ProfilePropertyDefinition_2.PropertyName = 'City' And
ProfilePropertyDefinition_2.PortalID = 0)) As City,
(Select
UserProfile_1.PropertyValue
From
UserProfile As UserProfile_1
Where
UserProfile_1.UserID = U.UserID And
UserProfile_1.PropertyDefinitionID = (Select
ProfilePropertyDefinition_1.PropertyDefinitionID
From
ProfilePropertyDefinition As ProfilePropertyDefinition_1
Where
ProfilePropertyDefinition_1.PropertyName = 'State' And
ProfilePropertyDefinition_1.PortalID = 0)) As State,
(Select
UserProfile_1.PropertyValue
From
UserProfile As UserProfile_1
Where
UserProfile_1.UserID = U.UserID And
UserProfile_1.PropertyDefinitionID = (Select
ProfilePropertyDefinition_1.PropertyDefinitionID
From
ProfilePropertyDefinition As ProfilePropertyDefinition_1
Where
ProfilePropertyDefinition_1.PropertyName = 'SalesTerritory' And
ProfilePropertyDefinition_1.PortalID = 0)) As Territory,
(Select
UserProfile_1.PropertyValue
From
UserProfile As UserProfile_1
Where
UserProfile_1.UserID = U.UserID And
UserProfile_1.PropertyDefinitionID = (Select
ProfilePropertyDefinition_1.PropertyDefinitionID
From
ProfilePropertyDefinition As ProfilePropertyDefinition_1
Where
ProfilePropertyDefinition_1.PropertyName = 'JobTitle' And
ProfilePropertyDefinition_1.PortalID = 0)) As [Job Title],
aspU.LastActivityDate,
Roles.RoleName
From
Users As U Left Outer Join
UserPortals As UP
On U.UserID = UP.UserId Left Outer Join
aspnet_Users As aspU
On aspU.UserName = U.Username Inner Join
UserRoles As UR
On UR.UserID = U.UserID Inner Join
Roles
On UR.RoleID = Roles.RoleID
Where
UP.PortalId = 0 And
Roles.RoleName = 'Subscribers'