VMAN Alert VMs with Old Snapshots

[arnabmk]

Hi,

I have an alert defined in VMAN for alerting VMAN Alert VMs with Old Snapshots. Is it possible to restrict the alert, if the VM is not a managed node in Orion?

SWQL Alert

SELECT VirtualMachines.Uri, VirtualMachines.DisplayName FROM Orion.VIM.VirtualMachines AS VirtualMachines

where DayDiff(virtualmachines.OldestSnapshotDate,getdate())>2

Thanks

[yaquaholic · Accepted solution]

Hi arnabmk,

Try something like the following SWQL: 

SELECT v.Uri,
v.DisplayName
FROM Orion.VIM.VirtualMachines AS v
WHERE DayDiff(v.OldestSnapshotDate,getdate())>2
AND v.Node.Unmanaged = 0

I hope it helps,
yaquaholic 

[arnabmk]

Thank You, that worked like a charm.