Hello all

Below a great workaround

// The command based on host-collection
---
for b in $(hammer --csv host-collection hosts --name "rh_test" --organization ACME | grep -v ^ID | cut -d, -f2); do name=$b; count=$(hammer --csv host errata list --host $b | grep -v ^ID | wc -l); echo "$name,$count"; done
---

// Example Output
---
# for b in $(hammer --csv host-collection hosts --name "rh_test" --organization ACME | grep -v ^ID | cut -d, -f2); do name=$b; count=$(hammer --csv host errata list --host $b | grep -v ^ID | wc -l); echo "$name,$count"; done
kate-piedra.local.domain,0
---

// The command based on ALL hosts registered on Satellite
---
for b in $(hammer --csv host list --organization ACME | grep -v -E '(^Id|virt-who)' | cut -d, -f2); do name=$b; count=$(hammer --csv host errata list --host $b | grep -v ^ID | wc -l); echo "$name,$count"; done | tee /tmp/server_list.log

// Example Output
---
# for b in $(hammer --csv host list --organization ACME | grep -v -E '(^Id|virt-who)' | cut -d, -f2); do name=$b; count=$(hammer --csv host errata list --host $b | grep -v ^ID | wc -l); echo "$name,$count"; done | tee /tmp/server_list.log
heath-derion.local.domain,344
kate-piedra.local.domain,0
---


Best Regards
-- 
Waldirio M Pinheiro | Senior Software Maintenance Engineer

Wouldn't any of the existing reports do better job here? See "hammer report-template list". The reports can be customized or new report templates added. Might be easier to explore the content in the UI (Monitor > Report Templates) and then generate via hammer.

Hello Martin,

About your question, this feature will be really interesting on Satellite 6.4+. On 6.5+ I need to test the report feature to confirm.

Below the example
---
# hammer host-collection hosts --name rh_test --organization ACME
-----|-----------------------------|----------|--------|------------
ID   | NAME                        | SECURITY | BUGFIX | ENHANCEMENT
-----|-----------------------------|----------|--------|------------
1049 | angie-molyneux.local.domain | 0        | 0      | 0          
1047 | bryce-hatstat.local.domain  | 65       | 240    | 39         
1045 | cody-windly.local.domain    | 65       | 240    | 39         
1051 | ellen-lofstrom.local.domain | 65       | 240    | 39         
50   | heath-derion.local.domain   | 65       | 240    | 39         
-----|-----------------------------|----------|--------|------------
---

Thanks for all your help.

Waldirio

Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/27096 has been resolved.

I'm having the same concern as with
https://bugzilla.redhat.com/show_bug.cgi?id=1719516#c5

Otherwise this looks sane.

Upstream bug assigned to wpinheir

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 (Important: Satellite 6.8 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-2020:4366