Hello Authur, I think if you use the example schemas that we provide in the goodies directory it will do what you want. In those examples, each accounting record has the NAS-IP-Address stored in the NASIDENTIFIER column. You could then use that column to select the accounting records for each NAS. Hope that helps. Cheers. On Jun 20, 9:44am, Authur Lin wrote: > Subject: (RADIATOR) Give me some suggestions > I am trying to transfer the conventional radius (use text file to record > users) to Radiator system. I have several NAS devices including Cisco > AS5300 and Xyplex Terminal Server in several location. Now I use central > authentication for all users in different location. In conventional > radius, it will keep several detail files according to the IP address of > NAS device (for example, NAS1 will keep detail file in a directory > a.b.c.d, NAS2 will keep detail file in a directory e.f.g.h) . If I want > to use SQL server for authentication, accounting and billing, please > give me some suggestions how do I to design database schema for > accounting (according to date, NAS device,....) so that I can bill all > users according their usage(time or packages). > > > > > Authur > > > === > Archive at http://www.thesite.com.au/~radiator/ > To unsubscribe, email '[EMAIL PROTECTED]' with > 'unsubscribe radiator' in the body of the message. >-- End of excerpt from Authur Lin -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.