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

Tracking movement of VMs across physical hosts in VMWare

Jump to solution

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
mfranz
Level 16 Champion
Level 16 Champion
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.

Softline Group is Europe's leading independent expert in Software Asset Management.

View solution in original post

3 Replies
mfranz
Level 16 Champion
Level 16 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.

Softline Group is Europe's leading independent expert in Software Asset Management.

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
Level 16 Champion
Level 16 Champion
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.

Softline Group is Europe's leading independent expert in Software Asset Management.