Switch branches/tags
Find file History
#6 Compare This branch is 123 commits ahead, 2182 commits behind release-15.04.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
..
Failed to load latest commit information.
agent
bin
etc
java_bindings
meta
report
ruby_bindings
tests
.project
LICENSE
Makefile.am
README
common.am
config
configure.ac
sipxacdstatistics.spec.in

README

Installation
 1.) install ruby >= 1.8.4, gems and rake >= 0.7
 2.) Install file-tail
   gem install file-tail
 3) build
   rake
-- SAMPLE REPORTS
select agent_uri, sum(terminate_time - pick_up_time) as
  total_handle_duration from acd_call_stat
  group by agent_uri
  order by agent_uri;

select agent_uri, sum(sign_out_time - sign_in_time) as
 time_signed_in from acd_agent_stat
 group by agent_uri
 order by agent_uri;

select agent_uri, avg(terminate_time - pick_up_time) as avg_handle_duration
 from acd_call_stat where state = 'terminate'
 group by agent_uri
 order by agent_uri;

select agent_uri, count(*) as num_calls
 from acd_call_stat where state = 'terminate'
 group by agent_uri
 order by agent_uri;