Device Count by Device Type

Returns a count of devices grouped by device type — useful for getting a quick summary of your device mix.

Click to expand the code block

select
     dc.device_type
     ,count(1)                "count"
from view_dbb_compute_v2 dc
group by 1
order by "count" desc