Developer's Closet A place where I can put my PHP, SQL, Perl, JavaScript, and VBScript code.

1Aug/090
Query for the Citrix Server List

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

Filed under: Citrix, SQL, Windows No Comments