Delete logs after (days) - This is the number of days that the log files will be kept on the Axon server. This applies to standard logs, call history, and SIP logs (when enabled), but does not apply to ODBC logs.

Advanced SIP Tracing

Log all SIP messages - Check this box to record all SIP messages in the log.

Log all RTP (audio) packets - Check this box to record all RTP packet's time, payload type, and source/destination to the log.

ODBC Logging

Log every call in an ODBC database - Axon automatically logs all phone calls to a monthly CSV file ("YYYY-MM Phone Log.csv", where YYYY is the 4-digit year and MM is the 2-digit month), but in some cases it may be better to record this to a database for use with real-time reporting or to integrate the information into existing business systems. If this is needed then enable this option and configure the settings for your ODBC data source.

ODBC DSN - This is the System DSN where you would like to log calls. Axon requires a System DSN for logging, and will not accept User DSNs, File DSNs or connection strings.

Username - This is the user that will log into the database.

Password - This is the password for the database user.

SQL Command - This is the template for the command that will insert the call information into the database. This will need to be a valid SQL statement for the database you are using. Call variables are represented in the template enclosed in percent (%) signs, like %callid%.

Default SQL Statement:

INSERT INTO CallTable (CallDate, CallTime, CallFrom, CallTo, CallDuration) values ('%date%', '%time%', '%from%', '%to%', '%duration%')


Variables

%date% - The date the call was connected (in the format 'YYYY-MM-DD').

%time% - The time the call was connected (24-hour clock, in the format 'HH:MM:SS').

%from% - The extension or external number that placed the call.

%to% - The extension or external number the call was placed to.

%duration% - The duration of the call in seconds.


Note: While SQL is relatively standard, some databases use different rules for column names, quoting, and escape sequences (as well as others). Please be sure to test your command thoroughly outside of Axon if call logging to your database fails.