[VMware Horizon] Desktop Composer Fault: Virtual Machine with Input Specification already exists

README.md

1. Use composer database
2. set @vmname

• https://kb.vmware.com/s/article/2015112

DeleteVMrecord.sql

DECLARE @vmname  VARCHAR(20)
set @vmname='VMXX-001'
delete FROM [vdi7s_composer].[dbo].[SVI_VM_NAME] where NAME=@vmname
delete FROM [vdi7s_composer].[dbo].[SVI_COMPUTER_NAME] where NAME=@vmname
delete  FROM [vdi7s_composer].[dbo].[SVI_TASK_STATE] where SIM_CLONE_ID=(select id FROM [vdi7s_composer].[dbo].[SVI_SIM_CLONE] where VM_NAME=@vmname)
delete 
  FROM [vdi7s_composer].[dbo].[SVI_SC_PDISK_INFO] where PARENT_ID=(select id FROM [vdi7s_composer].[dbo].[SVI_SIM_CLONE] where VM_NAME=@vmname)
delete 
  FROM [vdi7s_composer].[dbo].[SVI_SC_BASE_DISK_KEYS] where PARENT_ID=(select id FROM [vdi7s_composer].[dbo].[SVI_SIM_CLONE] where VM_NAME=@vmname)
delete 
  FROM [vdi7s_composer].[dbo].[SVI_SIM_CLONE] where VM_NAME=@vmname