Hi all dCachers,
I've written a script to pull information about user activities from the
dCache billing database and logs. If you don't feel brave enough to dive
into the database and logs yourself, then it will help you answer the
SSC GGUS tickets.
http://trac.dcache.org/trac.cgi/browser/contributed/trunk/billing-query
You can use it like this:
$ python dcache-billing-query.py -s "2008-01-23 12:00:00" -e "2008-01-24
23:00:00" -i "User DN"
It comes with a -h option for some basic help information. Once you have
pinned down the start and end times to within a day of each other, run
the script again with the -l option to query the billing log files (with
out -l it just looks at the billing database). You'll need pygreSQL
installed [1] so that the script can connect to the database.
Cheers,
Greig
[1] http://www.pygresql.org/
|