Hello,
We are periodically exporting the CDR of our Call Manager to a SFTP site as a text file. Then we import this text file to our database. We use this database for reports and we would like to know the number of abandoned calls destined for a specific hunt pilot number. For this we use the following query logic:
We search for rows matching 'huntPilotDN' to our hunt pilot number. Then if the 'duration' field is 0, we take this call as an abandoned one.
Is this the right approach for this task or should we look for different or additional fields? Any help is greatly appreciated.
Call Manager version: 11.5
Regards,
