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