Project

General

Profile

Actions

Feature #34711

closed

Report that lists all the hosts on which a particular repository is enabled

Added by Ryan Verdile over 2 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Repositories
Target version:
Difficulty:
Triaged:
Yes
Fixed in Releases:
Found in Releases:

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.

  1. 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.

Actions #1

Updated by The Foreman Bot over 2 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Ryan Verdile
  • Pull request https://github.com/Katello/katello/pull/10045 added
Actions #2

Updated by Partha Aji over 2 years ago

  • 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
  • Target version set to Katello 4.5.0
  • Triaged changed from No to Yes
Actions #3

Updated by The Foreman Bot over 2 years ago

  • Fixed in Releases Katello 4.5.0 added
Actions #4

Updated by Ryan Verdile over 2 years ago

  • Status changed from Ready For Testing to Closed
Actions

Also available in: Atom PDF