Get the abandoned call list

[kaioml]

How to get the list of abandoned calls ?

I already have the queue_log table being fed, but I don't see the option in qpanel to view the list of abandoned calls.

Is there really such an option in qpanel?

cat /opt/qpanel/config.ini

[manager]
user = qpanel
password = qpanel
port = 5038
host = localhost

[general]
debug = False
port = 5000
host = 0.0.0.0
interval = 5
language = en
check_upgrade = True
show_service_level = False

[rename]
[users]
[user_queues]
[reset_stats]

[queue_log]
database = asteriskcdrdb
table = queue_log
host = localhost
user = username
password = password
port = 3306
adapter = mysql

MariaDB [asteriskcdrdb]> select * from queue_log;
+----+----------------------------+---------------+-----------+-------+---------------+------+-------+---------------+-------+-------+-------+
| id | time | callid | queuename | agent | event | data | data1 | data2 | data3 | data4 | data5 |
+----+----------------------------+---------------+-----------+-------+---------------+------+-------+---------------+-------+-------+-------+
| 1 | 2022.... | NONE | NONE | NONE | CONFIGRELOAD | | | | | | |
| 2 | 2022... | 1651531787.10 | 9 | NONE | DID | | | | | | |
| 3 | 2022... | 1651531787.10 | 9 | NONE | ENTERQUEUE | | | 2002 | 1 | | |
| 4 | 2022... | 1651531787.10 | 9 | NONE | ABANDON | | 1 | 1 | 3 | | |
| 5 | 2022... | 1651531933.12 | 9 | NONE | DID | | | | | | |
| 6 | 2022... | 1651531933.12 | 9 | NONE | ENTERQUEUE | | | 2002 | 1 | | |
| 7 | 2022... | 1651531933.12 | 9 | 2001 | CONNECT | | 3 | 1651531934.13 | 3 | | |
| 8 | 2022... | 1651531933.12 | 9 | 2001 | COMPLETEAGENT | | 3 | 6 | 1 | | |
+----+----------------------------+---------------+-----------+-------+---------------+------+-------+---------------+-------+-------+-------+

I use issabel pbx.

Could anyone help?

[roramirez]

it could be a cool feature. Are you interesting on develop it?