Thanks to this thread I made a small tweak to this custom SWQL based alert - NPM Alert based on percentage of group members status?
This will look at member status as the criteria to focus on any status of a member other than "green" (1)
join (select count(Name) as [Total], containerid FROM Orion.ContainerMembers group by containerid) t on t.containerid=Groups.containerid
join (select count(Name) as [Down], containerid FROM Orion.ContainerMembers where status!=1 group by containerid) d on d.containerid=Groups.containerid
where (d.Down*100/t.Total)>50 -- change 50 to whatever percent of the nodes you want to trigger on
