Bug 1702878

Summary: Errata counts aren't similar between the satellite content-hosts view and the export csv
Product: Red Hat Satellite Reporter: Anand Agrawal <aagrawal>
Component: Hosts - ContentAssignee: Anand Agrawal <aagrawal>
Status: CLOSED ERRATA QA Contact: Stephen Wadeley <swadeley>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.4.2CC: aagrawal, aymeric.marchal, mshimura, rcavalca, zhunting
Target Milestone: 6.6.0Keywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2019-10-22 19:49:43 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Anand Agrawal 2019-04-25 04:20:23 UTC
Description of problem:
Export CSV from content hosts page do not match the errata count from the Satellite web UI

Version-Release number of selected component (if applicable):

How reproducible:

Steps to Reproduce:
1. GoTo Hosts -> Content Host
2. In the table, you will see Errata count for all hosts.
3. Click `Export` from the top. This will generate a CSV file. 
4. Errata count does not match.

Actual results:
Errata count in the CSV are different from the web UI

Expected results:
Both should show the same count

Additional info:

WEB UI is showing installable errata whereas CSV is showing applicable errata

Comment 3 Bryan Kearney 2019-04-29 16:07:38 UTC
Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/26678 has been resolved.

Comment 5 Stephen Wadeley 2019-06-05 07:19:40 UTC

Testing on 6.5 to reproduce the problem

[root@cloud-qe-21 ~]# rpm -q tfm-rubygem-katello

I see column:
 Installable Updates
 Security, Bug Fix, Enhancement, Package Updates
2 0 0 2

Click "Export", open CSV file, view columns:

Installable Updates - Security
0    <--- Does not match GUI text.

Installable Updates - Bug Fixes

Installable Updates - Enhancements

Installable Updates - Package Count

Will test again after upgrade to latest snap.

Comment 6 Stephen Wadeley 2019-06-05 12:36:59 UTC

Testing on system updated to latest snap

[root@cloud-qe-21 ~]# rpm -q tfm-rubygem-katello

Reloaded web UI, GUI text still as in comment 5

Exported CSV file again

I see "Installable Updates - Security" column is now 2

this is the same as the GUI text. Its Correct now.

Thank you

Comment 7 Bryan Kearney 2019-10-22 19:49:43 UTC
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, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.