How to query the Database logs and create summary reports and/or charts of them?
The Views Watchdog module might be useful.


  The Views Watchdog module extends the Views module and allows to
  create customized lists (pages, blocks, feeds) of watchdog entries.


Combine it with the Charts module and a bit of custom code and you should be able to get a wide array of reports.