Deletion of Account does not remove sites or Requestors

Deletion of Account does not remove sites or Requestors

G'day,
When an account is deleted, it does not remove the associated sites nor does it remove any Requestors that are tied to these sites.
While we can run the various MySQL queries to determine the orphan sites, and then run the query to work out which requestors etc are affected, this is clearly not the way it should be done as there are probably other items in teh database that are also not cleaned up properly.
Can you please provide a supported SQL query that will purge the database of any orphan objects.

Version is 7513 on MySQL.

Rgds Ben









                New to ADSelfService Plus?