How to generate a report of current reports

We have over 1200 reports.  I would like to generated a list of all the reports we have.  I read somewhere you can't do this in Sugar reports but it can be done with an SQL statement.  How can this be done. thanks