- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Forum
- :
- Tracking movement of VMs across physical hosts in VMWare
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
