cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Report of all unused objects

bahrom58
Contributor

Does anyone know of an easy way to get a global report showing all the objects that are not used in any diagrams?   

 

We are using MEGA 2009 SP5. I am trying to clean up the clutter that's been created and accumulated over the past 3 years by my predecessor.

 

Appreciate any suggestions.

 

 

2 Replies

That worked. Thanks Jerome!

 

jhorber
MEGA
MEGA

Hello bahrom58

 

If I understand, you want to build a report that lists the objects that are not displayed in diagrams

The target objects could be unused object (to be verified).

 

Building such a report requires some work in version MEGA 2009.

Indeed there is not a single link (MetaAssociation) to test the present in diagrams for all Metaclass.

 

There is a generic metamodel but it is used in certain types of diagram only

For this metamodel, you can use the following query

Select [Element in Diagram] Where [Containing Diagram] Null

 

For most types of diagram, you can create one ERQL query by Metaclass (or at least for the main MetaClass) 

Ex:

Select [Org-Unit] Where [Diagram] Null

Select [Applicartion] Where [Diagram] Null

...

 

Once you ave identified, the queries, you can build a report template that runs theses queries with a formatter

Jerome