Description of problem: The "Entitlements" report has a column named "Subscription Quantity" which currently displays how many subscriptions exist in the pool (pool.quantity). Customer would like the report to display the number of subscriptions that the host is consuming. For 2 socket servers that may by 1 sub, for 4 socket servers that may be 2 subs, etc... Version-Release number of selected component (if applicable): foreman-1.24.1.21-1.el7sat tfm-rubygem-katello-3.14.0.20-1.el7sat How reproducible: Always Steps to Reproduce: 1. Run the Entitlements report in Satellite 6.7 2. Observe column "Subscription Quantity" 3. Actual results: Column "Subscription Quantity" displays the number of subscriptions available in the pool. Expected results: Column "Subscription Quantity" or some other column displays the number of subscriptions attached to the host. Alternatively a macro providing the number of subscriptions attached to the host is made available for customer to use it in a custom clone of the Entitlements report. Additional info:
Created redmine issue https://projects.theforeman.org/issues/29838 from this bug
*** Bug 1861849 has been marked as a duplicate of this bug. ***
Moving this bug to POST for triage into Satellite since the upstream issue https://projects.theforeman.org/issues/29838 has been resolved.
*** Satellite 6.8.6 Hotfix Available *** 1) Download tfm-rubygem-katello-3.16.0.26-2.HFRHBZ1835690.el7sat.noarch.rpm from this bugzilla to your Satellite 2) stop services: satellite-maintain service stop 3) Install: rpm -Uvh tfm-rubygem-katello-3.16.0.26-2.HFRHBZ1835690.el7sat.noarch.rpm 4) restart: satellite-maintain service start 5) resume operations
Created attachment 1775730 [details] tfm-rubygem-katello-3.16.0.26-2.HFRHBZ1835690.el7sat.noarch.rpm
Verified with Sat 6.9.3 snap 2.0. Imported a manifest, created a custom product, added all of those to the activation key, registered a host using that activation key. Then WebUI -> Report Templates -> "Subscription - Entitlement report" -> Generate -> Submit. The resulting file contains column "Subscriptions Consumed" (next to "Subscription Quantity") which contains a number of those subscriptions consumed by all hosts together. The report takes into account all the subscriptions, including custom ones, which can be told apart by having Contract column empty.
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 (Satellite 6.9.3 Async Bug Fix Update), 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/RHBA-2021:2636