Welcome to Cool Solutions

Collector for Citrix Presentation Server

This collector is able to monitor process table from a Citrix Presentation Server database. The query used is the following, just replace the CITRIXDATABASE name:

SELECT TOP {Max_Rows_To_Return} CITRIXDATABASE.SDB_PROCESS.PK_SDB_PROCESSID AS s_ProcessID, CITRIXDATABASE.LU_FARMNAME.FARMNAME AS s_FarmName, CITRIXDATABASE.LU_SERVERNAME.SERVERNAME AS s_DHN, CITRIXDATABASE.LU_NETDOMAIN.NETDOMAIN AS s_RV41,CITRIXDATABASE.LU_USER.USERNAME AS s_SUN, CITRIXDATABASE.LU_CLIENT.CLIENTNAME AS s_SHN, CITRIXDATABASE.LU_CLIENT.CLIENTADDRESS AS s_SIP, CITRIXDATABASE.LU_PROCESSNAME.PROCESSNAME AS s_EVT, CITRIXDATABASE.LU_APPNAME.APPNAME AS s_FN, CITRIXDATABASE.SDB_PROCESS.PID AS s_PID,CITRIXDATABASE.SDB_PROCESS.STARTTIME AS s_BeginTime, CITRIXDATABASE.SDB_PROCESS.ENDTIME AS s_EndTime, CITRIXDATABASE.SDB_PROCESS.TOTALTIME AS s_CV21, CITRIXDATABASE.SDB_PROCESS.ACTIVETIME AS s_CV22, CITRIXDATABASE.SDB_PROCESS.KERNELUSE AS s_CV23, CITRIXDATABASE.SDB_PROCESS.USERUSE AS s_CV24,CITRIXDATABASE.SDB_PROCESS.USERACTIVE AS s_CV25, CITRIXDATABASE.SDB_PROCESS.KERNELACTIVE AS s_CV26, CITRIXDATABASE.SDB_PROCESS.MEMORY AS s_CV27, CITRIXDATABASE.SDB_PROCESS.MEMORYACTIVE AS s_CV28 FROM CITRIXDATABASE.SDB_PROCESS INNER JOIN CITRIXDATABASE.LU_APPNAME ON CITRIXDATABASE.SDB_PROCESS.FK_APPNAMEID = CITRIXDATABASE.LU_APPNAME.PK_APPNAMEID INNER JOIN CITRIXDATABASE.LU_CLIENT ON CITRIXDATABASE.SDB_PROCESS.FK_CLIENTID = CITRIXDATABASE.LU_CLIENT.PK_CLIENTID INNER JOIN CITRIXDATABASE.LU_PROCESS ON CITRIXDATABASE.SDB_PROCESS.FK_PROCESSID = CITRIXDATABASE.LU_PROCESS.PK_PROCESSID INNER JOIN CITRIXDATABASE.LU_PROCESSNAME ON CITRIXDATABASE.LU_PROCESS.FK_PROCESSNAMEID = CITRIXDATABASE.LU_PROCESSNAME.PK_PROCESSNAMEID INNER JOIN CITRIXDATABASE.LU_SERVER ON CITRIXDATABASE.SDB_PROCESS.FK_SERVERID = CITRIXDATABASE.LU_SERVER.PK_SERVERID INNER JOIN CITRIXDATABASE.LU_FARMNAME ON CITRIXDATABASE.LU_SERVER.FK_FARMNAMEID = CITRIXDATABASE.LU_FARMNAME.PK_FARMNAMEID INNER JOIN CITRIXDATABASE.LU_SERVERNAME ON CITRIXDATABASE.LU_SERVER.FK_SERVERNAMEID = CITRIXDATABASE.LU_SERVERNAME.PK_SERVERNAMEID INNER JOIN CITRIXDATABASE.LU_USER ON CITRIXDATABASE.SDB_PROCESS.FK_USERID = CITRIXDATABASE.LU_USER.PK_USERID INNER JOIN CITRIXDATABASE.LU_NETDOMAIN ON CITRIXDATABASE.LU_USER.FK_NETDOMAINID = CITRIXDATABASE.LU_NETDOMAIN.PK_NETDOMAINID WHERE CITRIXDATABASE.SDB_PROCESS.PK_SDB_PROCESSID > {Last_RowNumber}

Custom variables must be created in order to monitor Total Time, Active Time, Kernel Use, User Use, User Active, Process Memory and Memory Active (s_CV21 to s_CV28), based on those values create your rules to alert any high performance consumption.