Kristan Posted July 8, 2009 Report Share Posted July 8, 2009 Hi All, As an internal SLA requirement, I need to be able to get some statistics from PBXnSIP on how many calls where answered, how long the average call was ringing for before getting answered and any calls not answered within 10 seconds. I can get all of this from parsing the email that sends out the queue status each night but I was wondering if there's a better way to get at the stats, or if I can change the email so it's in a bit more of a machine readable format (XML attachment?). In the past I've done this by logging all the calls to a database by reading the files in the CDR folder each night, but it seems a bit overkill when all the information I need is mailed to me each night. Oh, as an afterthought - is there any chance of you guys adding the ability to send the CDR records to a database at some point in the future? Like mySQL, or MS-SQL? That'd be a very nice feature, and would make writing a CDR tool very easy Thanks, Kristan Quote Link to comment Share on other sites More sharing options...
pbx support Posted July 8, 2009 Report Share Posted July 8, 2009 Hi All, As an internal SLA requirement, I need to be able to get some statistics from PBXnSIP on how many calls where answered, how long the average call was ringing for before getting answered and any calls not answered within 10 seconds. I can get all of this from parsing the email that sends out the queue status each night but I was wondering if there's a better way to get at the stats, or if I can change the email so it's in a bit more of a machine readable format (XML attachment?). In the past I've done this by logging all the calls to a database by reading the files in the CDR folder each night, but it seems a bit overkill when all the information I need is mailed to me each night. Oh, as an afterthought - is there any chance of you guys adding the ability to send the CDR records to a database at some point in the future? Like mySQL, or MS-SQL? That'd be a very nice feature, and would make writing a CDR tool very easy Thanks, Kristan Well, we have native support for mySQL today. Check out https://www.pbxnsipsupport.com/index.php?_m...kbarticleid=389 But the goal is to get away from writing natively to the databases. Instead, our plan is to integrate with email2db(www.email2db.com) program. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.