Querying StatServer

Anyone knows a way to query StatSever from an application (in Vb or C) about a specific stats like agent status.

Thanks, Dennis

Dennis,

A long time ago, in a galaxy far away…

There used to be a Genesys webased reporting interface, called DART. It used SQL scripting to obtain pretty much the same as CCA would today. However, with DART you could see the raw code. I’ll have a look on our older servers and see if I can’t find some for you.

If that’s not what you are looking for, let me know and I’ll stop looking! :slight_smile:

Tony

There are two ways you can get agent status.

  1. Use Genesys Interface Server (licensed product $$). This application lets you obtain statistics from any stat server.

  2. Configure Stat Server to write the statistics to a database. You can then query the database for the agent status. I am not sure if this option gives you the current status but will be able to give you the durations for each of the agent states (logged in, ready, hold, etc).

Thanks,

Dana Lee

My memory is that DART used call concentrator tables (SCDR, GCDR etc) and was quite righty binned.

There is an OCX component that can access Stat Server (though not ‘officially’).

Or there is also 3. option, develope your own statserver. It is always calculation based on Tserver events.

What I really need is a way to query real time stats in StatsServer. This would help us identify agents stuck in Dialing mode, the program would then proceed with a call to the DN which will reset the agent status. If Dart can provide a way to obtain Agent status, then I’m interested in what you can find!

thank you

Dennis

Do you have more Info about this OCX…

tks, Dennis

Do you have CCPulse?

If so,

Create an Action that calls a VB application.

Create a Threshold that triggers when the DN has been in a state for longer than x seconds. Where x is the time you think is too long for dialing.

Create a Template that just has the statistic that indicates the agent’s phone is stuck (Dialing).

Create a View that has all of the DNs or places that you want to monitor.

On each DN/Place, you will assign the Threshold and Action.

In order to get this to work, you will need to have a phone that can be controlled by the VB application.

I’m sure there are many other ways to accomplish this and would like to hear from others what they have been able to do.

thanks,

Dana Lee

Hi Dana

I tried the CCpulse + technique and it works great. I wrote the small VB app witch is started by the threshold action passing the object in parameter, The VB pgm take control of a phone somewhere and places a short call to the stuck DN, and voilà

Thank you again for the idea.

Dennis

Hi Dennis,

I read the following thread on the Starsystems site:

I tried the CCpulse + technique and it works great. I wrote the small VB app witch is started by the threshold action passing the object in parameter, The VB pgm take control of a phone somewhere and places a short call to the stuck DN, and voilà

Could you assist me with how you created this VB app or could you send it to me? We have problems with stuck calls on the Symposium link and this would be exactly what we need.

Regards,

Tony

Hi Dennis,

I read the following thread on the Starsystems site:

I tried the CCpulse + technique and it works great. I wrote the small VB app witch is started by the threshold action passing the object in parameter, The VB pgm take control of a phone somewhere and places a short call to the stuck DN, and voilà

Could you assist me with how you created this VB app or could you send it to me? We have problems with stuck calls on the Symposium link and this would be exactly what we need.

Regards,

Tony

Does this OCX work on version 7.x and if so, where can this OCX be obtained from?

My gosh, I just now noticed this post!!! No joke, people, we have three billion topics under the same thread!!!

Deleting stuck calls is really easy: issue EventAbandoned with ThisDN and ThisQueue equal to DN where call is, ConnID = to the call’s id, referenceid = 9999999 and type: 2; OtherDN = ‘090912323434’, Type= 1 and it should ease your worries.

Can this component be used legally? I mean doesn’t Genesys offer Stat Server SDK? Does anyone know pricing for that SDK?

Hi, In statserver (7.x) there is an option called ‘releasestuckcalls’.

If it is set to true, StatsServer itself queries Tserver every 10 minutes, to see that the status is correct, and if nessecary, release the DN. We use it, and thanks to the function we doesnLt need to manually release DN’s.

Yes, but it does not work for virtual queues.

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?

What is this OCX component?

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!

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.