Description of problem:
Web UI report or the search filter in content hosts page to list all the hosts on which the particular repository is enabled.
Currently satellite contents the data that which repositories are enabled on the host, we can find it in the "repository sets" tab of content host. But there is no way to get the list of all the hosts on which a particular repository is enabled.
Version-Release number of selected component (if applicable):
Additional info: Workaround
Below query helps to get that.
# sudo su - postgres -c "psql -d candlepin -c 'select cp_consumer.name from cp_consumer INNER JOIN (select * from cp_content_override where content_label = '\''rh-gluster-3-for-rhel-7-server-rpms'\'' and value = '\''1'\'') x ON x.consumer_id = cp_consumer.id;'"
Note - before running the above command on satellite server please change rh-gluster-3-for-rhel-7-server-rpms as per the repository you want to search for.
The query in the description seems to only query overrides for repositories, not the current state. For instance, if a repository is on by default (no override necessary) it does not seem to appear in the query. I believe we need to query the information uploaded from clients by the enabled repositories yum plugin. Is that possible?