Tracking movement of VMs across physical hosts in VMWare

[Pkumar628]

Hello,

I'm looking for logs that show when VMs in VMware move from HOSTA to HOSTB. Is Flexera able to track this change if there is a vCenter connection in place? If yes, would there be a central location for a log file/report that has this information?

Thanks

[mfranz]

You should be able to get this detail from the history tab of each virtual machine. If you're running FNMS on-prem, you can get it from the ComplianceHistory table directly.

[Pkumar628]

Thank you for the prompt response. Is there a central repository from where we can fetch the history of all VMs to track this migration? We are looking at a large environment of 30k+ VMware VMs.

We do have FNMS on-prem - Could you please help us with relevant steps/fields where we can find the VM migration information.

[mfranz · Accepted solution]

SELECT TOP 1000
	cc.ComputerName VirtualMachine
	,ch.OldValue MovedFrom
	,ch.NewValue MovedTo
	,ch.HistoryDate
FROM ComplianceHistory ch
JOIN ComplianceComputer cc
	ON ch.ComplianceComputerID = cc.ComplianceComputerID
WHERE ch.ComplianceComputerID IS NOT NULL
	AND ch.FieldName = 'HostComplianceComputer'
ORDER BY ch.ComplianceHistoryID DESC

Be aware that this data is not live, but based on your FNMS processes, including your vCenter inventory rules & inventory import. Therefore this will usually be updated once a day only.