cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

VMAN Alert VMs with Old Snapshots

Jump to solution

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

 

0 Kudos
1 Solution
Level 14

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 

View solution in original post

2 Replies
Level 14

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 

View solution in original post

Thank You, that worked like a charm.

0 Kudos