Jetzt Ausprobieren

Citrix Client Summary

Virtual Machines

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

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

Show

Hide