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
‎May 25, 2022 08:36 AM
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.
‎May 25, 2022 09:51 AM
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.
‎May 25, 2022 09:23 AM
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.
‎May 25, 2022 09:31 AM
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.
‎May 25, 2022 09:51 AM