EPDM - SQL Query for Drawing Tree

Before I try and go off and reinvent the wheel I thought I would reach out and see if anyone has a SQL query, procedure, function, etc  that could be used to get a top level SolidWorks drawing or Assembly and provide a drawing tree.

An output of all the lower multi-level childrens drawing links and just the slddrw files?

  • GOTCHA - The file type settings in EPDM for slddrw has the option turned off to show as sub-parents...

I know this is possible in the API, but I don't want a program.  I want a report....

Suggestions, I looked through KB and forums and haven't found anything yet.

Thanks

SolidworksSolidworks Pdm enterprise Pdm