Find All Citrix Clients in Your Network
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