3.18.5. ClearNasQuery Previous topic Parent topic Child topic Next topic

This SQL statement is executed whenever a NAS reboot is detected. It is expected to clear the details of all sessions on that NAS from the SQL database. Special formatting characters may be used (the %{attribute} ones are probably the most useful). %0 is replaced by the NAS identifier. If ClearNasQuery is defined as an empty string, then the query will not be executed. SQL bind variables are supported.
It defaults to:
delete from RADONLINE where NASIDENTIFIER='%0'