Does your CommunityServer have spam profiles?

These user profiles pollute your authority and you probably want to delete them, but first you have to identify them. I found the following query helpful for this purpose:

SELECT
U.UserName
FROM
aspnet_users U
JOIN
aspnet_profile P
ON
U.UserID = P.UserID
JOIN
CS_Users CSU
ON
CSU.MembershipID = U.UserID
WHERE (
P.PropertyValuesString LIKE '%<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %' OR
P.PropertyValuesString LIKE '%position:absolute%'
OR
P.PropertyValuesString LIKE '%overflow:hidden%'
)
AND
(SELECT COUNT(*) FROM CS_Posts P WHERE P.UserID = CSU.UserID) = 0</a>

Make sure to check your results for false positives! Once you are sure you got all the culprits and nobody else, iterate over it and delete each spammer e. g. by running

CommunityServer.Users.DeleteUser(CommunityServer.Users.GetUser(userName));

While the code is simple the reason I don’t include it here is because I want you to think about what you are doing and not blindly copy/paste it and accidentally delete “real” users - you will likely have to customize the above SQL snippet to achieve this.