Does your CommunityServer have spam profiles?
If you run a popular web community based on Telligents CommunityServer platform and allow everyone to register without e-mail verification for convenience, spammers are likely to know this too.
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
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.