---
title: Does your CommunityServer have spam profiles?
kind: blog
description: 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.
words: 109
readingMinutes: 1
created: '2009-12-03T19:25:17.000Z'
updated: '2026-06-27T21:03:45+02:00'
tags:
  - communityserver
  - development
---
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:

```sql
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.