Have a look at the usage Online hours data table as it should record a NAS identifier which you can use in a where clause to limit the result set.
Regards, Suneel. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Melvin C. etheridge Sent: Thursday, May 05, 2005 1:54 AM To: [email protected] Subject: [Rodopi] another sql script And what about one that just does dialup connections not dsl/pppoa connections? Thanks, Mel ----- Original Message ----- From: "John Hokenson" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, May 04, 2005 6:35 PM Subject: [Rodopi] another sql script > Just disallow concurrent connections...... > > J > ----- Original Message ----- > From: "Fred" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, May 04, 2005 2:40 PM > Subject: [Rodopi] another sql script > > >> How about an SQL script to check the online usage table for accounts >> which >> show connections from 2 or more different telephone numbers? We are >> using >> Vircom Radius and Rodopi 5.1. I can tweak the script to make it work, >> just >> don't know an easy way to accomplish this. >> Thanks, >> >> Frederic Tarasevicius >> Internet Information Services, Inc. >> http://www.i-is.com/ >> 810-794-4400 >> >> >> >> >> --------------------- >> To Leave the Rodopi mail list send a message to >> [EMAIL PROTECTED] >> with the word LEAVE as the message body. >> >> Please also visit the Rodopi FAQ at http://www.rodopi-faq.com >> --------------------- > > > > > --------------------- > To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] > with the word LEAVE as the message body. > > Please also visit the Rodopi FAQ at http://www.rodopi-faq.com > --------------------- > > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.11.3 - Release Date: 5/3/2005 > > --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com --------------------- --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com ---------------------
