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?
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
RemoveVMFromVCAC52.zip
RemoveVMfromvCAC6.0.zip
RemoveVMfromVCAC61.zip
RemoveVMfromVCAC62_v1.zip
RemoveVMFromVRMV40.zip
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?
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...
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
RemoveVMFromVCAC52.zip
RemoveVMfromvCAC6.0.zip
RemoveVMfromVCAC61.zip
RemoveVMfromVCAC62_v1.zip
RemoveVMFromVRMV40.zip