Bug 1792174

Summary: [RFE] Subscription report template
Product: Red Hat Satellite Reporter: Waldirio M Pinheiro <wpinheir>
Component: ReportingAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED ERRATA QA Contact: Lukáš Hellebrandt <lhellebr>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.6.0CC: bkearney, egolov, mhulan, oprazak
Target Milestone: 6.8.0Keywords: FutureFeature, Triaged
Target Release: Unused   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: foreman-2.1.0-0 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2020-10-27 13:00:04 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:
Embargoed:

Description Waldirio M Pinheiro 2020-01-17 08:26:12 UTC 
Description of problem:
Currently, we can see the output as below
---
ID,Name,Available,Quantity,SKU,Contract number
6,Employee SKU,10,10,ES0113909,10169621
8,Employee SKU,-1,-1,ES0113909,10169621
9,ant-product,-1,-1,794374057445,""
10,Employee SKU,5,5,ES0113909,11986131
---

However, will be really interesting add some fields as below:
- Start Date
- End Date
- Account #
- Contract #
- Type
- Organization


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

How reproducible:
100%

Steps to Reproduce:
1. WebUI - Monitor - Report Templates - Subscriptions - Generate
2.
3.

Actual results:
---
ID,Name,Available,Quantity,SKU,Contract number
6,Employee SKU,10,10,ES0113909,10169621
8,Employee SKU,-1,-1,ES0113909,10169621
9,ant-product,-1,-1,794374057445,""
10,Employee SKU,5,5,ES0113909,11986131
---

Expected results:
---
ID,Name,Available,Quantity,SKU,Contract number,Account number,Start date,End date,Organization
6,Employee SKU,10,10,ES0113909,10169621,540155,2013-04-23 21:00:00 -0700,2021-12-31 20:59:59 -0800,org_label_here
8,Employee SKU,-1,-1,ES0113909,10169621,540155,2013-04-23 21:00:00 -0700,2021-12-31 20:59:59 -0800,org_label_here
9,ant-product,-1,-1,794374057445,"","",2019-12-23 13:08:59 -0800,2049-12-15 13:08:59 -0800,org_label_here
10,Employee SKU,5,5,ES0113909,11986131,540155,2019-08-12 21:00:00 -0700,2021-12-31 20:59:59 -0800,org_label_here
---

Additional info:
Comment 3 Bryan Kearney 2020-03-16 12:06:36 UTC 
Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/28786 has been resolved.
Comment 4 Lukáš Hellebrandt 2020-06-09 12:54:11 UTC 
Verified with Sat 6.8 snap 3.0.

Generated "Subscriptions - General Report" report now contains the following columns: ID,Name,Available,Quantity,SKU,Contract number,Account number,Start date,End date,Organization
Comment 7 errata-xmlrpc 2020-10-27 13:00:04 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 (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