Re: [sipx-users] automate CDR reports...

2011-11-07 Thread George Niculae
On Mon, Nov 7, 2011 at 7:27 PM, Matthew Kitchin (public/usenet) < mkitchin.pub...@gmail.com> wrote: > I do it, but it may not be the most elegant way. > I have different files for each extension I run a report for. Here is one: > > psql -H -d SIPXCDR -U postgres -c "select caller_aor,callee_aor,s

Re: [sipx-users] automate CDR reports...

2011-11-07 Thread Matthew Kitchin (public/usenet)
I do it, but it may not be the most elegant way. I have different files for each extension I run a report for. Here is one: psql -H -d SIPXCDR -U postgres -c "select caller_aor,callee_aor,start_time AT TIME ZONE 'GMT' as "Start_Time",end_time AT TIME ZONE 'GMT' as "End_Time",end_time-start_tim

[sipx-users] automate CDR reports...

2011-11-07 Thread obi-wan
is there a command i can place in root's crontab on my 4.2.1 sipXecs server to automatically generate CDR reports.? _i would like to auto generate the CDR graphics in PDF and send to my internet web site to display Call Status for previous days and times.? thanks in advance... obi-wan signat