cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Tracking movement of VMs across physical hosts in VMWare

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

(1) 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.

View solution in original post

(3) Replies
mfranz
By Level 17 Champion
Level 17 Champion

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.

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.

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.