‎03-05-2019 11:44 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.Memory,
tblAssets.Processor,
CitrixPool.AssetID As deviceassetid,
CitrixPool.AssetName As deviceassetname,
tblCitrixStorage.Name,
tblCitrixStorage.Description,
tblCitrixStorage.PhysicalSize,
tblCitrixStorage.PhysicalUtilization,
tblCitrixStorage.Type,
tblCitrixStorage.ContentType,
tblCitrixStorage.[Clustered],
tblCitrixStorage.IsToolsStorage,
tblCitrixStorage.LocalCache,
tblCitrixStorage.Tags,
tblCitrixStorage.VirtualAllocation,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblCitrixHost
Inner Join tblAssets On tblAssets.AssetID = tblCitrixHost.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 (Select Top 1000000 tblCitrixPool.PoolId,
tblAssets2.AssetID,
tblAssets2.AssetName
From tblCitrixPool
Inner Join tblAssets As tblAssets2 On tblAssets2.AssetID =
tblCitrixPool.AssetID
Inner Join tblAssetCustom On tblAssets2.AssetID = tblAssetCustom.AssetID
Order By tblAssets2.AssetName) CitrixPool On CitrixPool.PoolId =
tblCitrixHost.PoolId
Inner Join tblCitrixStorage On tblCitrixStorage.HostId = tblCitrixHost.HostId
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
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