[Koha] Statistic with Koha

LAURENT Henri-Damien henridamien.laurent at biblibre.com
Fri Jul 22 21:50:01 NZST 2011


Le 22/07/2011 11:27, schwitzd a écrit :
> Hi
> 
> I'm trying to create some statistics, for example I want to have the number
> of the search done today, I wrote this query.
> select count(time) from search_history where year(time) = year(curdate())
> AND month(time) = month(curdate()) AND DAY(time) = day(curdate());
> 
> My problem is... if the user do the login in the opac and then do a search
> the table search_history is updated but if the user do a search without
> login nothing is written in the database.
> 
> Any idea?
> 
grep search zebra.logs |wc-l
should do the trick.
-- 
Henri-Damien LAURENT


More information about the Koha mailing list