Project

General

Profile

Feature #34711

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

Added by Ryan Verdile 12 months ago. Updated 11 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Repositories
Target version:
Difficulty:
Triaged:
Yes
Bugzilla link:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

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.

Associated revisions

Revision d6d9b712 (diff)
Added by Ryan Verdile 11 months ago

Fixes #34711 - Search hosts by repository (#10045)

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

Also available in: Atom PDF