Bug 623941

Summary: [RFE] Add a channel-list and errata-list report to Satellite reports package
Product: [Community] Spacewalk Reporter: Jan Pazdziora (Red Hat) <jpazdziora>
Component: ServerAssignee: Jan Pazdziora (Red Hat) <jpazdziora>
Status: CLOSED CURRENTRELEASE QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: medium Docs Contact:
Priority: medium    
Version: 1.1CC: mminar
Target Milestone: ---Keywords: FutureFeature, Triaged
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: spacewalk-reports-1.2.2-1 Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: 578292 Environment:
Last Closed: 2010-10-28 15:54:40 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 578292, 623772    

Description Jan Pazdziora (Red Hat) 2010-08-13 08:16:08 UTC
+++ This bug was initially created as a clone of Bug #578292 +++

The spacewalk-report has the following available report:

errata-systems
errata-list
users
users-systems
entitlements
inventory

A channel-packages would really be helpful to detect if incremental
exports and sync got the disconnected satellite to full content. I would
be happy to get the list of channels with the number of packages per
channel. Having the ability to get the full list of packages in each
channel would also allow to find what's missing.

Also, I'd like to see an errata-list that gets the list of all errata,
not the errata - systems list like now:

[root@rhn]# spacewalk-report errata-list
advisory,type,cve,synopsis,systems_affected
[root@rhn]# 


That would be another way to verify the status of a disconnected
satellite.

--- Additional comment from tao on 2010-03-30 15:14:56 EDT ---

I don't see how to do this in the WebUI either.

What I'd like to do is

- save the "Full Software Channel List" (don't really need the
"Provider" and "Systems" columns) as a CSV file

- save the "All Errata" page (don't really need the "Systems" column)
as a CSV file

- use saved CSV files to compare channel of content on a connected
satellite (incremental exporter) vs. a disconnected satellite (synced from
the incremental export).

Comment 1 Jan Pazdziora (Red Hat) 2010-08-13 08:25:57 UTC
New errata-list-all report in Spacewalk master, 15da73ea109c45497cda7acbf50c883946e514ec.

Comment 2 Jan Pazdziora (Red Hat) 2010-08-13 08:58:17 UTC
New channels report in Spacewalk master, ed3ab1a59f003e9bb0134c26fc032ad4da32e064.

Comment 3 Jan Pazdziora (Red Hat) 2010-08-16 08:17:03 UTC
Tagged and built as spacewalk-reports-1.2.1-1.

Comment 4 Jan Pazdziora (Red Hat) 2010-08-18 07:58:31 UTC
Updated field names in report channels, a77588b4b3f74224581926a2df51a6f6c534f098 (sadly, wrong bugzilla number in the commit message).

Comment 5 Jan Pazdziora (Red Hat) 2010-08-18 07:58:59 UTC
New report channel-packages 9baf8b5d8d8ff90d3773fb661603b17a5f31172a (sadly, wrong bugzilla number in the commit message).

Comment 6 Jan Pazdziora (Red Hat) 2010-08-18 08:28:00 UTC
Tagged and built as spacewalk-reports-1.2.2-1.

Comment 7 Jan Pazdziora (Red Hat) 2010-09-14 08:16:46 UTC
The package spacewalk-reports-1.2.2-1 is in nightly compose, moving ON_QA.

Comment 8 Martin Minar 2010-09-21 14:30:40 UTC
Verified in today's nightly.

Also verified that bug 634961 is also corrected in this version.