cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Citrix: Pool Templates (Built-in)

Esben_D
Lansweeper Employee
Lansweeper Employee
The report below gives back a list of Citrix pool templates.

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,
tblCitrixTemplate.TemplateId,
tblCitrixTemplate.Name,
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 tblCitrixTemplate On tblCitrixTemplate.PoolId =
tblCitrixPool.PoolId
Where tblState.Statename = 'Active'
Order By tblAssets.AssetName
0 REPLIES 0