Skip to main content

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

https://knowledge.broadcom.com/external/article/343000/removing-an-ipv4-address-from-a-defined.html

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'

Comments

Post a Comment

Popular posts from this blog

  Issue with Aria Automation Custom form Multi Value Picker and Data Grid https://knowledge.broadcom.com/external/article?articleNumber=345960 Products VMware Aria Suite Issue/Introduction Symptoms: Getting  error " Expected Type String but was Object ", w hen trying to use Complex Types in MultiValue Picker on the Aria for Automation Custom Form. Environment VMware vRealize Automation 8.x Cause This issue has been identified where the problem appears when a single column Multi Value Picker or Data Grid is used. Resolution This is a known issue. There is a workaround.  Workaround: As a workaround, try adding one empty column in the Multivalue picker without filling the options. So we can add one more column without filling the value which will be hidden(there is a button in the designer page that will hide the column). This way the end user will receive the same view.  
Post a Comment
Read more

57 Tips Every Admin Should Know

Active Directory 1. To quickly list all the groups in your domain, with members, run this command: dsquery group -limit 0 | dsget group -members –expand 2. To find all users whose accounts are set to have a non-expiring password, run this command: dsquery * domainroot -filter “(&(objectcategory=person)(objectclass=user)(lockoutTime=*))” -limit 0 3. To list all the FSMO role holders in your forest, run this command: netdom query fsmo 4. To refresh group policy settings, run this command: gpupdate 5. To check Active Directory replication on a domain controller, run this command: repadmin /replsummary 6. To force replication from a domain controller without having to go through to Active Directory Sites and Services, run this command: repadmin /syncall 7. To see what server authenticated you (or if you logged on with cached credentials) you can run either of these commands: set l echo %logonserver% 8. To see what account you are logged on as, run this command: ...
Post a Comment
Read more
  The Guardrails of Automation VMware Cloud Foundation (VCF) 9.0 has redefined private cloud automation. With full-stack automation powered by Ansible and orchestrated through vRealize Orchestrator (vRO), and version-controlled deployments driven by GitOps and CI/CD pipelines, teams can build infrastructure faster than ever. But automation without guardrails is a recipe for risk Enter RBAC and policy enforcement. This third and final installment in our automation series focuses on how to secure and govern multi-tenant environments in VCF 9.0 with role-based access control (RBAC) and layered identity management. VCF’s IAM Foundation VCF 9.x integrates tightly with enterprise identity providers, enabling organizations to define and assign roles using existing Active Directory (AD) groups. With its persona-based access model, administrators can enforce strict boundaries across compute, storage, and networking resources: Personas : Global Admin, Tenant Admin, Contributor, Viewer Projec...
Post a Comment
Read more