Citrix Summary Database

System DSN - rmsummarydatabase | driver = SQL Server

Goal: Every now and then, we get a request from a development group or application support group that wants to know usage statistics for their application. Knowing there is several different methods to acquire this information we are going to attache directly to the summary database and only query the information we want to see. 

Assumptions:

  1. you already have a summery database configured for your xenapp farm

  2. you are actively collecting client and farm information

User specific information and metrics:

  1. dbo.LU_CLIENTPROPERTIES

    • Column: BUILD - holds historic information on citrix client build information (example: 31560)

    • Column: VERSION - holds citrx client version information (example: 11.2.0.31560)

  2. dbo.LU_CLIENT

    • Column: CLIENTNAME - holds hosname (either friendly format, or raw iis log)

    • Column: CLIENTADDRESSFAMILY - (example - 0,1,2,3)

    • Column: CLIENTADDRESS - (example - 10.1.1.14)

Process specific information and metrics:

  1. dbo.LU_PROCESSNAME -this table holds unique tagged process names

    • Column: PROCESSNAME - (example: acrodist.exe)

  2. dbo.LU_PATH -this table holds paths to process names

    • Column: PATH - (example: c:\program files\citrix\streaming client\)

  3. dbo.LU_PROCESS -file version information, product date information

    • Column: VERSION -details file version information (example: 6.0.3790.3959)

    • Column: PRODUCTDATE -details file date (example: 2/18/2007 8:00:00 AM)

Application specific information and metrics:

  1. dbo.LU_APPNAME -holds published icon name

    • Column: APPNAME -(example: Yahoo IM)

    • PrimaryKey: PK_APPNAMEID

    • PrimaryKey: FK_APPNAMEID

  2. dbo.SDB_APPHISTORY -data in this table details when an application was launched and for how long

    • Column: STARTTIME -when the published application was launched.

    • Column: ENDTIME -when the published application was closed.

  3. Example #1 (general-summary-database-query-citrix.txt) will pull in ALL columns from LU_Appname and SDB_APPHISTORY, with PK_AppnameID and FK_APPNAMEID as part of the inner join.

get general app data