Removing an IPv4 address from a defined static pool in VMware vRealize Automation

Products

• VMware Aria Suite

Issue/Introduction

This article provides steps on removing an IPv4 address from a defined static pool in VMware vRealize Automation.

In VMware vRealize Automation, you have defined a static IP address pool and deployed one or more virtual machines using this IP address pool. There are one or more IP addresses that belong to this pool you do not want allocated in the future.

Environment

VMware vRealize Automation 7.1.x
VMware vRealize Automation 7.2.x
VMware vRealize Automation 6.2.x
VMware vRealize Automation 7.0.x

Resolution

To remove an IPv4 address from a defined static pool:
 

Note: Ensure that a backup of the vRealize Automation database is taken prior to performing these steps.

1. Log in to your SQL server and launch the MS SQL Server Management studio.
2. Connect to your vRealize Automation database.
3. Expand the Tables directory tree.
4. Right-click dbo.StaticIPv4Address and click Select Top 1000 Rows.
5. In the right-hand pane, you should see a table representing your static IP pool.
   
   Note: The column StaticIPv4AddressState represents whether vRealize Automation has already provisioned this IP address or not.
   1 = Unallocated, 0 = Allocated
    
6. To mark an unallocated IP address as allocated and which virtual machine uses is, run this SQL query, changing ‘VM_name’ to the name of the VM that the IP is applied to and changing 'Enter IP Address Here' to the IP address you wish to remove from the pool.
   
   UPDATE StaticIPv4Address SET StaticIPv4AddressState = 0, VirtualMachineID = (SELECT VirtualMachineID FROM VirtualMachine WHERE VirtualMachineName = 'VM_name') WHERE IPv4Address = ‘Enter_IP_Address_Here’
   
   For example:
   UPDATE StaticIPv4Address SET StaticIPv4AddressState = 0, VirtualMachineID = (SELECT VirtualMachineID FROM VirtualMachine WHERE VirtualMachineName = 'VMtest001') WHERE IPv4Address = '192.168.100.1'