All Linux clients offline

It seems that the removed clients are still in the database.

Would appreciate it if somebody has an idea or a tested SQL statement to remove the stale clients and there associated data from the database.