Section 3.45.9. PortAccessQuery

3.45.9. PortAccessQuery

SQL query used to fetch permitted ports This parameter is preconfigured for Emerald 4, and should not need to be changed. Defaults to:

PortAccessQuery select sa.StartTime, sa.StopTime, \
sa.MaxSessionLength from Servers s, ServerAccess sa, \
AccountTypes at\
where s.IPAddress="%{Client:Name}" \
and s.ServerID = sa.ServerID \
and (sa.Port=%0 or sa.Port=9214328)\
and sa.AccountTypeID=at.AccountTypeID\
and at.AccountType="%1"\
order by sa.Port