Cita:
Iniciado por SirDuque 
Cual es la query y que es el resultado, para ver como ayudarte!
Esta es la query
SELECT n_servicegroups.alias, n_servicegroups.servicegroup_object_id, MAX( n_servicestatus.current_state )'
FROM n_servicegroups, n_servicestatus, n_servicegroup_members
WHERE n_servicegroups.servicegroup_id = n_servicegroup_members.servicegroup_id
AND n_servicegroup_members.service_object_id = n_servicestatus.service_object_id
GROUP BY n_servicegroups.alias
HAVING MAX( n_servicestatus.current_state ) <3
ORDER BY MAX( n_servicestatus.current_state ) DESC, n_servicegroups.alias ASC
Gracias!!!