rendered paste bodylogin as: root
root@216.16.236.117's password:
Last login: Thu Mar 27 22:59:48 2008 from cpe0026540def64-cm000f9fa61036.cpe.net.cable.rogers.com
[root@fireworx ~]# mysql scopserv
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 67724 to server version: 4.1.20-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select count(*) from ivr inner join cdr on cdr.uniqueid = ivr.uniqueid;
+----------+
| count(*) |
+----------+
| 337241 |
+----------+
1 row in set (5.94 sec)
mysql> select count(*) from queue_log inner join cdr on cdr.uniqueid = queue_log.callid;
+----------+
| count(*) |
+----------+
| 489088 |
+----------+
1 row in set (15.01 sec)
mysql> select queuename,count(*) from queue_log inner join cdr on cdr.uniqueid = queue_log.callid group by queuename;
+-------------------------------------+----------+
| queuename | count(*) |
+-------------------------------------+----------+
| crafword-alberta-english | 6 |
| crafword-baycol-english | 5 |
| crafword-baycol-french | 2 |
| crafword-bse-english | 3 |
| crafword-bse-french | 2 |
| crafword-irs-english | 6 |
| crafword-servier-eng | 1 |
| crafword-servier-english | 1 |
| crafword-servier-fre | 1 |
| crafword-serzone-english | 3 |
| crafword-serzone-french | 1 |
| crafword-tiffany-english | 3 |
| crafword-walkerton-english | 4 |
| crafword-whistler-english | 3 |
| default-alberta | 6482 |
| default-bausch&lomb | 4579 |
| default-bausch_lomb | 350 |
| default-baycol-english | 6189 |
| default-baycol-french | 1050 |
| default-behr | 6390 |
| default-bse-english | 6197 |
| default-bse-french | 1050 |
| default-cep-resp-ctr-abor-2 | 304 |
| default-cep_resp_ctr_abor_1 | 749 |
| default-cep_resp_ctr_abor_1_weekend | 60 |
| default-cep_resp_ctr_eng_1 | 90827 |
| default-cep_resp_ctr_eng_1_weekend | 6471 |
| default-cep_resp_ctr_eng_2 | 50340 |
| default-cep_resp_ctr_fre_1 | 8195 |
| default-cep_resp_ctr_fre_1_weekend | 835 |
| default-cep_resp_ctr_fre_2 | 4607 |
| default-cibc | 685 |
| default-cibc_english_level_1 | 9200 |
| default-cibc_english_level_2 | 5081 |
| default-cibc_french_level_1 | 4475 |
| default-cibc_french_level_2 | 2950 |
| default-genericovfl | 491 |
| default-helpdesk-english | 6155 |
| default-irs-cds2 | 3495 |
| default-irs-cep-cds-appeals-level1 | 9625 |
| default-irs-cep-cds-appeals-level2 | 20 |
| default-irs-cep-e-appeals-level1 | 6235 |
| default-irs-cep-e-appeals-level2 | 3542 |
| default-irs-cep-f-appeals-level1 | 6117 |
| default-irs-cep-f-appeals-level2 | 3542 |
| default-irs-cpe-cds-appeals-level1 | 2542 |
| default-irs-cpe-e-appeals-level2 | 2545 |
| default-irs-cpe-f-appeals-level2 | 2542 |
| default-irs-cree_denee_saulteaux | 4522 |
| default-irs-english | 13998 |
| default-irs-french | 1206 |
| default-irs-inuktitut | 4 |
| default-irs-new-english | 95886 |
| default-irs-new-english2 | 11227 |
| default-irs-new-french | 4507 |
| default-irs-new-french2 | 3006 |
| default-irs-other | 35 |
| default-irscepappealseng | 56 |
| default-kpmg | 885 |
| default-kpmg_english_level_1 | 7114 |
| default-kpmg_english_level_2 | 4583 |
| default-kpmg_french_level_1 | 2539 |
| default-kpmg_french_level_2 | 2199 |
| default-moneymart | 5099 |
| default-pre&posthepc | 4597 |
| default-pre_posthepc | 713 |
| default-royaltech | 9761 |
| default-servier-eng | 6189 |
| default-servier-fre | 1049 |
| default-serzone-english | 6231 |
| default-serzone-french | 1276 |
| default-serzone2-english | 2365 |
| default-serzone2-french | 958 |
| default-testqueue1 | 290 |
| default-tiffany | 6340 |
| default-walkerton | 6550 |
| default-whistler | 33 |
| NONE | 21918 |
+-------------------------------------+----------+
78 rows in set (29.19 sec)
mysql> select context,count(*) from ivr inner join cdr on cdr.uniqueid = ivr.uniqueid group by context;
+----------------------------------------------------+----------+
| context | count(*) |
+----------------------------------------------------+----------+
| default-aa-albertaenglishqueuepatience1vmail | 1 |
| default-aa-baycol | 87 |
| default-aa-bse | 96 |
| default-aa-cepaborqueuepatience1vmail | 357 |
| default-aa-cepenglishqueuepatience1vmail | 20234 |
| default-aa-cepenglishqueuepatience1vmailwknd | 1 |
| default-aa-cepfrenchqueuepatience1vmail | 2844 |
| default-aa-cepfrenchqueuepatience1vmailwknd | 1 |
| default-aa-cep_resp_ctr_aa1 | 96718 |
| default-aa-cep_resp_ctr_aa1_weekend | 4283 |
| default-aa-cep_resp_ctr_abor_aa2 | 265 |
| default-aa-cep_resp_ctr_afthrs_menu | 1566 |
| default-aa-cep_resp_ctr_eng_aa2 | 34365 |
| default-aa-cep_resp_ctr_fre_aa2 | 3468 |
| default-aa-cibcenglishqueuepatience1vmail | 1 |
| default-aa-cibcfrenchqueuepatience1vmail | 2 |
| default-aa-cibc_aa_2_english | 375 |
| default-aa-cibc_aa_2_french | 639 |
| default-aa-cibc_afterhours_menu | 259 |
| default-aa-cibc_main_menu | 5151 |
| default-aa-crawford_admin | 12659 |
| default-aa-irs | 51 |
| default-aa-irs2_cds_level2 | 168 |
| default-aa-irs2_cds_level3 | 52 |
| default-aa-irs2_cds_level4 | 2 |
| default-aa-irs2_e_level2 | 10534 |
| default-aa-irs2_e_level3 | 4115 |
| default-aa-irs2_e_level4 | 1300 |
| default-aa-irs2_f_level2 | 243 |
| default-aa-irs2_f_level3 | 2138 |
| default-aa-irs2_f_level4 | 17 |
| default-aa-irs2_main | 71724 |
| default-aa-irs3_cds_level2 | 494 |
| default-aa-irs3_e_level2 | 52843 |
| default-aa-irs3_f_level2 | 3107 |
| default-aa-irsenglishqueuepatience1vmail | 47 |
| default-aa-irsfrenchqueuepatience1vmail | 7 |
| default-aa-irs_cep_appeals_aa1 | 132 |
| default-aa-irs_cpe_appeals_aa1 | 56 |
| default-aa-irs_cpe_e_appeals_aa2 | 2 |
| default-aa-irs_info | 2400 |
| default-aa-kpmgenglishqueuepatience1vmail | 5 |
| default-aa-kpmgfrenchqueuepatience1vmail | 11 |
| default-aa-kpmg_aa_2_english | 162 |
| default-aa-kpmg_aa_2_french | 91 |
| default-aa-kpmg_afterhours_menu | 85 |
| default-aa-kpmg_main_menu | 2468 |
| default-aa-servier | 51 |
| default-aa-serzone | 655 |
| default-aa-serzone2_e_level2 | 24 |
| default-aa-serzone2_f_level2 | 222 |
| default-aa-serzone_afterhours | 16 |
| default-aa-serzone_new | 620 |
| default-application-acd-cep_resp_ctr_abor_1 | 1 |
| default-application-acd-cep_resp_ctr_eng_1 | 16 |
| default-application-acd-cep_resp_ctr_eng_1_weekend | 3 |
| default-application-acd-cep_resp_ctr_fre_1 | 2 |
| default-application-acd-cibc_english_level_1 | 1 |
| default-application-acd-cibc_french_level_1 | 1 |
| default-application-acd-irs-new-english | 7 |
| default-application-acd-kpmg_english_level_1 | 3 |
| default-application-acd-kpmg_french_level_1 | 3 |
+----------------------------------------------------+----------+
62 rows in set (13.98 sec)
mysql>