An answer to if N nodes go down in a group

[cabsandy]

Hi there
First post, so hopefully wont annoy too many people.

I’ve been playing about with LibreNMS for a few weeks now-and it looks very good. However, and I have tried this on a few other NMS (PRTG being one)-and I have a need to send an alarm (I’m keeping it basic with email) of only say 4 nodes in a group of 10 nodes go down. I searched through the forum and found this

Alert if n devices in a group is down

Hi, I’m wondering if there is any way to create an alert (or chain alerts?) so LibreNMS notifies me if n number of devices in a group is down? Say I have a group of 4 similar devices, and I want to raise a special alert if 2 or more are marked as down. Is this possible? Thanks.

I’m also new to MySQL but keen to learn -is there anyone who could give me some help with the (advanced?) SQL that would help me achieve this-I have tried, honestly, through the GUI (after getting my head round the CLI for the underlying database as well).

Thanks in advance

cabs