[RadiusNT] RadCheckPort

Mike@NetDotCom ( (no email) )
Wed, 8 Mar 2000 11:05:30 -0500

Would it be possible to put a wildcard for the 'nasid' in the RadCheckPort
just like for the port. We are currently using a wildcard for the port.

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 '' 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 =
AND (sa.Port=@nasport or sa.Port is NULL)
AND sa.AccountType = @at


For more information about this list (including removal) go to: