Hi Guys,

I need to remove a lot of posts by a couple of users from my AD installation. Now I'm pretty sure there is nothing directly in AD that will allow me to do that, so I want to do it in the back end.

Has anyone got a definative list of what needs deleting from where? Or even better.. any scripts?

UserProfiles for the actual profile.
Content for what look like the actual posts (Can we ignore Content_Attachments?)
ForumTopics... not sure how to tie that in.
Replies.. same
I guess Forums needs updating with correct post counts, but no idea on how to achieve that.


All in all, not easy.

Any thoughts?

OK, so I found the "IsDeleted" column in the Content and ForumTopics tables.

I've looked up the AuthorID and ran a select statement against the user (joining in the ForumTopics for that user), and set the IsDeleted to 1. All posts have now gone )

One question though.. I forgot to check post numbers before and after... would this be dynamically updated?