After using Migrate Storage to move VMs to a different datastore, the space reserved space still showing used in Cloud Director UI

Products

• VMware Cloud Director

Issue/Introduction

• You are looking to find all files on a specific policy.
• After you use Migrate Storage, some files are still there

Environment

VMware Cloud Director 10.5.x and 10.6.x

 

Cause

The requested space is the provisioned storage in use only by VMware Cloud Director Objects on the datastore (ie VM provisioned, snapshots, Catalog Items, NSX Edges, etc.). 

See document View the Datastores and Datastore Clusters on a Provider Virtual Data Center in Your VMware Cloud Director

Resolution

To help find out which objects are using the requested space you can execute the following:

1) From the primary node, connect to the Cloud Director database: sudo -u postgres psql vcloud

2) Run the following query to check the total amount of the reserved space as shown in the UI:

  select sum(storage_used) from dgp_view_scontain_sprofile_req where ds_moref = (select moref from datastore_inv where vc_display_name = '<datastore_name>');

3) Then list the Objects that are using the Reserved space and that can be identified by the name from the output:

   select * from dgp_view_scontain_sprofile_req where ds_moref = (select moref from datastore_inv where vc_display_name = '<datastore name');