From c5002b34c1701bc8c31464067e6c90742582d863 Mon Sep 17 00:00:00 2001 From: Ted Trask Date: Fri, 9 Oct 2009 09:32:29 +0000 Subject: Bumped to 0.4.8 --- weblog-adhocquery-html.lsp | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'weblog-adhocquery-html.lsp') diff --git a/weblog-adhocquery-html.lsp b/weblog-adhocquery-html.lsp index 17ee021..002dba3 100644 --- a/weblog-adhocquery-html.lsp +++ b/weblog-adhocquery-html.lsp @@ -50,10 +50,11 @@ This form accepts a Postgresql SELECT statement and displays the results. Exampl
  • This statement limits the above statement to a specific range of dates (just yesterday)
    SELECT clientuserid, sum(bytes) AS total FROM pubweblog WHERE logdatetime >= 'yesterday' and logdatetime < 'today' GROUP BY clientuserid ORDER BY total DESC
  • This statement will return the number of requests and blocks by hour over the course of the entire usage history
    SELECT extract(hour from date) AS hour, sum(numrequest) AS numrequest, sum(numblock) AS numblock FROM usagestat GROUP BY extract(hour from date) ORDER BY hour
    +The available database tables and descriptions are listed below. <% displayformitem(form.value.query, "query") %> <% displayformend(form) %> -

    The available database tables and descriptions are as follows

    +

    Available Database Tables

    PubWeblog and PubBlocklog

    These tables contain the combined squid access log and dansguardian log for every access and blocked access respectively. The definition of the table is as follows: -- cgit v1.2.3