Is there a way to monitor (and get QoS data) on who is logged into a Citrix Xenapp server? A client would like a dashboard that shows who's connected to a Xenapp server and what they are running. Is this possible?
So we've figured this out, it's a tad convoluted, but it works. The basic steps are:
1) Use a vb script that retrieves information via Citrix MFCOM on the Zone Data Collector of the farm. That vb script will query the farm for the information needed (User, Application Name, etc), and writes this information to a .csv file.
2) Set up a scheduled task on the Zone Data Collector to run this vb script at a set interval (5 minutes for us).
3) Create a new table in the NimbusSLM database (or whatever your data_engine database is called); name it as you see fit (CitrixFarmConnections for us).
4) Create a job on the SQL server that runs a BULK INSERT of the .csv file. We set this job up to run every five minutes, offset from when the vb script runs by one minute.
The information is now available to be used in a dashboard and SQL queries can be run against it. I've attached in txt format the vb script that I used, it will need to be adjusted to retrieve any different information needed, and to change the directory/name of the output file (line 85). If you want to collect different information, Google 'Citrix MFCOM,' there's a whole bunch of documentation online about it. The script is one I got from the Citrix archives and edited slightly to fit my needs.
Number of connections would be viable, but showing things like "who is connected" and "what they are running" wouldn't be as Nimsoft doesn't collect text strings, only numeric values.
If this information is stored in a DB or another source that could be queried, you could setup a table object within the dashboard designer and post the query results in there with a connection from the DAP.
Understood, that's kind of what I was thinking. I'll work on a SQL query and post it here if I figure it out.
Retrieving data ...