login 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>