Hi,
 
we want to write a little program which reads the following information e.g. every hour from the CISCO TAPI and saves them into a SQL database for further analysis:
 
 
- For calls that were answered:
 
Number of calls for the given time frame (5 min, 10 min, 60 min samples)
Time until the call the was answered (this is often group into 0-20, 21-40, 41-60 and 60+ second groupings)
(Average) Duration of the call
 
- For calls that weren’t answered
 
Number of calls for the given time frame (5 min, 10 min, 60 min samples)
Time until the call the was dropped (this is often group into 0-20, 21-40, 41-60 and 60+ second groupings)
 
- For calls that received an engaged tone
 
Number of calls for the given time frame (5 min, 10 min, 60 min samples)
 
These reports are normally defined for one telephone number or a group of numbers.
 
I'm completely new to this API and I would really appreciate any information or sample code for this. Maybe somebody also has already a suggested database schema for the data from the API.
 
Thanks
Daniel