Feature #34711
Report that lists all the hosts on which a particular repository is enabled
Difficulty:
Triaged:
Yes
Bugzilla link:
Pull request:
Description
Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1662924
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.
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.
Associated revisions
History
#1
Updated by The Foreman Bot 12 months ago
- Assignee set to Ryan Verdile
- Status changed from New to Ready For Testing
- Pull request https://github.com/Katello/katello/pull/10045 added
#2
Updated by Partha Aji 12 months ago
- Triaged changed from No to Yes
- Target version set to Katello 4.5.0
- Subject changed from Report that lists all the hosts on which a particular repository is enabled to Report that lists all the hosts on which a particular repository is enabled
#3
Updated by The Foreman Bot 11 months ago
- Fixed in Releases Katello 4.5.0 added
#4
Updated by Ryan Verdile 11 months ago
- Status changed from Ready For Testing to Closed
Applied in changeset katello|d6d9b712f3cdae45823431a0b786b975bbbcdced.
Fixes #34711 - Search hosts by repository (#10045)