28/06/2012, 07:51
|
| | | Fecha de Ingreso: julio-2010
Mensajes: 93
Antigüedad: 13 años, 9 meses Puntos: 0 | |
| Respuesta: Mostrar filas con count = 0
Tabla PCO_LOAD
SERVICEID LOADID STATUS DESCRIPTION RDATE RECORDCOUNT PRIORITYTYPE PRIORITYVALUE
2000 227 D SNfebrero23 2012-02-22 19:00:45.827 19998 0 100
2000 228 D SNfebrero24 2012-02-24 16:40:52.937 24963 0 100
2000 229 D SNfebrero25 2012-02-24 16:52:26.703 24993 0 100
Tabla PCO_OUTBOUNDQUEUE
ID SERVICEID NAME PHONE CALLINGHOURS SOURCEID STATUS SCHEDULETYPE SCHEDULEDATE LOADID LASTAGENT LASTQCODE FIRSTHANDLINGDATE LASTHANDLINGDATE DAILYCOUNTER TOTALCOUNTER BUSYSIGNALCOUNTER NOANSWERCOUNTER ANSWERMACHINECOUNTER FAXCOUNTER INVGENREASONCOUNTER PRIORITY CAPTURINGAGENT PHONE1 PHONE2 PHONE3 PHONE4 PHONE5 PHONE6 PHONE7 PHONE8 PHONE9 PHONE10 PHONEDESC1 PHONEDESC2 PHONEDESC3 PHONEDESC4 PHONEDESC5 PHONEDESC6 PHONEDESC7 PHONEDESC8 PHONEDESC9 PHONEDESC10 PHONESTATUS1 PHONESTATUS2 PHONESTATUS3 PHONESTATUS4 PHONESTATUS5 PHONESTATUS6 PHONESTATUS7 PHONESTATUS8 PHONESTATUS9 PHONESTATUS10 PHONETIMEZONEID PHONETIMEZONEID1 PHONETIMEZONEID2 PHONETIMEZONEID3 PHONETIMEZONEID4 PHONETIMEZONEID5 PHONETIMEZONEID6 PHONETIMEZONEID7 PHONETIMEZONEID8 PHONETIMEZONEID9 PHONETIMEZONEID10 CURRENTPHONE CURRENTPHONECOUNTER TIMEZONEID COMMENTS
60125 2003 rafa 699147161 60125 99 P NULL 1 1002 96 2011-01-04 12:44:28.003 2011-01-04 12:44:28.003 0 0 0 0 0 0 0 1 1002 699147161 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 9 NULL
60126 2003 MIRIAM CANTERO DIAZ 927232543 60126 95 P NULL 1 1027 97 2011-01-04 12:16:38.297 2011-01-04 12:16:38.297 0 0 0 0 0 0 0 1 1027 927232543 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 9 NULL
60127 2003 sra nora 944704050 60127 99 P NULL 1 1035 106 2011-01-04 15:13:18.770 2011-01-04 15:13:18.770 0 0 0 0 0 0 0 1 1035 944704050 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 9 NULL titular agustina lo pensara |