excluding a Virtual machine from monitoring on a SWQL Alert

Question

i am using one of the canned VM alerts. "VMs with Old Snapshots" and i would like to exclude one VM Guest from the monitoring of this alert. here is what i have now.

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

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

what would i add to exclude a single VM guest from this alert.

Thank you for your help.

njoylif · Accepted Answer

try adding at end of where clause: and virtualmachines.displayname NOT like '%<servername to exlude>%' edit - added NOT like (to exclude)

excluding a Virtual machine from monitoring on a SWQL Alert

Top Replies