List all Citrix clients along with basic information like host, pool, CPU count and more. When scanning Citrix pools, Lansweeper scans all the information from the clients, hosts and pools. This report provides an overview of all your Citrix clients along with details such as name, host, pool, CPU count, state and more. This detailed overview allows you to keep a grip on your Citrix virtual environment without having to log onto other portals and helps you centralize all the information.
Citrix Client Summary Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysIPLocations.IPLocation,
tblCitrixHost.Name As Host,
tblCitrixPool.Name As Pool,
tblCitrixGuest.CpuCount,
tblCitrixGuest.LastUpdated,
tblCitrixGuest.Live,
(tblCitrixGuest.Memory) / 1024 / 1024 As MemoryMB,
tblCitrixGuest.State,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblCitrixGuest
Inner Join tblAssets On tblAssets.AssetID = tblCitrixGuest.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblCitrixHost On tblCitrixGuest.HostId = tblCitrixHost.HostId
Inner Join tblCitrixPool On tblCitrixPool.PoolId = tblCitrixHost.PoolId
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblState.Statename = 'Active'
Order By Pool,
Host,
tblAssets.AssetName
