You can use the script below to find how many systems are defaulted to which service level
select b.service_level_code as Service Level,
b.inactive as "Service Level Code Inactive Y/N", --b.service_level_id,
count(a.service_level_id) as "Number of Systems with Service Level Code", b.description
from ar_customer_system a, sv_service_level b
where a.service_level_id=b.service_level_id and a.Customer_Id > 1
group by b.service_level_code, b.inactive, a.service_level_id, b.service_level_id, b.description
order by b.service_level_code
