What problem would you like to solve? Please describe:
As the manager of a team, it's important to uncover services that aren't being monitored or don't have engineers actively on-call. Specifically, users would like an easy way to identify:

1. All services with no integration keys.
2. All services with an empty escalation policy.
3. All services with only Slack notifications as their escalation policy.

Describe the solution you'd like:
A clear and concise solution to retrieve the aforementioned information, possibly through additional built-in queries, reports, or UI functionality in the GoAlert application.

Additional context:
The main purpose is to highlight services with missing or unreliable escalation policies to improve monitoring and on-call management for teams. This will help users pinpoint areas that need attention and optimize overall alerting processes within their organization.

select s.name, s.id from services s
where s.id not in (select i.service_id from integration_keys i);

select s.name as service_name, s.id as service_id, e.name as policy_name, s.escalation_policy_id as policy_id from services s
inner join escalation_policies e on s.escalation_policy_id = e.id
inner join escalation_policy_steps es on e.id = es.escalation_policy_id
where es.id not in (select ea.escalation_policy_step_id from escalation_policy_actions ea);

select s.name as service_name, s.id as service_id, e.name as policy_name, s.escalation_policy_id as policy_id from services s
inner join escalation_policies e on s.escalation_policy_id = e.id
inner join escalation_policy_steps es on e.id = es.escalation_policy_id
inner join escalation_policy_actions ea on es.id = ea.escalation_policy_step_id
where ea.channel_id is not null;