The onboard reports are written in jasper. You might look at whether they have a CLI option there and the reports can be customizable as well. On Jul 18, 2012 1:31 AM, "m...@mattkeys.net" <m...@mattkeys.net> wrote:
> That may need to be greater than or equal to ( >= ) instead of just > greater than, it's 1:30 and there's not much call volume at the moment. :) > **** > > ** ** > > *From:* sipx-users-boun...@list.sipfoundry.org [mailto: > sipx-users-boun...@list.sipfoundry.org] *On Behalf Of *m...@mattkeys.net > *Sent:* Wednesday, July 18, 2012 1:12 AM > *To:* Discussion list for users of sipXecs software > *Subject:* Re: [sipx-users] automated CDR reports**** > > ** ** > > #!/bin/sh**** > > today=$(date +%Y-%m-%d)**** > > email="b...@example.com"**** > > subject="Abandoned calls for $today"**** > > ** ** > > # insert a header line into the csv.**** > > /bin/echo "FROM,TO,START_TIME,END_TIME" > /tmp/abandoned.csv**** > > /usr/bin/psql -At -F ',' SIPXCDR -U postgres -c "SELECT * FROM view_cdrs > WHERE failure_status = '487' and start_time > '$today'" | \**** > > /bin/cut -d ',' -f 2,3,4,6 >> /tmp/abandoned.csv**** > > ** ** > > # uncomment to email it as the message body**** > > # /bin/cat /tmp/abandoned.csv | /bin/mail -s "$subject" "$email"**** > > ** ** > > # uncomment to email csv as an attachment**** > > # you need the "sharutils" yum package installed for this to work**** > > ** ** > > /usr/bin/uuencode /tmp/abandoned.csv abandoned.csv | /bin/mail -s > "$subject" "$email"**** > > ** ** > > ** ** > > ** ** > > *From:* sipx-users-boun...@list.sipfoundry.org > [mailto:sipx-users-boun...@list.sipfoundry.org] *On Behalf Of * > m...@mattkeys.net > *Sent:* Tuesday, July 17, 2012 10:54 PM > *To:* Discussion list for users of sipXecs software > *Subject:* Re: [sipx-users] automated CDR reports**** > > ** ** > > Thanks for the lead Nathaniel. I found some older documentation on how to > do it using psql here : > http://wiki.sipfoundry.org/display/~rgdans/CDR+Extras . The example > command, "psql -At -F "," SIPXCDR -U postgres -c "select * from view_cdrs", > seems to work for what I need. I can work with this data and filter it out > by the status field but it would probably be easier/more efficient to have > psql do the work for me. I'm still tinkering on the syntax for the query. > I'll post it back to the list when I figure it out.**** > > ** ** > > ** ** > > *From:* sipx-users-boun...@list.sipfoundry.org > [mailto:sipx-users-boun...@list.sipfoundry.org] *On Behalf Of *Nathaniel > Watkins > *Sent:* Tuesday, July 17, 2012 10:43 PM > *To:* Discussion list for users of sipXecs software > *Subject:* Re: [sipx-users] automated CDR reports**** > > ** ** > > Matt β we are accessing the cdr database via an odbc connection in windows > β a scheduled task launches an access app that exports the prior days data > to a csv for input into our billing software β itβs a bit bloated, but > works well enough. This will need re-worked if/when cdrs are ported to > mongodb.**** > > ** ** > > ** ** > > *From:* sipx-users-boun...@list.sipfoundry.org > [mailto:sipx-users-boun...@list.sipfoundry.org] *On Behalf Of * > m...@mattkeys.net > *Sent:* Tuesday, July 17, 2012 10:02 PM > *To:* sipx-users@list.sipfoundry.org > *Subject:* [sipx-users] automated CDR reports**** > > ** ** > > Is there a way to dump all CDRs via the CLI? Specifically I'm looking to > write a script and cronjob it for 23:59 to dump all abandoned calls for the > day as CSV and email them to someone. I consulted the wiki ( > http://wiki.sipfoundry.org/display/sipXecs/Call+Detail+Records+Web+Service) > but it only describes per user and not all history like seen as superadmin. > **** > > ** ** > > Thanks,**** > > Matt**** > > ** ** > > ** ** > ------------------------------ > > This message and any files transmitted with it are intended only for the > individual(s) or entity named. If you are not the intended individual(s) or > entity named you are hereby notified that any disclosure, copying, > distribution or reliance upon its contents is strictly prohibited. If you > have received this in error, please notify the sender, delete the original, > and destroy all copies. Email transmissions cannot be guaranteed to be > secure or error-free as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. Garrett County > Government therefore does not accept any liability for any errors or > omissions in the contents of this message, which arise as a result of email > transmission. > > > Garrett County Government, > 203 South Fourth Street, Courthouse, Oakland, Maryland 21550 > www.garrettcounty.org**** > > _______________________________________________ > sipx-users mailing list > sipx-users@list.sipfoundry.org > List Archive: http://list.sipfoundry.org/archive/sipx-users/ > -- LAN/Telephony/Security and Control Systems Helpdesk: Telephone: 434.984.8426 sip: helpd...@voice.myitdepartment.net Helpdesk Customers: http://myhelp.myitdepartment.net Blog: http://blog.myitdepartment.net
_______________________________________________ sipx-users mailing list sipx-users@list.sipfoundry.org List Archive: http://list.sipfoundry.org/archive/sipx-users/