Collector for Citrix Presentation Server



By: otoquero

April 29, 2008 12:30 pm

Reads: 164

License:
GNU

Download Citrix_PS_DB_600.zip

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.

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

Tags:
Categories: Cool Tools, Sentinel

Disclaimer: As with everything else at NetIQ Cool Solutions, this content is definitely not supported by NetIQ, so Customer Support will not be able to help you if it has any adverse effect on your environment.  It just worked for at least one person, and perhaps it will be useful for you too.  Be sure to test in a non-production environment.

Comment