SQL Query CDR description missing.

[gagankalra1]

Hi All,

I am currently using this query for the CDR of specific extension, but it doesnt include the Username or description.

Please guide.

run sql car select callingpartynumber,originalcalledpartynumber,finalcalledpartynumber,datetimestampconnect,datetimestampdisconnect,duration from car:tbl_billing_data where datetimestamporigination between "2012-02-01 00:00:00" and "2012-02-29 23:59:00" and callingpartynumber IN (XXXX) or originalcalledpartynumber IN (XXXX) or finalcalledpartynumber IN (XXXX)

[gagankalra1]

I just need the table name for the description field, I have tried d.description, But no luck.

/Gagan