citrix更换vcenter后所需改动几张表

 

 

 

 SSL证书指纹须大写
UPDATE [HostingUnitServiceSchema].[HypervisorConnectionSSLThumbprint]
   SET [SSLThumbprint] = 'FCB40A45F27EB391ADB13F34A625968735CEDDCB'
 WHERE Id=1

网络用到3张表
[HostingUnitServiceSchema].[HostingUnit]
[HostingUnitServiceSchema].[HostingUnitNetwork]
[DesktopUpdateManagerSchema].[ProvisioningSchemeNetworkMap]

存储用到2张表
[HostingUnitServiceSchema].[HostingUnitStorageLocation]
[DesktopUpdateManagerSchema].[ProvisioningSchemeVMImageLocation]

主机
[DesktopUpdateManagerSchema].[ProvisionedVirtualMachine]          --置备虚拟桌面
[DesktopUpdateManagerSchema].[ProvisioningSchemeVMImageHistory] 

UPDATE [DesktopUpdateManagerSchema].[ProvisionedVirtualMachine]
   SET [AssignedImage] = 'Version=2,LsiLogicScsi,1000,group-v4783,[SmartVsan] b709195f-83ce-cf95-cb21-f4e9d4ae0810/win7x86_mcs1113-baseDisk-datastore-105.vmdk,resgroup-5496,Vmfs'
      ,[BootedImage] = 'Version=2,LsiLogicScsi,1000,group-v4783,[SmartVsan] b709195f-83ce-cf95-cb21-f4e9d4ae0810/win7x86_mcs1113-baseDisk-datastore-105.vmdk,resgroup-5496,Vmfs'
      ,[StorageId] = 'datastore-105'
      ,[IdentityDiskStorage] = 'datastore-105'

UPDATE [DesktopUpdateManagerSchema].[ProvisionedVirtualMachine]
   Set [IdentityDiskId]= replace (IdentityDiskId,'group-v6866','group-v4783')

UPDATE [DesktopUpdateManagerSchema].[ProvisionedVirtualMachine]
   Set [IdentityDiskId]= replace (IdentityDiskId,'resgroup-138','resgroup-13')

//主机生成用的内容
UPDATE [DesktopUpdateManagerSchema].[ProvisioningScheme]
   SET [VMMetadata] = '生成的内容'
 WHERE [ProvisioningSchemeUid] = '54c1a430-b91b-4942-92aa-405e550828e0'

HostingUnitServiceSchema.HypervisorConnectionAddress

另外主机故障查询以下几张表
ADIdentitySchema.Identity
ADIdentitySchema.IdentityCollection
chb_Config.Workers
chb_Config.Desktops
chb_State.Workers