I have looked and looked for documentation regarding stats / watchdog and come up empty. I have complained a lot about the lack of interface for the watchdog entries and log stats in Drupal. I think I would like to try and develop some kind of module, but the developer info online is no help (other than standard format), and I need to know how to get started.

I could probably surf the db tables, but basically I want to know where the log info is stored, and give me some sample code for custom queries into that data.

I think watchdog sucks because it only shows so many lines per page, and sorting is limited to column heading or one item on dropdown. I want a config page with some checkboxes and date ranges, so I can setup exactly what I want to view. I want to customize a page with aggregate numbers for types by weeks, months, etc., and charts and graphs. I want to email reports to myself, and I want fine-grained control over what I get.

I want to do this for the watchdog info, and also each of the log types. Has anyone done this to any degree? Any pointers for getting started?

I have written PHP, Perl/CGI, etc, in the past.

Comments

Brian@brianpuccio.net’s picture

By developer info, are you speaking of DrupalDocs? If you haven't checked that out, look inside the module you are looking at, more specifically, the watchdog_overview function.

jt6919’s picture

No, I looked in the Handbooks developer info. Thanks for the link, I did not find this info in Drupal.org anywhere.

Also, anyone have any sample code they wish to share?? Anyone tried anything like this before?