How can I identify PR's that were merged but that had failing status checks?

Do I have to loop through every PR in every repo to build this list or is there a faster/built in way to identify these?

Good day.

Why do you ask if ever a pull request is merged? Are you not the owner of the repo? Please provide further details. Thanks.

Also, we are at the final day of this 10-Day Community Clean-Up, you may want to check it out:

I want to find PR’s that were merged but that had failing status checks across my entire organization. We have more than 1700 repos and a few hundred developers. Due to several factors out of my control, not every repo is configured the same way. I could find those repos that are configured to allow this, but that isnt going to tell me if there were any PR’s that did get merged without all status checks passing.

If there is a faster way to identify these than looping, that would be great.