→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎03-05-2019 11:45 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblCitrixPool.LivePatching,
tblCitrixPool.PolicyNoVendorDevice,
tblCitrixPool.RedoLog,
tblCitrixPool.HighAvailability,
tblCitrixPool.HighAvailabilityAllowOvercommit,
tblCitrixPool.HighAvailabilityOvercommitted,
tblCitrixPool.WorkloadBalancing,
tblCitrixPool.WorkloadBalancingVerifyCert,
tblCitrixPoolPatch.Name,
tblCitrixPoolPatch.Size,
tblCitrixPoolPatch.Version,
tblCitrixPoolPatch.AfterApplyGuidance,
tblCitrixPoolPatch.Applied,
tblCitrixPoolPatch.Description,
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 tblCitrixPoolPatch On tblCitrixPoolPatch.PoolId =
tblCitrixPool.PoolId
Where tblState.Statename = 'Active'
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now