Physical Inventory Count – includes model and EOL/EOS.
from view_dbb_compute_v2 dc
where lower(dc.device_type) = 'physical'
and dc.hardware_model is not null
group by 1,2
order by 1 nulls first,2
Gives the ability to manage your assets to see if you have any missing data.