Reason: We are using a port provider and the requests come from multiple
NAS's and I don't want to list every single (300+) NAS's
Something like below '255.255.255.255' being the wildcard address.
CREATE PROCEDURE RadCheckPort @nasid varchar(16), @nasport integer, @at
varchar(15) AS
Select MaxSessionLength, StartTime, StopTime, CurrTime = (DatePart(Hour,
GetDate()) * 60) + DatePart(Minute, GetDate())
>From Servers s, ServerAccess sa
Where s.ServerID = sa.ServerID
AND (s.IPAddress = @nasid or s.IPAddress = 255.255.255.255)
AND (sa.Port=@nasport or sa.Port is NULL)
AND sa.AccountType = @at
GO
Mike
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart