1. Proposed title of this feature request >> [RFE] List of all Enabled Repository of all the content hosts using Reporting Templates. 3. What is the nature and description of the request? >> Using a reporting template to fetch the information for a selected host or all hosts which are repositories are enabled on the content hosts. 4. Why does the customer need this? (List the business requirements here) >> Customer have to manually pull this information for every client system from the satellite web UI which he needs to automate. 5. How would the customer like to achieve this? (List the functional requirements here) >> By using reporting template should be the way where they can get this information on a email as well. 6. For each functional requirement listed, specify how Red Hat and the customer can test to confirm the requirement is successfully implemented. >> 7. Is there already an existing RFE upstream or in Red Hat Bugzilla? >> No 8. Does the customer have any specific timeline dependencies and which release would they like to target (i.e. RHEL5, RHEL6)? >> No 9. Is the sales team involved in this request and do they have any additional input? >> No 10. List any affected packages or components. >> Report Templates 11. Would the customer be able to assist in testing this functionality if implemented? >> Yes
Thanks for the report, could you please prepare an example of the report output? Or specify what exact columns you'd like to see in the resulting report. That would greatly help, I have a feeling that such report can be already constructed with the existing Satellite version, that depends on how many things we'll need to allow in the safemode.
Created redmine issue https://projects.theforeman.org/issues/34695 from this bug
Moving this bug to POST for triage into Satellite since the upstream issue https://projects.theforeman.org/issues/34695 has been resolved.
Verified in 6.11 snap 18.5 on RHEL 7 Content Host repository count template works with Safe Mode enabled. Steps to Reproduce: 1. Setup content and attach it to a Content Host 2. Go to Monitor > Report Templates > Create Template 3. Paste into editor and submit: <%- report_headers 'Host ID', 'Host Name', 'Repository Name', 'Package Count' -%> <%- load_hosts(includes: [:content_facet => :bound_repositories]).each_record do |host| -%> <%- (host.bound_repositories || []).each do |repo| -%> <%- report_row( 'Host ID': host.id, 'Host Name': host.name, 'Repository Name': repo, 'Package Count': repo.content_counts['rpm'] ) -%> <%- end -%> <%- end -%> <%= report_render -%> 4. Generate the template Expected Results: Report is created with Safe Mode enabled and no issues. Actual Results: Report is created with Safe Mode enabled and no issues. Notes: You can verify in settings that safe mode is enabled.
Verified in 6.11 snap 21 Host - Enabled Repositories report present in UI and lists repositories attached to content hosts. Steps to Reproduce: 1. Setup content and attach it to a new content host 2. Make sure you enable and update the repos on the content host 3. Go to Monitor > Report Templates 4. Click Generate next to Host - Enabled Repositories Expected Results: A table listing host name, id, repositories, and package count Actual Results: A table listing host name, id, repositories, and package count
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (Moderate: Satellite 6.11 Release), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHSA-2022:5498
Verified on 6.11.2 snap 2 on RHEL 8.6 Host - Enabled Repositories report also works on RHEL 8. See https://bugzilla.redhat.com/show_bug.cgi?id=1944802#c23 above for steps to reproduce.