Removing a Orphaned Virtual Machine from vRealize Automation

**** ATTENTION !!! ****
**** Please be sure to BACKUP any related databases

 

The following steps provide information on removing virtual machines from VMWare vRealize Automation (vRA).

These steps are to be used when the following conditions exist:

• A virtual machine that is being managed without being deleted from the endpoint.
• You want to manually remove the machine from the endpoint.

 

vRA Application Steps:

Log into vRA – https://vcac.yourdomain.tld using your-domain\*your-user-id*

1. Click the Infrastructure Tab
2. Click Machines > Reserved Machines
3. Search for Service Name (e.g. VRA-FAQ360)
4. Delete the associated service

SQL Database Steps:

1. Connect to SQL Database Server: VRA-SQL
2. In “Object Explorer” window, Locate database vCAC
3. Backup the vCAC database
4. Expand the vCAC database
5. Under Programmability > Stored Procedures, locate ‘dbo.usp_RemoveVMFromVCAC’
6. Execute Procedure and apply ID of the Multi-Machine Service (e.g. VRA-FAQ360)
7. Repeat this step for each instance

Notes:

The store procedure may look like the following:

USE [vCAC]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[usp_RemoveVMFromVCAC]
@MachineName = N’VRA-FAQ360′

SELECT ‘Return Value’ = @return_value

GO