You need to add an Entry into the Servers Table for Each server
you have. Then you need to add an entry into the ServerPorts table for
each port of each server. There, the SQL will look something like this:
INSERT Into Servers(Server, IPAddress, Secret)
VALUES('nas1', '10.0.0.1', 'secret1')
GO
Select ServerID From Servers Where IPAddress = '10.0.0.1'
GO
INSERT Into ServerPorts(ServerID, Port) VALUES(1, 1)
INSERT Into ServerPorts(ServerID, Port) VALUES(1, 2)
INSERT Into ServerPorts(ServerID, Port) VALUES(1, 3)
INSERT Into ServerPorts(ServerID, Port) VALUES(1, 4)
INSERT Into ServerPorts(ServerID, Port) VALUES(1, 5)
.....
INSERT Into ServerPorts(ServerID, Port) VALUES(1, 46)
INSERT Into ServerPorts(ServerID, Port) VALUES(1, 47)
GO
This is assuming that the select statement returned one for the ServerID.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com