Realtime agent stats feed

[tooley311]

I'm looking for a way to get the equivalent of the information which is available in CentreVu's Real-time tables. The tables aren't available from the ODBC connector, and I'd like to create some apps that tell the supervisory team how many agents are in which AUX states, etc., without having to have the full CentreVu client installed.

I've found that this probably can be done with CT Server, which I have, but I would need some application on top of that using TSAPI or JTAPI to be able to harvest the data.

I'm looking to find out if there are any other API's, perhaps in PHP, Perl, Python.

 

[AvayaHelp]

We use Crystal, just a thought.

 

[tooley311]

I use Crystal and PHP with the ODBC feed, but are you able to specifically gather the "REAL-TIME" feeds, which tells you which agents are currently on a call, or currently (at this very moment) in AUX?

 

[AvayaHelp]

Well we can as we have Crystal connected to the CMS Server, if we did not have the CMS Server then we would just connect to a Sun 7 or higher and have the data feed to the Sun box then using Crystal and the ODBC feed you could get it that way, I am wondering why you do not want to get CMS Centrevue, cost I would imagine? It is the tool for those who rely on the reports for charge backs to the client.

 

[tjaartv]

The best way to get real-time stats for an external application is to use the command line interface, clint, which is located in /cms/toolsbin. Just search the forum for "clint", you should get all the info needed to get going.

 

[Jolagues]

Im not sure if you would consider purchasing a progam but I am doing a trial of a product called N-Focus that is a web bassed app that runs on my sql that allowesaccess to these reports and costs less then half of what cms cost.

http://www.netlert.com

José

Please let me know if this was helpful

 

[Coineandude]

do you get call record type data from netlert?
or is it pretty much just a web interface for BCMS?

 

[Jolagues]

I would say it is basically a web bassed BCMS.
what type of call record data are you looking for?

José

Please let me know if this was helpful

 

[Coineandude]

I need data like what is in the CMS Call Record table.
i.e. callid, segment, first vdn, calling party, call stats etc. Unfortunately, Call Record data is not collected if CMS processes more than 400 calls in 20 minutes - which makes it functionally useless to us.
We are getting ready to shell out for External Call History to dump to a SQL server ($$$) and I was hoping that maybe this was an option. not really looking that way though.

 

[tooley311]

shaneymc: two items:

1. You can set the number of calls in call_rec to a higher number by performing maintenance on the CMS server and upping the capacity, I believe the max is 9999.

2. If you have the ODBC package and some knowledge of PHP, Perl, Python, ASP, etc., you can write a simple tool which goes and grabs the "latest" records from that table all the time. There is a unique id which seldom wraps, and you can just check what the latest record you have already in cache is, then go get the newer records from the server, etc. If that doesn't explain it well enough, perhaps you should get ECHI and a tool to use it

-t-

 

[Coineandude]

thanks for the reply.

my issue is not the number of records kept, it is whether or not CMS (we run R3v9) collects the data.

for multiple periods during the middle of our business day, CMS call record data collection fails beacuse our call rate exceeds the documented threshold of 400 calls per 20 minutes.

am i missing something fundamental here? is there a way around this call record limitation? please tell me i have overlooked the obvious. please, before i spend another $30k, tell me where i have gone wron.

sorry for the vent there, i do appreciate the response, but my sordid affair with ECHI has made me despair.

--shane