These queries may be executed at the database level using a query tool.
Model count
select count(C_Name) AS 'no. models'
from m9catalog
where C_Type = 'D'
Model names and version count
Select m9cg.C_Name 'Model',
count(m9cg2.C_Name) AS 'no. versions'
From m9catalog m9cg,
m9catalog m9cg2
where m9cg.C_Type = 'D'
and m9cg2.C_Type = 'V'
and m9cg2.C_Container_Id = m9cg.C_Id
GROUP BY m9cg.C_Name
Comments
0 comments
Please sign in to leave a comment.