[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: ACD report4 8/8, dynamic intervals and accurate rejection algorithm

done:

SQL

+--------------+------------------+------+-----+---------+----------------+
| Field        | Type             | Null | Key | Default | Extra          |
+--------------+------------------+------+-----+---------+----------------+
| id           | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| i_vendor     | int(10) unsigned | YES  |     | NULL    |                |
| pref_billing | varchar(2)       | YES  |     | NULL    |                |
| Tot_Min      | varchar(11)      | YES  |     | 0       |                |
| Nb_Ap        | varchar(11)      | YES  |     | 0       |                |
| Nb_Conv      | varchar(11)      | YES  |     | 0       |                |
| Nb_5         | varchar(11)      | YES  |     | 0       |                |
| Nb_30        | varchar(11)      | YES  |     | 0       |                |
| Nb_0         | varchar(11)      | YES  |     | 0       |                |
| Nb_reject    | varchar(11)      | YES  |     | 0       |                |
| date         | datetime         | YES  |     | NULL    |                |
| ACD          | varchar(5)       | YES  |     | NULL    |                |
| reject       | varchar(5)       | YES  |     | NULL    |                |
| total_calls  | varchar(11)      | YES  |     | 0       |                |
| prefix       | varchar(11)      | YES  |     | NULL    |                |
+--------------+------------------+------+-----+---------+----------------+
Algorithme

Algorithme

 

If [total received] – [rejected] < [target load] * [total received]

Then

Accept the call

Else

Reject the call

End If

Exemple (target load = 0.5)

 

 

Totale Appel traité

Totale Appel rejeté

 

1

0

0

Accepté

2

1

0

Rejeté

3

2

1

Rejeté

4

3

2

Accepté

5

4

2

Rejeté

6

5

3

Accepté

7

6

3

Rejeté

8

7

4

Accepté

9

8

4

Rejeté

10

9

5

Accepté

 

Exécution

 

 

Nov 4 12:36:58 s15293146 /usr/sbin/kamailio[25145]: => ACD: IP Reception = 87.106.213.52 ¦ Ip_Routage = 212.249.15.3

Nov 4 12:36:58 s15293146 /usr/sbin/kamailio[25145]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:36:58 s15293146 /usr/sbin/kamailio[25145]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:36:58 s15293146 /usr/sbin/kamailio[25145]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 0

Nov 4 12:36:58 s15293146 /usr/sbin/kamailio[25145]: => ACD: Target_Load = 50

Nov 4 12:36:58 s15293146 /usr/sbin/kamailio[25145]: => ACD: TOT_Calls = 0 | TOT_Reject = 0

Nov 4 12:36:58 s15293146 /usr/sbin/kamailio[25145]: => ACD: Appel Reussi : 0 < 0

Nov 4 12:36:58 s15293146 /usr/sbin/kamailio[25145]: => ACD: Update Total Calls_Verzon

Nov 4 12:36:58 s15293146 /usr/sbin/kamailio[25145]: => ACD: Traitement Terminé

 

 

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25159]: => ACD: IP Reception = 87.106.213.52 ¦ Ip_Routage = 212.249.15.9

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25159]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25159]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25159]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 1

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25159]: => ACD: Target_Load = 50

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25159]: => ACD: TOT_Calls = 1 | TOT_Reject = 0

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25159]: => ACD: Appel Rejeté : 100 >= 50

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25159]: => ACD: Nb_Reject_Verzon = 0

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25159]: => ACD: Update Total Calls_Verzon

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25159]: => ACD: Traitement Terminé

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25141]: => ACD: IP Reception = 212.227.250.146 ¦ Ip_Routage = 217.168.45.3

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25141]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25141]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25141]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 2

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25141]: => ACD: Target_Load = 0

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25141]: => ACD: TOT_Calls = 2 | TOT_Reject = 1

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25141]: => ACD: Appel Reussi : 100 < 0

Nov 4 12:37:26 s15293146 /usr/sbin/kamailio[25141]: => ACD: Traitement Terminé

 

 

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25149]: => ACD: IP Reception = 87.106.213.52 ¦ Ip_Routage = 212.249.15.9

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25149]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25149]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25149]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 2

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25149]: => ACD: Target_Load = 50

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25149]: => ACD: TOT_Calls = 2 | TOT_Reject = 1

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25149]: => ACD: Appel Rejeté : 100 >= 100

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25149]: => ACD: Nb_Reject_Verzon = 0

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25149]: => ACD: Update Total Calls_Verzon

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25149]: => ACD: Traitement Terminé

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25142]: => ACD: IP Reception = 212.227.250.146 ¦ Ip_Routage = 217.168.45.3

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25142]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25142]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25142]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 3

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25142]: => ACD: Target_Load = 0

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25142]: => ACD: TOT_Calls = 3 | TOT_Reject = 2

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25142]: => ACD: Appel Reussi : 100 < 0

Nov 4 12:38:19 s15293146 /usr/sbin/kamailio[25142]: => ACD: Traitement Terminé

 

 

Nov 4 12:38:34 s15293146 /usr/sbin/kamailio[25157]: => ACD: IP Reception = 87.106.213.52 ¦ Ip_Routage = 212.249.15.9

Nov 4 12:38:34 s15293146 /usr/sbin/kamailio[25157]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:38:34 s15293146 /usr/sbin/kamailio[25157]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:38:34 s15293146 /usr/sbin/kamailio[25157]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 3

Nov 4 12:38:34 s15293146 /usr/sbin/kamailio[25157]: => ACD: Target_Load = 50

Nov 4 12:38:35 s15293146 /usr/sbin/kamailio[25157]: => ACD: TOT_Calls = 3 | TOT_Reject = 2

Nov 4 12:38:35 s15293146 /usr/sbin/kamailio[25157]: => ACD: Appel Reussi : 100 < 150

Nov 4 12:38:35 s15293146 /usr/sbin/kamailio[25157]: => ACD: Update Total Calls_Verzon

Nov 4 12:38:35 s15293146 /usr/sbin/kamailio[25157]: => ACD: Traitement Terminé

 

 

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25145]: => ACD: IP Reception = 87.106.213.52 ¦ Ip_Routage = 212.249.15.3

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25145]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25145]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25145]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 4

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25145]: => ACD: Target_Load = 50

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25145]: => ACD: TOT_Calls = 4 | TOT_Reject = 2

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25145]: => ACD: Appel Rejeté : 200 >= 200

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25145]: => ACD: Nb_Reject_Verzon = 0

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25145]: => ACD: Update Total Calls_Verzon

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25145]: => ACD: Traitement Terminé

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25141]: => ACD: IP Reception = 212.227.250.146 ¦ Ip_Routage = 217.168.45.3

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25141]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25141]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25141]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 5

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25141]: => ACD: Target_Load = 0

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25141]: => ACD: TOT_Calls = 5 | TOT_Reject = 3

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25141]: => ACD: Appel Reussi : 200 < 0

Nov 4 12:39:16 s15293146 /usr/sbin/kamailio[25141]: => ACD: Traitement Terminé

 

 

Nov 4 12:39:28 s15293146 /usr/sbin/kamailio[25149]: => ACD: IP Reception = 87.106.213.52 ¦ Ip_Routage = 212.249.15.9

Nov 4 12:39:28 s15293146 /usr/sbin/kamailio[25149]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:39:28 s15293146 /usr/sbin/kamailio[25149]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:39:28 s15293146 /usr/sbin/kamailio[25149]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 5

Nov 4 12:39:28 s15293146 /usr/sbin/kamailio[25149]: => ACD: Target_Load = 50

Nov 4 12:39:28 s15293146 /usr/sbin/kamailio[25149]: => ACD: TOT_Calls = 5 | TOT_Reject = 3

Nov 4 12:39:28 s15293146 /usr/sbin/kamailio[25149]: => ACD: Appel Reussi : 200 < 250

Nov 4 12:39:28 s15293146 /usr/sbin/kamailio[25149]: => ACD: Update Total Calls_Verzon

Nov 4 12:39:28 s15293146 /usr/sbin/kamailio[25149]: => ACD: Traitement Terminé

 

 

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25159]: => ACD: IP Reception = 87.106.213.52 ¦ Ip_Routage = 212.249.15.3

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25159]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25159]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25159]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 6

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25159]: => ACD: Target_Load = 50

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25159]: => ACD: TOT_Calls = 6 | TOT_Reject = 3

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25159]: => ACD: Appel Rejeté : 300 >= 300

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25159]: => ACD: Nb_Reject_Verzon = 0

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25159]: => ACD: Update Total Calls_Verzon

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25159]: => ACD: Traitement Terminé

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25142]: => ACD: IP Reception = 212.227.250.146 ¦ Ip_Routage = 217.168.45.3

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25142]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25142]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25142]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 7

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25142]: => ACD: Target_Load = 0

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25142]: => ACD: TOT_Calls = 7 | TOT_Reject = 4

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25142]: => ACD: Appel Reussi : 300 < 0

Nov 4 12:39:45 s15293146 /usr/sbin/kamailio[25142]: => ACD: Traitement Terminé

 

 

Nov 4 12:39:55 s15293146 /usr/sbin/kamailio[25149]: => ACD: IP Reception = 87.106.213.52 ¦ Ip_Routage = 212.249.15.3

Nov 4 12:39:55 s15293146 /usr/sbin/kamailio[25149]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:39:55 s15293146 /usr/sbin/kamailio[25149]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:39:55 s15293146 /usr/sbin/kamailio[25149]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 7

Nov 4 12:39:55 s15293146 /usr/sbin/kamailio[25149]: => ACD: Target_Load = 50

Nov 4 12:39:55 s15293146 /usr/sbin/kamailio[25149]: => ACD: TOT_Calls = 7 | TOT_Reject = 4

Nov 4 12:39:55 s15293146 /usr/sbin/kamailio[25149]: => ACD: Appel Reussi : 300 < 350

Nov 4 12:39:55 s15293146 /usr/sbin/kamailio[25149]: => ACD: Update Total Calls_Verzon

Nov 4 12:39:55 s15293146 /usr/sbin/kamailio[25149]: => ACD: Traitement Terminé

 

 

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25145]: => ACD: IP Reception = 87.106.213.52 ¦ Ip_Routage = 212.249.15.9

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25145]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25145]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25145]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 8

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25145]: => ACD: Target_Load = 50

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25145]: => ACD: TOT_Calls = 8 | TOT_Reject = 4

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25145]: => ACD: Appel Rejeté : 400 >= 400

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25145]: => ACD: Nb_Reject_Verzon = 0

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25145]: => ACD: Update Total Calls_Verzon

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25145]: => ACD: Traitement Terminé

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25143]: => ACD: IP Reception = 212.227.250.146 ¦ Ip_Routage = 217.168.45.3

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25143]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25143]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25143]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 9

Nov 4 12:40:00 s15293146 /usr/sbin/kamailio[25143]: => ACD: Target_Load = 0

Nov 4 12:40:01 s15293146 /usr/sbin/kamailio[25143]: => ACD: TOT_Calls = 9 | TOT_Reject = 5

Nov 4 12:40:01 s15293146 /usr/sbin/kamailio[25143]: => ACD: Appel Reussi : 400 < 0

Nov 4 12:40:01 s15293146 /usr/sbin/kamailio[25143]: => ACD: Traitement Terminé

 

 

Nov 4 12:40:05 s15293146 /usr/sbin/kamailio[25149]: => ACD: IP Reception = 87.106.213.52 ¦ Ip_Routage = 212.249.15.9

Nov 4 12:40:05 s15293146 /usr/sbin/kamailio[25149]: => ACD: ACD_Colt = NULL ¦ ACD_Verizon = 8.75

Nov 4 12:40:05 s15293146 /usr/sbin/kamailio[25149]: => ACD: Reject_Colt = 0 ¦ Reject_Verizon = 50

Nov 4 12:40:05 s15293146 /usr/sbin/kamailio[25149]: => ACD: TotalCalls__Colt = 0 ¦ TotalCalls_Verizon = 9

Nov 4 12:40:05 s15293146 /usr/sbin/kamailio[25149]: => ACD: Target_Load = 50

Nov 4 12:40:05 s15293146 /usr/sbin/kamailio[25149]: => ACD: TOT_Calls = 9 | TOT_Reject = 5

Nov 4 12:40:05 s15293146 /usr/sbin/kamailio[25149]: => ACD: Appel Reussi : 400 < 450

Nov 4 12:40:05 s15293146 /usr/sbin/kamailio[25149]: => ACD: Update Total Calls_Verzon

Nov 4 12:40:05 s15293146 /usr/sbin/kamailio[25149]: => ACD: Traitement Terminé

 

 


On 2009-11-03 14:43, Task-By Emin Gabrielyan wrote:
Consider dynamic intervals instead of fixed duration intervals. The interval must not be fixed to 30 minutes but must be minimum X minutes and Y calls.
(more details in the attached DOC file)

Use an accurate algorithm of rejection instead of the random one. This algorithm ensures the exact ratio of the target balance.
(more details in the attached DOC file)

Concerns the ACD based quality routing system
http://unappel.ch/public/091029-ACDstat/
http://switzernet.com/public/091029-ACDstat/

This task is in [routing by ACD 9,23]


Attachment: test ACD.doc
Description: MS-Word document