I think it'd be impossible to know which tests haven't failed. What if they failed on a developer machine because he introduced a regression, but it was fixed prior to checkin?

Your CI build thinks the test hasn't failed, but instead it was performing an important job.

Those tests probably are a good place to start if you think you have useless tests, but it's simply a heuristic.