Has anyone written their own Stat Server Java Extension (SSJE) plug-in ?

[abudwill]

Topic says it all.  Wondering if anyone has written their own SSJE plugin to create custom stats from sources outside of Genesys.  Stat Server Deployment guide says this was introduced in 7.x.  I know things like OCCStatExtensions and others are available from Genesys - but has anyone written their own?

Regards,
Andrew

[Kubig]

In the past I developed some "hello world samples" for testing purposes. But, as I know, no custom SSJE is not officialy supported by Genesys.

[abudwill]

Hmm I thought that I had read something in the stat server deployment guide that made it sound like this was open.  Upon reviewing again I saw the following blurb:

[i]Note: For this Stat Server release, Java functionality is reserved for use in
conjunction with Genesys-provided reports for Outbound Contact,
eServices (formerly known as Multimedia), and the Voice Callback
option of Enterprise Routing.[/i]

So without following up with Genesys I would have to agree it is not supported.  I have been playing around and have been able to make the SSJE I wrote work - but I try to stay "in the box" as much as possible.

Regards,
Andrew

[cavagnaro]

And what is this usefull for?

[abudwill]

We have a (maybe misguided) need to display some stats in CCP and/or GA from querying a database.

This is mainly for use with OCS.  With OCCStatExtension you can use up to 5 custom java stats that correspond with custom stats defined in an OCS reporting stored procedure.  We are in situation where we need more than 5 - and that is where this becomes useful.

Regards,
Andrew

[Kubig]

You can connect to the database directly from CCPulse+ without any relation to the statserver.

[abudwill]

Hmm I am feeling quite silly now, I will go review the deployment and user guides.

[Kubig]

Within CCP+ you use VBScript, where you can connect to the database directly.

[abudwill]

Getting ready to try this via VBScript directly in CCP+.

Is this done by just defining a formula and entering your VBSCript as the formula?  In your experience do you end up with your DB credentials within the VBScript?

Regards,
Andrew

[cavagnaro]

You could create a DLL and in there code your DB access credentials...still would like to see something useful for RT Monitoring

[abudwill]

That is a clever idea (the .DLL).  I will take it a step further and make it accept values stored in a transaction list that house the appropriate SQL statements to be executed.

In terms of RT reporting, this DB query method will allow us to move beyond the OCS 5 custom statistics that can be defined.  Additionally, those OCS custom stats can be refreshed anywhere from 5 seconds to maximum integer - but I don't necessarily want to put a strain on our DB to refresh all the OCS Java based stats when I might only need 1 or 2.  I should also be able to tag the (nolock) directive on my SQL statements if this works.

For example, we have a list that houses tens of thousands of records.  A system is continually inserting new records.  All records are actually of type Campaign Rescheduled to prevent them from dialing before a certain time.  We would like to add a stat to CCP+ that shows how many records are ready now (this is an out of the box stat), and how many records will be eligible to dial within the next 5 minutes (records of type ready, retrieved, with dial_sched_time of <= current time + 5 minutes) - this could be accomplished via custom DB query.

I think there might be other use cases.  I have not used GAX/LRM yet and don't know where licenses are tracked - but maybe license utilization could be pulled into CCP+ this way too if someone was curious?

Regards,
Andrew