cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
294
Views
0
Helpful
0
Replies

Need specific SQL Query to obtain CDR from billing data table

shakaul
Level 1
Level 1

need to find out inbound and outbound call records, from a particular device based on device description
sql car select call_type,callingpartynumber, originalcalledpartynumber, datetimestamporigination from
car:tbl_billing_data where

* Calling device description contains "vacant". Cant find how to join the two tables from the device and cdr together. only device name columns exist, origdevicename and destDeviceName

0 Replies 0