Re: [Emerald] Re: Ascend MAX TNT

Dale E. Reed Jr. ( (no email) )
Fri, 19 Feb 1999 10:47:20 -0800

NOC Management wrote:
>
> OK. It worked when I added the port manually in the Server Ports tab.
> But If I have 1000 ports on my Ascends over all. If Emerald will not create the ports , does this mean that I will have to enter the ports manually myself? !!!
> Isn't there any workaround?

You can probably get away with doing in in SQL:

DECLARE @port int, @stop int, @serverid int
Select @port = 0, @stop = 1000, @serverid = 1

WHILE @port <= @stop
BEGIN
INSERT INTO ServerPorts(ServerID, Port) VALUES(@serverid, @port)
select @port = @port +1
END

You will need to change the port/stop/serverid values, but other than
that, its
an easy way to create sequential ports.

-- 

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html