Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT filename,fnum,SUBSTRING(sip_dis_info,1,3),SUBSTRING(sip_from_num,1,3),SUBSTRING(sip_to_num,1,3),sip_cseq_meth,DATE_FORMAT(sip_Date,'%a %b %e, %H:%i:%s') FROM request_line WHERE sip_callid = '8F203BAB-EE6B11DE-B051FFC7-205ADC8B' ORDER BY sip_Date;
- +-------------------------------+------+-----------------------------+-----------------------------+---------------------------+---------------+--------------------------------------------+
- | filename | fnum | SUBSTRING(sip_dis_info,1,3) | SUBSTRING(sip_from_num,1,3) | SUBSTRING(sip_to_num,1,3) | sip_cseq_meth | DATE_FORMAT(sip_Date,'%a %b %e, %H:%i:%s') |
- +-------------------------------+------+-----------------------------+-----------------------------+---------------------------+---------------+--------------------------------------------+
- | SS03_00141_20091222125749.cap | 3121 | 415 | 415 | +14 | INVITE | Tue Dec 22, 13:00:59 |
- | SS03_00141_20091222125749.cap | 3127 | 415 | 415 | +14 | INVITE | Tue Dec 22, 13:00:59 |
- | SS03_00141_20091222125749.cap | 3628 | Non | +14 | 415 | UPDATE | Tue Dec 22, 13:01:30 |
- | SS03_00141_20091222125749.cap | 3633 | Non | +14 | 415 | UPDATE | Tue Dec 22, 13:01:30 |
- | SS03_00141_20091222125749.cap | 3642 | 415 | 415 | +14 | ACK | Tue Dec 22, 13:01:30 |
- | SS03_00141_20091222125749.cap | 3643 | 415 | 415 | +14 | ACK | Tue Dec 22, 13:01:30 |
- | SS03_00141_20091222125749.cap | 3644 | 415 | 415 | +14 | BYE | Tue Dec 22, 13:01:30 |
- | SS03_00141_20091222125749.cap | 3645 | 415 | 415 | +14 | BYE | Tue Dec 22, 13:01:30 |
- +-------------------------------+------+-----------------------------+-----------------------------+---------------------------+---------------+--------------------------------------------+
- SELECT filename,fnum,statuscode,SUBSTRING(sip_dis_info,1,3),SUBSTRING(sip_from_num,1,3),SUBSTRING(sip_to_num,1,3),sip_cseq_meth,DATE_FORMAT(sip_Date,'%a %b %e, %H:%i:%s') FROM status_line WHERE sip_callid = '8F203BAB-EE6B11DE-B051FFC7-205ADC8B' ORDER BY sip_Date;
- +-------------------------------+------+------------+-----------------------------+-----------------------------+---------------------------+---------------+--------------------------------------------+
- | filename | fnum | statuscode | SUBSTRING(sip_dis_info,1,3) | SUBSTRING(sip_from_num,1,3) | SUBSTRING(sip_to_num,1,3) | sip_cseq_meth | DATE_FORMAT(sip_Date,'%a %b %e, %H:%i:%s') |
- +-------------------------------+------+------------+-----------------------------+-----------------------------+---------------------------+---------------+--------------------------------------------+
- | SS03_00141_20091222125749.cap | 3123 | 100 | 415 | 415 | +14 | INVITE | Tue Dec 22, 13:00:59 |
- | SS03_00141_20091222125749.cap | 3129 | 100 | 415 | 415 | +14 | INVITE | Tue Dec 22, 13:00:59 |
- | SS03_00141_20091222125749.cap | 3131 | 180 | 415 | 415 | +14 | INVITE | Tue Dec 22, 13:00:59 |
- | SS03_00141_20091222125749.cap | 3133 | 180 | 415 | 415 | +14 | INVITE | Tue Dec 22, 13:00:59 |
- | SS03_00141_20091222125749.cap | 3647 | 200 | 415 | 415 | +14 | BYE | Tue Dec 22, 13:01:30 |
- | SS03_00141_20091222125749.cap | 3640 | 200 | 415 | 415 | +14 | INVITE | Tue Dec 22, 13:01:30 |
- | SS03_00141_20091222125749.cap | 3638 | 200 | 415 | 415 | +14 | INVITE | Tue Dec 22, 13:01:30 |
- | SS03_00141_20091222125749.cap | 3636 | 200 | Non | +14 | 415 | UPDATE | Tue Dec 22, 13:01:30 |
- | SS03_00141_20091222125749.cap | 3634 | 200 | Non | +14 | 415 | UPDATE | Tue Dec 22, 13:01:30 |
- | SS03_00141_20091222125749.cap | 3648 | 200 | 415 | 415 | +14 | BYE | Tue Dec 22, 13:01:30 |
- +-------------------------------+------+------------+-----------------------------+-----------------------------+---------------------------+---------------+--------------------------------------------+
Add Comment
Please, Sign In to add comment