Storage profiles do not show usage information on VMware Cloud Director provider portal

Products

• VMware Cloud Director

Issue/Introduction

• Several storage policies are shown with "N/A" under Used" and "Provisioned" columns on the VMware Cloud Director provider portal.
  
  
• To review the storage policies on the VMware Cloud Director provider portal:
  
  
  1. From the primary left navigation panel, select Resources, and from the page top navigation bar, select Cloud Resources.
  2. From the secondary left panel, select Provider VDCs.

• From the same page, we can see the storage policies are used by the specified number of Provider VDCs and Organization VDCs, however when opening the storage policy it is not possible to retrieve the Provider VDCs and Organization VDCs names as it is empty.

Environment

VMware Cloud Director 10.x

Resolution

To check which Organization VDC and Provider VDCs are using the storage policy follow the steps below:

1. SSH the VMware Cloud Director primary cell
   
   
2. Connect to the database running the command below:
   sudo -i -u postgres psql vcloud


3. Run below queries to check which Organization  VDCs are still using the policies, taking the name of the affected policies from VMware Cloud Director provider portal, under "Storage policies":
   
   select name from org_prov_vdc where id in(SELECT vdc_id FROM vdc_logical_resource WHERE lr_type = 'STORAGE_CLASS' AND name = '{storage_policy_name}');


4. Run below queries to check which Provider VDCs are still using the policies, taking the name of the affected policies from VMware Cloud Director provider portal, under "Storage policies":
   
   select name from prov_vdc where id in(select prov_vdc_id from org_prov_vdc where id in (SELECT vdc_id FROM vdc_logical_resource WHERE lr_type = 'STORAGE_CLASS' AND name = '{storage_policy_name}'));


5. Once you identify the Organization VDCs and the Provider VDCs using  the affected policies, you can open the tenant portal for the Organization VDCs and reviewing the policy.

 

Additional Information

If you need to delete the storage policy form the Organization  VDCs please refer to the documentation Delete a Storage Policy from an Organization Virtual Data Center

If you need to delete the storage policy form the Provider VDCs please refer to the documentation Delete a VM Storage Policy from a Provider Virtual Data Center