3.41.21. AcctTotalQuery Previous topic Parent topic Child topic Next topic

This optional parameter defines an SQL query which will be used to determine the total of all session times for a given user. Special characters are supported. %0 is replaced by the user name being checked. It is expected to return a single field containing the total session time in seconds.
It is used to get a count for the following check items:
  • Max-All-Session
    SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName=%0