I'm finding this a very useful extension, for all sorts of reasons. What I'd like to do is get the last month's worth of access log in a flat file so I can do my own analysis. I'm running on a hosted server, which times out if the access log program runs too long. I can get there by going through it 500 lines at a time, but it's quite a tedious solution.
I've looked at the database table:
Naturally, these keys are binary, pointing to the actual name, action and so forth, and the timestamps are encoded. I don't know enough SQL (I don't know any, to be more precise), to know how to set up a query to return what turns up in the access log.
So, I was just wondering, if there was a handy sql query lying about that I could use - if so, I'd be most grateful.
The other solution would be to mess about with the access log program - it might not be too difficult if all I did was to put in a sleep every hundred or so queries to stop the server stopping it, but I think that a SQL query would be a more sensible solution if I had it.
Any other suggestions gratefully received.