We've been looking for exactly the same thing here, but to no avail.
The count(*) method does not work, just as 'select fieldname from ext_table' doesn't do the trick.
I still have a problem coming to terms with the fact that I have to iterate over all the records in the table myself, manually, just to find bad records, but it looks like this will have to be the solution.