If you have the Pulp CLI installed and pointed at Katello, you can do pulp repository list to get a list of each repository. Then for each repository you can run pulp show --href {REPO_HREF}/versions/ and the problematic ones will return a 500 error. I’m a Pulp developer so I don’t know how to use Katello, so maybe a Katello dev can clarify the equivalent Katello calls.
@rgp Also, I’ve updated the patch to be a one line insertion.