Querying StatServer

[M.L.]

Yes, but it does not work for virtual queues.

[Vic]

Hi,

I was wondering if this something we can share with others as well.

I know that I need it RIGHT NOW. We have a lot of calls that are stuck in VQ because of network disconnects between URS and StatServer, and if there is a way to delete a call by implementing a CCP+ and a simply VB application, it would be great.

I guess it would work, I would just need ConnID and VQ name can you get it from CCP?

[Vic]

What is this OCX component?

[Bad Cat]

once upon a time, using Java libraries, I succeeded to query Stat Server. It was long long time ago... before Good Lord created the Galaxy!

[Esekherif]

OCX component of CCPlus. Of course, the OCX file in question has a development license. To use/register this OCX, at first, you have to crack it. Since it's not legal, I don't advise any of you to do this, however, using ColdIce, you can track the registers and implement a patch for this. Repeating this is not legal. Without this license, you couldn't use OCX file in development environment.

[Rick]

Hi, Vic. I have heard your recommendation for releasing stuck calls before, but the trouble I have been having is actually finding which call is stuck. The only indication I have of a stuck call is in CC Pulse and the call is stuck on a VQ. If I could find the call, I would follow your advice on releasing it. Any suggestions on best way to locate the specific call that is stuck? NOTE this still happens w/StatServer 7.x (7.0.2) with option checkstuckcalls=true. Thanks!

[Marc Sassoon]

Is this just for StatServer? Version 7.1 of TServer and Management Layer includes a feature to release stcuk calls from the TServer, and therefore StatServer also. It works using a small program triggered by SCS. Check out the docs.
Also, for the CCP method, you don't need a view as you can attach the threshold to any object.

[WO]

Just managed to find the component and docs on my fileserver that allows apps to comunicate directly to Stat Server. It's dated year 2000. I assume it will still work but not sure of the legalities of it though.

[kerrickter]

DART used a combonation of Call Centrator and StatServer tables and made them available via a web server. It was hard to customize, so they made CCPulse and Datamart available and terminated the product.

If you want you could activate the StatServer table options, add a DAP to statserver's connection tab, run the scripts found in the installed directory of statserver and create your own homebaked DART application.

The offical API is available though, Look into Statistic SDK, which includes the Genesys Interface Server. If you wanted something enterprise strength, that would the route to take.

[jeanmarc]

dennis any way to get that code from you the vb script? i have been looking for this but no one knows vb at my work...

[jeanmarc]

hi is there any way that i can receive a copy of this doc? thanks.

[Riaad]

Can you please send my the app and OCX you used to query the statserver please

Thanks
Riaad

[Otis]

Yes, I worked on this matter. I have a javaased tool.

[andry]

hi is there any way that i can receive a copy of this vb script and java apps?  thanks

-andry