Matthew wrote:
>Subject: Re: [sipx-users] Specific CDR query with emailed results
>
>Do you know if this particular area is even remotely similar?
>The only challenging part for me will be adding the date
>constraints to the queries.
>This is a simple query I'm using to get part of the data for
>one extension.
>select * from cdrs where callee_aor is <sip:0...@sipx.voip>;
>It will obviously get a little more complicated when I add the
>dates in.
>I would like to get it in place, but don't want it to it to be
>a complete waste of time when 4.2 comes around.
>Do you know if this table is completely different in 4.2 or
>would a significant portion of my work be reusable?
>
The changes in 4.2 to the CDR records are mostly related to new fields
being added. There are some other types of changes to existing fields
(termination) but they're pretty minor and shouldn't impact you.
For your sql query regarding the dates, I typically use something like:
select * from cdrs where callee_aor is <sip:0...@sipx.voip> where
start_time > '2010-03-01' ;
In order to get all calls to <sip:0...@sipx.voip> starting from March
1st
or
select * from cdrs where callee_aor is <sip:0...@sipx.voip> where
start_time > '2010-03-01' and start_time < '2010-03-04' ;
In order to get all calls to <sip:0...@sipx.voip> from March 1st to
March 3rd (excludes March 4th)
>Thanks,
>Matthew
>
>On 3/3/2010 11:52 AM, Josh Patten wrote:
>> I would develop this against the new sipX as the database for 4.2 is
>> changing drastically (for the better)
>>
>> Josh Patten
>> Assistant Network Administrator
>> Brazos County IT Dept.
>> (979) 361-4676
>>
>>
>> On 3/3/2010 11:49 AM, Matthew Kitchin (public/usenet) wrote:
>>
>>> I'm about to write a CDR script to send weekly logs for specified
>>> users to their managers. I found the table where it is
>stored and it
>>> looks pretty straight forward. I'm no sql expert, so I
>wanted to make
>>> sure I'm not reinventing the wheel. Has anyone done
>something similar
>>> they would like to share? Otherwise, I will post mine when I'm done.
>>> _______________________________________________
>>> sipx-users mailing list sipx-users@list.sipfoundry.org List
>Archive:
>>> http://list.sipfoundry.org/archive/sipx-users
>>> Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-users
>>> sipXecs IP PBX -- http://www.sipfoundry.org/
>>>
>>>
>> _______________________________________________
>> sipx-users mailing list sipx-users@list.sipfoundry.org List Archive:
>> http://list.sipfoundry.org/archive/sipx-users
>> Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-users
>> sipXecs IP PBX -- http://www.sipfoundry.org/
>>
>
>_______________________________________________
>sipx-users mailing list sipx-users@list.sipfoundry.org List
>Archive: http://list.sipfoundry.org/archive/sipx-users
>Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-users
>sipXecs IP PBX -- http://www.sipfoundry.org/
>
_______________________________________________
sipx-users mailing list sipx-users@list.sipfoundry.org
List Archive: http://list.sipfoundry.org/archive/sipx-users
Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-users
sipXecs IP PBX -- http://www.sipfoundry.org/
