getting stats from drupal watchdog

alan dawson — Sat, 17 Nov 2007 06:33:32 +0000

here are some simple examples of some SQL to get information from watchdog, using sql string matching...

SELECT message,timestamp FROM watchdog WHERE message LIKE '%daws%' 
AND type='user' AND message NOT LIKE 'notify%';

you get the idea...
to see how many password resets I'd asked for I'd do

SELECT hostname,message,timestamp FROM watchdog 
WHERE message LIKE '%Password%' and type='user' 
AND message LIKE '%ligh%';

SELECT COUNT(*) FROM watchdog 
WHERE message LIKE '%Password%' and type='user' AND MESSAGE LIKE '%dawson%';

Technology and Social Action - getting stats from drupal watchdog - Comments