Bug 1662924 - [RFE] Report that lists all the hosts on which a particular repository is enabled
Summary: [RFE] Report that lists all the hosts on which a particular repository is ena...
Status: NEW
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Repositories
Version: 6.4
Hardware: x86_64
OS: Linux
Target Milestone: Unspecified
Assignee: satellite6-bugs
QA Contact: Tasos Papaioannou
Depends On:
TreeView+ depends on / blocked
Reported: 2019-01-02 12:42 UTC by Suraj Patil
Modified: 2021-01-07 19:26 UTC (History)
11 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Last Closed:
Target Upstream Version:

Attachments (Terms of Use)

System ID Private Priority Status Summary Last Updated
Red Hat Knowledge Base (Solution) 3771961 0 None None None 2019-01-25 17:04:20 UTC

Description Suraj Patil 2019-01-02 12:42:58 UTC
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):
satellite 6.4

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.

Comment 5 Jason Dickerson 2020-01-15 19:52:26 UTC
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?

Note You need to log in before you can comment on or make changes to this bug.