An answer to if N nodes go down in a group

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

I’m also new to MySQL but keen to learn :slight_smile: -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