I have just recently started looking at the ima databases in our SQL Server. We have an IMA and an RMS database. Does anyone have some querries to share to extract useful information?
I have been a SQL DBA for about 10 years so I'm ok with querrying the database. We have recently converted our Access IMA to SQL and now the databases sit on my server. Recently my boss asked me to see whether I can extract any usefull info out of there. The only thing I have been able to get is the list of the ACTIVE citrix servers in the farm but I thought that someone could share something other as well.
Here is the query for the list of active farm :
select hostname, status, login_time, last_batch from master.dbo.sysprocesses where program_name='Citrix IMA' order by hostname
I think you should be able to get some sort of info regarding disconnected sessions etc.
Maybe even idle time whilst connected. But you will probably know which fields to look at better than me. ~
I did not intend to insult so my appologies.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.