select * from calls
where calldate > '7/1/99' and username = 'user'
order by calldate
Instead of the '*' in the first line you can specifiy the fields you would
like to see, i.e. calldate, acctstatustype, AcctTerminateCause, username,
framedaddress, etc
blessings,
Stephen
> -----Original Message-----
> From: radiusnt-request@iea-software.com
> [mailto:radiusnt-request@iea-software.com]On Behalf Of Carlos Diaz,
> System Eng.
> Sent: Wednesday, November 03, 1999 2:25 PM
> To: radiusnt@iea-software.com
> Subject: RE: [RadiusNT] IP usage logging
>
>
> Do you have any statement to select that data from the database?
>
>
>
>
> -----Original Message-----
> From: radiusnt-request@iea-software.com
> [mailto:radiusnt-request@iea-software.com]On Behalf Of Stephen Johnson
> Sent: Wednesday, November 03, 1999 8:07 AM
> To: radiusnt@iea-software.com
> Subject: RE: [RadiusNT] IP usage logging
>
>
> It's already in the calls table ;-)
>
>
> Stephen
>
> > -----Original Message-----
> > From: radiusnt-request@iea-software.com
> > [mailto:radiusnt-request@iea-software.com]On Behalf Of Carlos Diaz,
> > System Eng.
> > Sent: Wednesday, November 03, 1999 1:04 PM
> > To: radiusnt@iea-software.com
> > Subject: [RadiusNT] IP usage logging
> >
> >
> > Hi guys!
> >
> > Two simple question.
> >
> > 1. Can I set RadiusNT 2.5 to log the Ip Address usage?
> > 2. How?
> >
> > Example: Lets said that I will like to know who was using IP
> > 0.0.0.100 last
> > Monday at 03:00am
> >
> > Thanks!
> >
> > Carlos
> >
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
> >
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart