Author Topic: Querying StatServer (Read 19056 times)

Dennis · « **on:** January 01, 1970, 12:00:00 AM »

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

Thanks, Dennis

Tony Tillyer · « **Reply #1 on:** January 01, 1970, 12:00:00 AM »

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!

Tony

Dana Lee · « **Reply #2 on:** January 01, 1970, 12:00:00 AM »

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

WO · « **Reply #3 on:** January 01, 1970, 12:00:00 AM »

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').

ecki · « **Reply #4 on:** January 01, 1970, 12:00:00 AM »

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

Dennis · « **Reply #5 on:** January 01, 1970, 12:00:00 AM »

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

Dennis · « **Reply #6 on:** January 01, 1970, 12:00:00 AM »

Do you have more Info about this OCX...
tks, Dennis

Dana Lee · « **Reply #7 on:** January 01, 1970, 12:00:00 AM »

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

Dennis · « **Reply #8 on:** January 01, 1970, 12:00:00 AM »

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

Tony · « **Reply #9 on:** January 01, 1970, 12:00:00 AM »

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

Tony · « **Reply #10 on:** January 01, 1970, 12:00:00 AM »

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

Keith · « **Reply #11 on:** January 01, 1970, 12:00:00 AM »

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

Vic · « **Reply #12 on:** January 01, 1970, 12:00:00 AM »

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.

Vic · « **Reply #13 on:** January 01, 1970, 12:00:00 AM »

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

Short · « **Reply #14 on:** January 01, 1970, 12:00:00 AM »

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 doesnLt need to manually release DN's.

Genesys CTI User Forum

News: