Bug 1433509

Summary: Unable to find hypervisor subscribed to specific pool of subscriptions
Product: Red Hat Satellite Reporter: Prashant Waghmare <pwaghmar>
Component: Subscriptions - virt-whoAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED DUPLICATE QA Contact: Tom McKay <tomckay>
Severity: high Docs Contact: Tom McKay <tomckay>
Priority: unspecified    
Version: 6.2.8CC: aladke, jcallaha, tomckay
Target Milestone: Unspecified   
Target Release: Unused   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-03-22 17:37:09 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:
Attachments:
Description Flags
no associations listed none

Description Prashant Waghmare 2017-03-17 20:10:32 UTC
Description of problem:

Unable to find hypervisor of specific pool of subscriptions

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

Satellite

How reproducible:

Always.

Steps to Reproduce:

1.Login to satellite web-ui => content  => Red hat Subscriptions => Click on "Red Hat Enterprise Linux for Virtual Datacenters with Smart Management, Standard"  4 out of 5 => click on "association" => content hosts" tab

Unable to see hypervisors

Actual results:

No hypervisor lists under content hosts tab.

Expected results:

Should be able to see the hypervisor list consumed by specific subscription.

Additional info:

workaround: Able to identify it using commandline:

# hammer subscription list --organization-id 1 |egrep -v 'Unlimited'|egrep 'UUID|---|Virtual Datacenters'
---|----------------------------------|---------------------------------------------------------------------------------|----------|---------|--------------|-----------|----------|------------------------------|-----------|---------
ID | UUID                             | NAME                                                                            | CONTRACT | ACCOUNT | SUPPORT      | QUANTITY  | CONSUMED | END DATE                     | QUANTITY  | ATTACHED
---|----------------------------------|---------------------------------------------------------------------------------|----------|---------|--------------|-----------|----------|------------------------------|-----------|---------
15 | 8ac35v95g89229d40158762ee90502f0 | Red Hat Enterprise Linux for Virtual Datacenters with Smart Management, Premium | 11122333 | 123456  | Premium      | 5        | 4       | 2017-11-02T03:59:59.000+0000 | 5        | 4      
---|----------------------------------|---------------------------------------------------------------------------------|----------|---------|--------------|-----------|----------|------------------------------|-----------|---------

===========================

# su - postgres

-bash-4.2$ psql -d candlepin -c "select cpe.id as cp_entitlement__id, cpe.pool_id as cp_entitlement__pool_id, cpc.id as cp_consumer__id, cpc.name as cp_consumer__name from cp_entitlement as cpe, cp_consumer as cpc where cpe.pool_id = '8ac18a0c587029d40158762ee90502f0' and cpe.consumer_id = cpc.id"


        cp_entitlement__id        |     cp_entitlement__pool_id      |         cp_consumer__id          |          cp_consumer__name          
----------------------------------+----------------------------------+----------------------------------+-------------------------------------
 8ac18a0c587029d4015876a6970a0532 | 8ac35v95g89229d40158762ee90502f0 | 8ac18a0c581ab26f01581acfaa5a00f8 | example1.redhat.com
 8ac18a0c587029d4015876a6f0fa0564 | 8ac35v95g89229d40158762ee90502f0 | 8ac18a0c581ab26f01581acfcf6c03af | example2.redhat.com
 8ac18a0c587029d4015876310ced039b | 8ac35v95g89229d40158762ee90502f0 | 8ac18a0c581ab26f01581acfb9aa0234 | example3.redhat.com
 8ac18a0c587029d4015876315f0e03cd | 8ac35v95g89229d40158762ee90502f0 | 8ac18a0c581ab26f01581acfad490142 | example4.redhat.com

Comment 1 jcallaha 2017-03-21 19:00:16 UTC
Created attachment 1265191 [details]
no associations listed

Comment 2 jcallaha 2017-03-22 17:37:09 UTC

*** This bug has been marked as a duplicate of bug 1406450 ***