The report below gives back a list of Citrix guests with a virtual block.
The report will only list assets when the following criteria are met:
- You have Lansweeper 7.0 or higher.
- There is Citrix guest virtual block data scanned.
- The assets must be active.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysIPLocations.IPLocation,
tblCitrixHost.Name As Host,
tblCitrixPool.Name As Pool,
tblCitrixVirtualBlockDevice.Bootable,
tblCitrixVirtualBlockDevice.CurrentlyAttached,
tblCitrixVirtualBlockDevice.Device,
tblCitrixVirtualBlockDevice.Empty,
tblCitrixVirtualBlockDevice.Mode,
tblCitrixVirtualBlockDevice.QosAlgorithmParameters,
tblCitrixVirtualBlockDevice.QosAlgorithmType,
tblCitrixVirtualBlockDevice.QosSupportedAlgorithms,
tblCitrixVirtualBlockDevice.RuntimeProperties,
tblCitrixVirtualBlockDevice.StatusCode,
tblCitrixVirtualBlockDevice.StatusDetails,
tblCitrixVirtualBlockDevice.StorageLock,
tblCitrixVirtualBlockDevice.Unpluggable,
tblCitrixVirtualBlockDevice.UserDevice,
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
Inner Join tblCitrixVirtualBlockDevice On tblCitrixVirtualBlockDevice.GuestId
= tblCitrixGuest.GuestId
Where tblState.Statename = 'Active'
Order By Pool,
Host,
tblAssets.AssetName
