3.42.9. PortAccessQuery Previous topic Parent topic Child topic Next topic

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