Hey there,

We have the current base query to display a report of all users in our system, which is: 

SELECT u.username, firstname, lastname, u.email, from {databaseOwner}{objectQualifier}users AS U INNER JOIN {databaseOwner}vw_aspnet_membershipUsers AS A on U.username = A.username 

Could someone please help me to modify it to also display the custom property name/ID called "Campus"?  I can't seem to find out where the custom property is displayed, and how it might be included in the results... thanks so much!

--Dave

 Hmm... thanks for the tip, but honestly, I still can't make heads of tails of what's going on - I'm no SQL expert, and messing about with views is beyond where I'm at.

Nonetheless, we still have to generate a report... Is there a sample query that pulls standard user data (like the sample I'd posted above) and also pulls in a single custom profile property? Maybe someone can post a quick code sample for how we'd do that?

Thanks!

--Dave

 Thanks for your reply... yeah, we tried that -- but it glitches and gives errors (can't get it to work), and haven't heard much about resolving the issue...