CSI Installed Base Extended Attributes Summary

Description
Categories: Enginatics, Toolkit - Operations
Repository: Github Columns: Count, Attribute Level, Attribute Name, Description, Attribute Category ...
Master data report of extended Installed Base attribute levels and names
select
count(*) count,
initcap(ciea.attribute_level) attribute_level,
ciea.attribute_name,
ciea.description,
ciea.attribute_category
from
csi_iea_values civ,
csi_i_extended_attribs ciea
where
ciea.attribute_id=civ.attribute_id
group by
ciea.attribute_level,
ciea.attribute_name,
ciea.description,
ciea.attribute_category
order by
count(*) desc