[jira] [Commented] (CLOUDSTACK-5641) Local disk usage on host don't show up in the admin's webui

["Nitin Mehta (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-5641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13856438#comment-13856438 ] 

Nitin Mehta commented on CLOUDSTACK-5641:
-----------------------------------------

This is because in the storage pool view the join is incorrect and doesn't take into account capacity_type = 9 for local storage. 


        `cloud`.`cluster` ON storage_pool.cluster_id = cluster.id
            left join
        `cloud`.`data_center` ON storage_pool.data_center_id = data_center.id
            left join
        `cloud`.`host_pod_ref` ON storage_pool.pod_id = host_pod_ref.id
            left join
        `cloud`.`storage_pool_details` ON storage_pool_details.pool_id = storage_pool.id
            and storage_pool_details.value = 'true'
            left join
        `cloud`.`op_host_capacity` ON storage_pool.id = op_host_capacity.host_id
            and op_host_capacity.capacity_type = 3
            left join
        `cloud`.`async_job` ON async_job.instance_id = storage_pool.id
            and async_job.instance_type = 'StoragePool'
            and async_job.job_status = 0;


> Local disk usage on host don't show up in the admin's webui
> -----------------------------------------------------------
>
>                 Key: CLOUDSTACK-5641
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5641
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>    Affects Versions: 4.2.0
>            Reporter: Nitin Mehta
>
> Local disk usage on host don't show up in the admin's webui.
> I have local storage enabled in the environment. I have VMs on the storage but since upgrading to 4.2 the UI does not show space utilization on the local storage.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)