Bug 1792174 - [RFE] Subscription report template
Summary: [RFE] Subscription report template
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Reporting
Version: 6.6.0
Hardware: All
OS: All
unspecified
medium
Target Milestone: 6.8.0
Assignee: satellite6-bugs
QA Contact: Lukáš Hellebrandt
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2020-01-17 08:26 UTC by Waldirio M Pinheiro
Modified: 2020-10-27 13:00 UTC (History)
4 users (show)

Fixed In Version: foreman-2.1.0-0
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2020-10-27 13:00:04 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 28786 0 Normal Closed RFE - Subscription report template 2020-10-28 17:23:03 UTC
Red Hat Product Errata RHSA-2020:4366 0 None None None 2020-10-27 13:00:17 UTC

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


Note You need to log in before you can comment on or make changes to this bug.