Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Need help with SWQL to limit Out of Box alert regarding snapshots

Need help adjusting the Out of Box alert for VMs with Old Snapshots. We have a view environment that I do not want included for alerting.

I do not know SQL or SWQL, but it looks like I need to exclude the Cluster using vim_cluster.name value, just have no idea where or how to implement it

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

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

Find more posts tagged with

Accepted answers

Seashore

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

INNER JOIN Orion.VIM.Hosts H ON VirtualMachines.Hostid=H.HostID
INNER JOIN Orion.VIM.Clusters C ON H.ClusterID=C.ClusterID
where
DayDiff(virtualmachines.OldestSnapshotDate,getdate())>14
AND C.Name <>'NameofClusterNotToInclude'

Using a SWQL custom alert on VirtualMachines. Add the bold part to the edit'able part of the query and change to your clustername.

Hope it works!

All comments

Seashore

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

Using a SWQL custom alert on VirtualMachines. Add the bold part to the edit'able part of the query and change to your clustername.

Hope it works!

crebel

Thank you so much. Worked on the first try