Hi Brian, Thanks for your reply, but I'm not sure I understand your answer. Maybe I didn't make my question clear ... I'm not in doubt of the units of the variables, but of their meaning. The 5 vars below come each in a Seconds, Milliseconds AND Microseconds flavour. For example: billsec, billmsec and billusec. However, what is the difference between them? I mean how does 'duration' differ from 'bill', and from 'flow_bill'? Same with: **** Variables in Date/Time stamp: - start (as in start_stamp, start_epoch and start_uepoch) - - profile_start - - answer - stamp when call was answered - progress - - end - stamp when call was terminated Thanks, Birgit On 28/07/08 15:24, Brian West wrote:

Microseconds.

/b

On Jul 28, 2008, at 9:02 AM, Birgit Arkesteijn wrote:

...

**** Variables in Seconds, Milliseconds, Microseconds: - duration - bill - progress - progress_media - flow_bill

Brian West sip:brian@freeswitch.org

-- -- Birgit Arkesteijn, birgit@westhawk.co.uk, -- Westhawk Ltd, Albion Wharf, 19 Albion Street, Manchester M1 5LN, UK -- Company no: 1769350 -- Registered Office: -- 15 London Road, Stockton Heath, Warrington WA4 6SJ. UK. -- tel.: +44 (0)161 237 0660 -- <URL: http://www.westhawk.co.uk>

Hi Michael, That would be brilliant, thanks. When you've written a Wiki, would you mind posting the link? It sometimes take a while for Google to find it. Thanks, Birgit On 28/07/08 15:42, Michael S Collins wrote:

Birgit, I have deciphered many of these. I will post my info when I get in front of my computer. I probably need to whip up a wiki page as well. I will work on that this week.

-MC

Sent from my iPhone

On Jul 28, 2008, at 7:02 AM, Birgit Arkesteijn <birgit@westhawk.co.uk> wrote:

...

Hi all,

I'm trying to understand the meaning (and difference) between some of the date and time variables that FreeSWITCH posts as CDR, using xml_cdr.

I'm interested in particular in the variables below:

**** Variables in Date/Time stamp: - start (as in start_stamp, start_epoch and start_uepoch) - - profile_start - - answer - stamp when call was answered - progress - - end - stamp when call was terminated

**** Variables in Seconds, Milliseconds, Microseconds: - duration - bill - progress - progress_media - flow_bill

I couldn't find any documentation on the data. If there is, could you please post the link?

Otherwise is there anyone who could explain what the meaning is of these variables?

Thanks, Birgit

-- -- Birgit Arkesteijn, birgit@westhawk.co.uk, -- Westhawk Ltd, Albion Wharf, 19 Albion Street, Manchester M1 5LN, UK -- Company no: 1769350 -- Registered Office: -- 15 London Road, Stockton Heath, Warrington WA4 6SJ. UK. -- tel.: +44 (0)161 237 0660 -- <URL: http://www.westhawk.co.uk>

You might find the following useful: http://www.nabble.com/Freeswitch-users-f32209.html I started it up on Nabble a few months ago so I could search the mailing list easily :-) Brian S On Monday 28 July 2008 10:01:33 am Michael S Collins wrote:

Will do. Also, if you search the list archives from a few months back you'll see that MikeJ and Tony answered some of my xmlcdr questions. I'm still AFK so I can't post a link to the thread just yet. I will be back in a few hours.

-MC

Hi Mike,

Any chance of you posting that information? If you did so already, sorry, I might have missed out on your posting.

Thanks, Birgit

:( I am a slacker. Stand by and I will get an XML-CDR wiki page started and I'll get these vars documented first. Please give me an hour or so and I'll report back to the list. -MC

Hi Mike, Great piece of work, thanks very much! Some comments: - Maybe you would add to the documentation that microseconds is 10^6 seconds, just for completeness sake. - In Configuration Options, you are missing: * log-b-leg * disable-100-continue * ignore-cacert-check I've just spend some days writing a servlet that will take the XML_CDR, flatting it and write it to a table. I tried to describe all the variables (except for app-log & application) as part of the table documentation. Most of it is guess work. SIP seems to produce an awful lot of parameters: *** a-leg only: sip_received_ip - the IP address SIP is received from sip_received_port - the port SIP is received from sip_authorized - is SIP authorized? sip_mailbox - the SIP mailbox sip_auth_username - the SIP authenticated username sip_auth_realm - the SIP authenticated realm sip_req_user - the username in SIP Request line (TFN) sip_req_uri - the uri in SIP Request line sip_req_host - the hostname in SIP Request line sip_via_host - the hostname in SIP Via header sip_via_port - the port in SIP Via header sip_via_rport - the remote port in SIP Via header sip_from_user - the username in SIP From header sip_from_uri - the uri in SIP From header sip_from_host - the hostname in SIP From header sip_from_user_stripped - the stripped username in SIP From header (?) sip_from_tag - the tag in SIP From header sip_to_user - the username in SIP To header (TFN) sip_to_uri - the uri in SIP To header sip_to_host - the hostname in SIP To header sip_contact_user - the username in SIP Contact header sip_contact_uri - the uri in SIP Contact header sip_contact_host - the hostname in SIP Contact header *** both legs: sip_call_id - the SIP Call-id header sip_user_agent - the SIP Call user-agent header *** b-leg only: sip_gateway_name - the name of the SIP gateway (doneright) sip_destination_url - the SIP destination URL sip_term_status - the SIP termination status sip_term_cause - the SIP termination cause code mailbox - the mailbox user_name - the username domain_name - the domain name record_stereo - is recording in stereo? accountcode - the account code user_context - the user context effective_caller_id_name - the effective caller id name effective_caller_id_number - the effective caller id number sofia_profile_name - the sofia profile name sofia_profile_domain_name - the sofia profile domain name channel_name - the channel name max_forwards - the maximum number of forwards (proxies/gateways) presence_id - the presence id remote_media_ip - the remote media IP address remote_media_port - the remote media port local_media_ip - the local media IP address local_media_port - the local media IP port read_codec - the inbound codec read_rate - the inbound rate write_codec - the outbound codec write_rate - the outbound codec current_application - the current application last_file_position - the last position in the js or recording file(?) endpoint_disposition - ??? originate_disposition - ??? bridge_channel - the bridge channel bridge_uuid - the bridge uuid signal_bond - ??? switch_m_sdp - merged (?) SDP switch_r_sdp - changes the remote SDP header sip_hangup_phrase - the SIP hangup phrase proto_specific_hangup_cause - the protocal specific hangup cause hangup_cause - the hangup cause last_app - the last application last_arg - the last argument caller_id - the caller id *** b-leg only: originator - the originator of this b-leg (== a-leg.uuid) originator_codec - the codec of the originator caller/ *** both legs: username - the username of the caller dialplan - the dialplan of the caller caller_id_name - the caller_id_name of the caller caller_id_number - the caller_id_number of the caller ani - the ANI of the caller aniii - the ??? of the caller network_addr - the network address of the caller rdnis - the ??? of the caller destination_number - the destination number of the caller uuid - the uuid of the caller source - the source of the caller context - the context of the caller chan_name - the channel name of the caller times/ created_time - the created time in microseconds profile_created_time - the profile created time in microseconds progress_time - the progress time in microseconds progress_media_time - the progress_media time in microseconds answered_time - the answered time in microseconds hangup_time - the hangup time in microseconds transfer_time - the transfer time in microseconds (end of list of variables) To relate a- and b-legs: a-leg.uuid == b-leg.originator Thanks, Birgit -- -- Birgit Arkesteijn, birgit@westhawk.co.uk, -- Westhawk Ltd, Albion Wharf, 19 Albion Street, Manchester M1 5LN, UK -- Company no: 1769350 -- Registered Office: -- 15 London Road, Stockton Heath, Warrington WA4 6SJ. UK. -- tel.: +44 (0)161 237 0660 -- <URL: http://www.westhawk.co.uk>