Report of all unused objects

[bahrom58]

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.

[bahrom58 · Accepted solution]

That worked. Thanks Jerome!

[jhorber]

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