I have a Plone site that has a lot of data in it and I would like to query the database for usage statistics; ie How many cals with more than 1 entries, how many blogs per group with entries after a given date, etc.

I want to run the script from the command line... something like so:

bin/instance [script name]

I've been googling for a while now but can't find out how to do this.

Also, can anybody provide some help on how to get user specific information. Information like, last logged in, items created.

Thanks! Eric