Advanced Custom Alert

Hi Everyone,

Has anyone here created a custom alert for a specific port group status? Specifically, I’m looking to trigger an alert when all ports within a portgroup are down. But I’m struggling to achieve this. I have heard that it can be done by counting down port within the port group, but since I’m not experienced in SQL, I don’t know how to do that. I would really be grateful if somebody who has done this before could share their sql query with me. Thanks in advance