UPDM: count the number of diagrams

[EAaaarrggh]

Greetings,
My customer would like to know how many diagrams of each type exist in our UPDM model.

Is there a script I could run to calculate and display this automatically - even better, show the count history and diagram status?
Is there an attribute of a UPDM diagram which contains diagram type e.g. OV-2?
Being SQL-ignorant I'm struggling with this.

Thanks
John

[qwerty]

Nice name xD

Just create this SQL search:

Code: [Select]

select Diagram_Type, count(*)  from t_diagram group by Diagram_Type
q.