I've been spinning my wheels on this one for a while and thought I'd ask the community for some assistance/direction. On my dashboard, I am displaying a list of VMs with current snapshots. The problem is the data seems to lag behind 2-3 days behind. I am wondering what mechanism updates the database it pulls this information from (Orion.VIM)? I've tried polling the servers to force the data to update and that has been a dead end. I was thinking of gathering the data as a powershell script as an alternative as I know that data will be up to date, but I'd rather not put in the cycles if I can get this to work.
This is the database query being used for the dashboard display:
SELECT vm.Name, ToLocal(vm.OldestSnapshotDate) as LocalOldestSnapShotDate
FROM Orion.VIM.VirtualMachines vm
WHERE DayDiff(vm.OldestSnapshotDate, getUtcDate()) > 0
Appreciate your time and insight!
