VMware Cloud Community
christianpg
Enthusiast
Enthusiast
Jump to solution

vCAC 5.2: How to manually delete (SQL) a VM from vCAC?

Hi Community

Once in a while a VM get stuck in the internal logic of vCAC and it would be easier to just remove it manually than to figure out what the heck happened.

In some cases the DisposeVM workflow is stuck as well...

Does anyone have a nice SQL example for destroying a VM from the vCAC database?

Tags (3)
Reply
0 Kudos
1 Solution

Accepted Solutions
christianpg
Enthusiast
Enthusiast
Jump to solution

Update: since this thread was started, the mentioned KB 2077281 has been updated.

It is now updated and contains stored procedures for several versions of vCAC/vRA

VMware KB: Removing a virtual machine from Management in VMware vRealize Automation or vCloud Automa...

RemoveVMFromVCAC52.zip

RemoveVMfromvCAC6.0.zip

RemoveVMfromVCAC61.zip

RemoveVMfromVCAC62_v1.zip

RemoveVMFromVRMV40.zip

View solution in original post

Reply
0 Kudos
3 Replies
christianpg
Enthusiast
Enthusiast
Jump to solution

Any stored procedures like VMware KB: Removing a virtual machine from Management in VMware vRealize Automation Suite 6.0.x available for 5.2 or do I need to back-port it myself?

Reply
0 Kudos
christianpg
Enthusiast
Enthusiast
Jump to solution

Anyone?

Any big schema changes in MS SQL from 5.2 to 6 that makes usp_RemoveVMFromVCAC.sql from mentioned link use-less?

All mentioned DB tables sound familiar...

Reply
0 Kudos
christianpg
Enthusiast
Enthusiast
Jump to solution

Update: since this thread was started, the mentioned KB 2077281 has been updated.

It is now updated and contains stored procedures for several versions of vCAC/vRA

VMware KB: Removing a virtual machine from Management in VMware vRealize Automation or vCloud Automa...

RemoveVMFromVCAC52.zip

RemoveVMfromvCAC6.0.zip

RemoveVMfromVCAC61.zip

RemoveVMfromVCAC62_v1.zip

RemoveVMFromVRMV40.zip

Reply
0 Kudos