On Mon, 28 Jul 2003 11:37 pm, Oliver Graf wrote: > 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).
Yes. I always either verify that the db is correct or import from script using h323detail2db.pl in the src/billing directory which I wrote for this purpose.. -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
