Custom alert help - Trigger when X interfaces on single node goes down

Hi All,

I was hoping to get some help - as I understand there is no way at the moment for solarwinds to Alert when a number of port channel member goes down natively. I was hoping there is a way it can be done through sql/swql? (not so great when it come to queries Disappointed)

Any help would be greatly appreciated

i.e

Node Caption contains "%Test%"

Interface name contains "%port-channel-member0%"

if

1 - link go down = low Alert
2 - link go down = medium Alert
3-4 link go down = high Alert