I've been able to setup Asterisk to log CDRs to a MySQL database using the ODBC option. The challenge I am currently facing is that only calls with the disposition ANSWERED are logged. NO ANSWER, BUSY and other calls are not logged in the database though I see the status from the logs.
I place the calls using ARI which connects to a stasis app when the call is answered.
How do I ensure asterisk logs all calls to the database, irrespective of the call status.
I am using Asterisk 16.2.1 and added a additional field to the cdr table.