Description of problem: In environments with hundred of hypervisors, thousand of VM and vDC subscriptions, for each VM a subscription of type "ENTITLEMENT_DERIVED" is created. Accessing to https://$sat6/subscriptions in this condition, makes very hard to extract useful data given the "Type" of the subscription is not a unit that can be used to filter or sort.
Created redmine issue http://projects.theforeman.org/issues/20979 from this bug
Upstream bug assigned to tbrisker
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20979 has been resolved.
Satellite 6.3.0 snap 26 Exposed through Web UI , PFA API: curl -u admin:changeme -X GET --header "Accept:application/json,version=2" "https://sat/katello/api/subscriptions?search=type=ENTITLEMENT_DERIVED" --insecure | json_reformat % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 2123 0 2123 0 0 807 0 --:--:-- 0:00:02 --:--:-- 807 { "organization": { }, "total": 17, "subtotal": 3, "page": 1, "per_page": 20, "error": null, "search": "type=ENTITLEMENT_DERIVED", "sort": { "by": "cp_id", "order": "asc" }, "results": [ { "id": 33, "cp_id": 00000000000000, "subscription_id": 20, "name": "Red Hat Enterprise Linux Server, Premium (8 sockets) (Unlimited guests)", "start_date": "2016-08-04 04:00:00 UTC", "end_date": "2022-01-01 04:59:59 UTC", "available": -1, "quantity": -1, "consumed": 0, "account_number": 00000000000000, "contract_number": 00000000000000, "support_level": "Premium", "product_id": "00000", "sockets": 8, "cores": null, "ram": null, "instance_multiplier": 1, "stacking_id": null, "multi_entitlement": null, "type": "ENTITLEMENT_DERIVED", "product_name": "Red Hat Enterprise Linux Server, Premium (8 sockets) (Unlimited guests)", "unmapped_guest": false, "virt_only": true, "virt_who": true }, { "id": 36, "cp_id": 00000000000000, "subscription_id": 20, "name": "Red Hat Enterprise Linux Server, Premium (8 sockets) (Unlimited guests)", "start_date": "2016-08-04 04:00:00 UTC", "end_date": "2022-01-01 04:59:59 UTC", "available": -1, "quantity": -1, "consumed": 0, "account_number": 00000000000000, "contract_number": 00000000000000, "support_level": "Premium", "product_id": "sockets": 8, "cores": null, "ram": null, "instance_multiplier": 1, "stacking_id": null, "multi_entitlement": null, "type": "ENTITLEMENT_DERIVED", "product_name": "Red Hat Enterprise Linux Server, Premium (8 sockets) (Unlimited guests)", "unmapped_guest": false, "virt_only": true, "virt_who": true } ] } Hammer hammer> subscription list --search type=ENTITLEMENT_DERIVED --organization-id 1 ---|----------------------------------|-------------------------------------------------------------------------|---------|----------|---------|---------|---------------------|-----------|--------- ID | UUID | NAME | TYPE | CONTRACT | ACCOUNT | SUPPORT | END DATE | QUANTITY | CONSUMED ---|----------------------------------|-------------------------------------------------------------------------|---------|----------|---------|---------|---------------------|-----------|--------- 33 | 00000000000000000000000000000000 | Red Hat Enterprise Linux Server, Premium (8 sockets) (Unlimited guests) | Virtual | 11045754 | 477931 | Premium | 2022/01/01 04:59:59 | Unlimited | 0 36 | 00000000000000000000000000000000 | Red Hat Enterprise Linux Server, Premium (8 sockets) (Unlimited guests) | Virtual | 11045754 | 477931 | Premium | 2022/01/01 04:59:59 | Unlimited | 0 37 | 00000000000000000000000000000000 | Red Hat Enterprise Linux Server, Premium (8 sockets) (Unlimited guests) | Virtual | 11045754 | 477931 | Premium | 2022/01/01 04:59:59 | Unlimited | 0 ---|----------------------------------|-------------------------------------------------------------------------|---------|----------|---------|---------|---------------------|-----------|---------
Created attachment 1360405 [details] Type Scoped search UI
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. https://access.redhat.com/errata/RHSA-2018:0336