Finding an Organization Virtual Data Center Network associated with a deleted NSX segment

Products

• VMware Cloud Director

Issue/Introduction

Learn how to find Organization Virtual Data Center (Org VDC) Network in VMware Cloud Director (VCD) that is associated with a known NSX segment ID that no longer exists in NSX .

Note: When an NSX segment is deleted directly from NSX, this impacts the functionality of the associated Org VDC network and Third-Party Automation Tools (such as Zerto) can have issues reading the Org VDC networks in VCD.

Environment

VMware Cloud Director 10.6.1.2

VMware NSX-T Data Center

Resolution

To find the concerned Org VDC network, follow the steps below:

1. Log in directly or by using an SSH client to the primary appliance console as root.
2. Connect to the VCD database with the following command:
   
   db
   
   
3. Run the following query to find the associated Org VDC network:
   
   select * from logical_network where rnet_id in (select id from real_network where portgroup_moref = '<segment_id>');


4. Run the following query to find the Organization VDC for the network:
   
   select * from org_prov_vdc where id = '<scope_id from step 3>';
   
   
5. Delete the Org VDC network as per Delete an Organization Virtual Data Center Network in the VMware Cloud Director Tenant Portal.