On Mon, Jul 28, 2003 at 11:16:17PM +0300, Peter Nixon wrote: > On Mon July 28 2003 22:59, Oliver Graf wrote: > > On Mon, Jul 28, 2003 at 09:30:01PM +0300, Peter Nixon wrote: > > > On Thu July 24 2003 23:13, Daniel Destro do Carmo wrote: > > > > How can I select (using SQL) just the unique records to see > > > > how many calls and to calculate the total time each user has > > > > used??? > > > > > > Postgres has a UNIQUE keyword, not sure about MySQL.. > > > > DISTINCT? > > > > http://www.mysql.com/doc/en/SELECT.html > > Yep. thats it :-)
BTW: I never log into sql. I use detail logs and sort out duplicates later with a really smart python script. It also does start/stop accounting (don't trust Session-Time) cause it's really hard to prove that the NAS equipment is 10^-6 seconds accurate (there is some regulation in germany which says that you either have to prove this accuracy in your NAS equipment, or you do start/stop accounting on the aaa with half a second accuracy). Oliver. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
