Bug 1464224 - [RFE] make the "Type" of a subscription a searchable unit
[RFE] make the "Type" of a subscription a searchable unit
Status: VERIFIED
Product: Red Hat Satellite 6
Classification: Red Hat
Component: WebUI (Show other bugs)
6.2.10
Unspecified Unspecified
medium Severity high (vote)
: GA
: --
Assigned To: Tomer Brisker
Sanket Jagtap
: FutureFeature, Triaged
Depends On:
Blocks: 1353215
  Show dependency treegraph
 
Reported: 2017-06-22 13:10 EDT by Andrea Perotti
Modified: 2017-11-29 10:26 EST (History)
8 users (show)

See Also:
Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed:
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
Type Scoped search UI (51.36 KB, image/png)
2017-11-29 10:25 EST, Sanket Jagtap
no flags Details


External Trackers
Tracker ID Priority Status Summary Last Updated
Foreman Issue Tracker 20979 None None None 2017-09-18 07:56 EDT

  None (edit)
Description Andrea Perotti 2017-06-22 13:10:36 EDT
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.
Comment 2 Tomer Brisker 2017-09-18 07:56:26 EDT
Created redmine issue http://projects.theforeman.org/issues/20979 from this bug
Comment 4 pm-sat@redhat.com 2017-09-18 08:17:03 EDT
Upstream bug assigned to tbrisker@redhat.com
Comment 5 pm-sat@redhat.com 2017-09-18 08:17:06 EDT
Upstream bug assigned to tbrisker@redhat.com
Comment 6 pm-sat@redhat.com 2017-09-18 12:17:02 EDT
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20979 has been resolved.
Comment 15 Sanket Jagtap 2017-11-29 10:24:53 EST
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       
---|----------------------------------|-------------------------------------------------------------------------|---------|----------|---------|---------|---------------------|-----------|---------
Comment 16 Sanket Jagtap 2017-11-29 10:25 EST
Created attachment 1360405 [details]
Type Scoped search UI

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