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
what would i add to exclude a single VM guest from this alert.
Thank you for your help.
try adding at end of where clause:
and virtualmachines.displayname NOT like '%<servername to exlude>%'
edit - added NOT like (to exclude)