3.117.1. InsertQuery Previous topic Parent topic Child topic Next topic

This optional parameter specifies the SQL query to be used for each log. It can include special formatting characters. For more information, see Section 3.1. Special characters. %0 to %23 are replaced by statistics data. For more information, see Section 3.116.2. Format.
The default is an SQL query something like this, which is compatible with the example RADSTATSLOG table created by the example database schemas in goodies.
insert into RADSTATSLOG (TIME_STAMP, TYPE, IDENTIFER, <symbolic
stats names>) values (9999999, 'objectname', 'objectidentifier',
<statistics values>)
Here is an example that only logs a subset of the statistics:
InsertQuery insert into MYTABLE (TIME_STAMP, TYPE, ID, \
      RESPONSETIME) values (%0, %1, %2, %23)