Interface Speed Change Alert for Specific Nodes

qamaralikhan

I want to create an alert for 100 of specific interfaces of switches connected to firewall ,to generate an alert when interface speed has changed. I can do it manually by Event " Speed has Changed" and by adding all the interfaces manually.  

But how can i do it using SQL or SWQL query? Even i am not getting anything to join two tables when i am trying to create "Custom SQL alert"

sum_giais

Is there anything unique in the interface name or alias that could help you identify just these 100 interfaces out from the rest? Otherwise it may be useful to add a particular comment or other/new custom property to these 100 interfaces that can be used for just that purpose.