SQL query for the Citrix server list. Substitute the dbid for the current id or simply use the name:
select rtrim(hostname) as hostname, rtrim(program_name) as program_name, rtrim(net_library) as net_library, rtrim(loginame) as loginame from master.dbo.sysprocesses where dbid = '9' order by hostname;
select * from master.dbo.sysprocesses where dbid = '9' order by hostname;
use citrixxplicense
go
select top 10 * from indextable where attrvalue like '%TABLENAME%'
go
select * from indextable where attrvalue like '%TABLENAME%' order by attrnameid desc
go
