Database query in CCPulse

[siddharth.taneja]

Hi,

I am trying to get data from a database in CCPulse views by adding the query into a formula.

If anyone has done this kind of task before or has any idea, please suggest.

Siddharth.

[siddharth.taneja]

I figured it out myself. See if it benefits anyone of you...

[font=Verdana][color=blue][font=Verdana]var objRs = new ActiveXObject("ADODB.Recordset");
strConn = " Provider=SQLOLEDB; Server=<host name>; Database=<database name>; User Id=sa; Password=sa";
strComm = "<SELECT query>";
objRs.open(strComm,strConn,3,1,1);
res=objRs("CO").Value;   
objRs.Close
objRs = null;
res;[/font][/color][/font]

Siddharth

[Sylvainsjc]

Great.
In the same way, can we imagine possible to make a "query" in tables " login " and " status " of StatServer to show agents login and logout time in "CCPulse"

[cavagnaro]

Just curious...why to do that on real time? Usually those are end of day of week reports...not real time needed, How many resources that each query of those consumes?

[Sylvainsjc]

It is not for real time use Cavagnaro but for historical view.

You know CCD and CCS in Oxe. With CCS you have excel reports (session agent) that give informations about login time, withdrawal time, logout time for each agent.

A lot of time when i deploy Full Genesys routing with CCPulse replacing CCSupervision, the supervisors wants to have the same function

[cavagnaro]

Yeah, I know. What I did was to give them a link to a Brio login report I built. The issue on CCpulse is that custom formulas only work on real time.

[Sylvainsjc]

Ok Cav, it would have been nice if CCpulse could give those informations

great thanks

[cavagnaro]

And have you think on GAD supervisor? Maybe a tab to show a web page with that info?

[Sylvainsjc]

GAD supervisor ? I'm very not fan about it. Do you find it's a good apps ?

[cavagnaro]

Me neither but for some stuff like integrating a webportal directly from customer is usefull.