Citrix Host Summary

Find All Citrix Hosts in Your Network

List all Citrix host along with basic information like model, edition, operating system, memory, CPU 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 hosts along with details such as model, edition, operating system, memory, CPU 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 Host Summary

Click to Open - Citrix Host Summary Query
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.Memory,
  tblAssets.Processor,
  tblCitrixPool.Name,
  tblCitrixHost.Address,
  tblCitrixHost.Description,
  tblCitrixHost.Display,
  tblCitrixHost.Edition,
  tblCitrixHost.Enabled,
  tblCitrixHost.ExternalAuthenticationServiceName,
  tblCitrixHost.ExternalAuthenticationType,
  tblCitrixHost.Hostname,
  tblCitrixHost.IsMaster,
  tblCitrixHost.Live,
  tblCitrixHost.MemoryFree,
  tblCitrixHost.MemoryOverhead,
  tblCitrixHost.MemoryTotal,
  tblCitrixHost.PowerOnMode,
  tblCitrixHost.SchedulerPolicy,
  tblCitrixHost.SslLegacy,
  tblCitrixHost.SuspendImageStorageId,
  tblCitrixHost.Tags,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblCitrixHost
  Inner Join tblAssets On tblAssets.AssetID = tblCitrixHost.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 tblCitrixPool On tblCitrixPool.PoolId = tblCitrixHost.PoolId
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblState.Statename = 'Active'
Order By tblAssets.AssetName

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting