How to Determine which MetaFrame XP or Presentation Servers are Connected to a SQL Data Store 

 

This article describes how to determine which MetaFrame XP or Presentation servers are connected to a SQL data store.
From the SQL server:

Run the SQL Query analyzer.
Type the following statement:
Select * from master.dbo.sysprocesses where program_name='Citrix IMA'
Note: Single quotes must be applied to “Citrix IMA”.
Execute the statement by pressing F5 or the Execute button.
The output displays all of the open connections from MetaFrame XP or Presentation servers to the SQL server.