Device Count by Service Level

Returns a count of devices grouped by service level, useful for understanding how your assets are distributed across production, non-production, and other environments.

Click to expand the code block

select
     lower(dc.service_level)
     ,count(1) as "count"
from view_dbb_compute_v2 dc
group by 1
order by "count" desc