Action to export CCPulse-stats to file or DB

[runarM]

Hi.

Is it possible to define an action where a certain stat-value could be exportet to a file or db from CCPulse? E.g every minute a certain statvalue is written to a file (which again could be exported via ftp or something)

We need a quick-fix for this, so I guess it would be easy to implement if possible in CCPulse.

RunarM

[vivek]

yes you can do that..

I have done similar setup in our company.

Basically I send Service Level to Oracle db. Whenever SL changes in CCpulse,  threshold will trigger a script and update SL table in the DB.

You need to use VB Script code to do this....
Let me know if you need help.

[vivek]

To make your life easy... I have put a sample script.

Create a new Threshold and past the following script in it.

Action script doesn't need to have anything special, you can just change the color.

----------------------------------------------

if Threshold.StatValue >= 0 then

    On Error Resume Next
    Skill_Name="Employee_Phone"

    Connection_String = "driver={Microsoft ODBC for Oracle};SERVER=<dbsid>;UID=<dbid>;PWD=<dbpassword>;"   
   
    Set conn = CreateObject("ADODB.Connection")
    conn.Open Connection_String
    set rs = CreateObject("adodb.recordset")

    sql2="update service_level_table set service_level='"&Threshold.StatValue&"' where skill_name='"&Skill_Name&"'"
    rs = conn.Execute(sql2)

    Set rs = nothing
    conn.close
    set conn = nothing

    Threshold.Result = true

end if

----------------------------------

[cavagnaro]

Sorry to ask, but in which scenario you will want to do this? Why data on the DataMart DB is not enought?

Just curious 

[mark]

cavagnaro - you could then build a softwallboard which can be displayed on desktops.

That is one scenario.

[vivek]

Mark is right.

Actually genesys recommended way is use GIS.
But you need license for GIS and...etc. but in this way you can do it in house.
Datamart and other stuffs are for historical, this is for real time.

[cavagnaro]

Very good example 
Thanks

[runarM]

Thanks a lot!

The scenario is actually what mentioned; we need realtime-statistics for displaying on a webpage. Actually, we have a GIS-license, but this is a short-term solution until we get it up running.

[Jeff]

Runar, have you tried Quest wallboard server? I got it from this forum and because it is using an active X component which can be plugged into a webpage, we now have our wallboard functionality totally covered by it.

Jeff

[mark]

[quote author=Jeff link=topic=2253.msg8200#msg8200 date=1180427843]
Runar, have you tried Quest wallboard server? I got it from this forum and because it is using an active X component which can be plugged into a webpage, we now have our wallboard functionality totally covered by it.

Jeff


[/quote]

Shockingly I never kept track of what was happening with Quest!
How easy is it to implement the plugin to a webpage?

Mark

[runarM]

[quote author=Jeff link=topic=2253.msg8200#msg8200 date=1180427843]
Runar, have you tried Quest wallboard server? I got it from this forum and because it is using an active X component which can be plugged into a webpage, we now have our wallboard functionality totally covered by it.
Jeff
[/quote]

No, I have not actually, but that could maybe work from what i read. Couldnt find a link or email?

[Marpos]

Hi all, i ve tried to use Mark's code but it doesnt works for me

----------------------------------

if Threshold.StatValue >= 3 then

    On Error Resume Next

    Connection_String = "driver={Microsoft ODBC for Oracle};SERVER=GTRIT;UID=fioritom;PWD=a1b2c3d4;"
   
    Set conn = CreateObject("ADODB.Connection")
    conn.Open Connection_String
    set rs = CreateObject("adodb.recordset")

    sql2="Insert Into GTRIT.dbo.test (StatGuardado) Values ('"&Threshold.StatValue&"') "
    rs = conn.Execute(sql2)

    Set rs = nothing
    conn.close
    set conn = nothing

    Threshold.Result = true

end if

----------------------------------------------

Ive tried to write servername as "2PEC0043\GTRIT" (Local pc name is 2PEC0043) and also ".\GTRIT" but it doesnt work either. Im using CCPulse on the same PC where i got the server. I use MS SQL Server 2008 and CCPulse+ 7.5.


Anyone have and idea ? Thanks !

[cavagnaro]

Wait what?
If you have MSSQL then why use an Oracle driver??

[Marpos]

OMG, my bad. But used this one already and is the same:

Connection_String = "driver={SQL Server Native Client 10.0};SERVER=2PEC0043\GTRIT;DATABASE=GTRIT;UID=fioritom;PWD=a1b2c3d4;"

And also tried "SQL Server".

[cavagnaro]

So ODBC libraries are installed?
Via ODBC on Control Panel, does it work?