Citrix: Pool Restrictions (Built-in)

[Esben_D]

The report below gives back a list of Citrix pool restrictions.

The report will only list assets when the following criteria are met:

• You have Lansweeper 7.0 or higher.
  
• There is Citrix pool data scanned.
  
• The assets must be active.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblCitrixPool.LivePatching,
  tblCitrixPool.PolicyNoVendorDevice,
  tblCitrixPool.RedoLog,
  tblCitrixPool.HighAvailability,
  tblCitrixPool.HighAvailabilityAllowOvercommit,
  tblCitrixPool.HighAvailabilityOvercommitted,
  tblCitrixPool.WorkloadBalancing,
  tblCitrixPool.WorkloadBalancingVerifyCert,
  tblCitrixPoolRestriction.[Key],
  tblCitrixPoolRestriction.Value,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblCitrixPool
  Inner Join tblAssets On tblAssets.AssetID = tblCitrixPool.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblCitrixPoolRestriction On tblCitrixPoolRestriction.PoolId =
    tblCitrixPool.PoolId
Where tblState.Statename = 'Active'
Order By tblAssets.AssetName