CDR logging for SIP users


#1

I have CDR logging to a MySQL server setup and it seems to be working.

I can’t figure out how to map the CDR records to SIP users.

For example, I register to Asterisk as
1234@pbx1
and I call an extension. The CDR record shows:
2006-06-05 15:03:00
"Jack Snodgrass" ( sent from the sip phone app I used )
(ditto)
jsnodgra (ditto)
date ( entension I called )
context-pbx2 ( contect for that extension )
SIP/192.168.1.15-0a062ec8 ( I assume that this maps to the sip user that made the call )
Hangup
10
10
ANSWERED
3

no where in there is the fact that I was using
1234@pbx1 as my sip extension. How do I get
SIP/192.168.1.15-0a062ec8
to map to my 1234@pbx1 registration?

Also… I have an accountcode defined for the
1234@pbx1 sip extension but the accountcode
field is blank.

What am I missing?

jack