I discovered a nice graphics package called graphviz a couple of months ago. It's been useful to visualize the structure of some configuration on recent projects.


For example, the balance hierarchy in GDO can get complex, and visualizing it using diagrams created by graphviz has allowed us to verify the layout.


Using the SQL query against the GDO database:

        select '"' + pointName + '" -> "' + childName + '" [dir=back]' 
        from pointReferView 
        where pointTypeName = 'Actuals'

and inserting the result in to a graphviz file

 digraph pointHierarchy { 
          -- insert result here --- 

gives a nice visualization of this simple distribution network.


Graphviz has a ton of options to add more information to the visualization.