‎03-05-2019 11:51 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysIPLocations.IPLocation,
tblCitrixHost.Name As Host,
tblCitrixPool.Name As Pool,
tblCitrixGuestExtraInfoTypes.Name,
tblCitrixGuestExtraInfo.[Key],
tblCitrixGuestExtraInfo.Value,
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 tblCitrixGuestExtraInfo On tblCitrixGuestExtraInfo.GuestId =
tblCitrixGuest.GuestId
Inner Join tblCitrixGuestExtraInfoTypes On
tblCitrixGuestExtraInfoTypes.InfoTypeId = tblCitrixGuestExtraInfo.InfoTypeId
Where tblCitrixGuestExtraInfoTypes.Name = 'last boot CPU flags' And
tblState.Statename = 'Active'
Order By Pool,
Host,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now