打开一个新的查询选项卡,选择 vRA 数据库,并通过运行以下查询记录旧代理和新代理的代理 ID 和名称:
select AgentID, AgentName from Agent
要确认代理 ID 名称(应是旧代理的 ID),请运行以下查询:
Select DataCollectionStatusID, AgentID, EntityID from DataCollectionStatus Where EntityID IN (Select HostID from Host h join ManagementEndpoints e on h.ManagementEndpointID = e.ManagementEndpointID Where e.ManagementEndpointName = '@endpointName')
要记录ProvisioningAgentID,请运行以下查询:
Select HostID, HostName, HostUniqueID, ProvisioningAgentID from Host h join ManagementEndpoints e on h.ManagementEndpointID = e.ManagementEndpointID Where e.ManagementEndpointName = '@endpointName’
注意:代理 ID 可能不会对于所有主机都相同,且/或也有可能是不同于步骤 3b 中查询结果的值。
如果上述查询证明记录中存在不一致的代理名称,请完成以下步骤:
使用相应的代理 ID 更新主机:
Update host set ProvisioningAgentID = '{{desired-agent-id-from-step-1}}' Where HostID IN (Select HostID from Host h join ManagementEndpoints e on h.ManagementEndpointID = e.ManagementEndpointID Where e.ManagementEndpointName = '@endpointName')
Delete DataCollectionStatus Where EntityID IN (Select HostID from Host h join ManagementEndpoints e on h.ManagementEndpointID = e.ManagementEndpointID Where e.ManagementEndpointName = '@endpointName’)