Previous page Section 3.41.20. GroupMembershipQueryParam Section 3.41.21. AcctTotalQuery (593 / 1693)   Table of Contents Section 3.41.22. AcctTotalSinceQuery Next page

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
Previous page Section 3.41.20. GroupMembershipQueryParam Section 3.41.21. AcctTotalQuery (593 / 1693)   Table of Contents Section 3.41.22. AcctTotalSinceQuery Next page