‎03-05-2019 11:53 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblVmwareProductInfo.Vendor,
tblVmwareProductInfo.OsType,
tblVmwareProductInfo.ProductLineID,
tblVmwareProductInfo.Version,
tblVmwareProductInfo.ApiType,
tblVmwareProductInfo.ApiVersion,
tblVmwareProductInfo.Build,
tblVmwareProductInfo.FullName As Description,
tblVmwareProductInfo.InstanceUuid,
tblVmwareProductInfo.LicenseProductName,
tblVmwareProductInfo.LicenseProductVersion,
tblVmwareProductInfo.LocaleBuild,
tblVmwareProductInfo.LocaleVersion,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblVmwareVcenters
Inner Join tblAssets On tblAssets.AssetID = tblVmwareVcenters.AssetID
Inner Join tblVmwareProductInfo On tblVmwareVcenters.VcenterID =
tblVmwareProductInfo.VCenterID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblState.Statename = 'Active'
Order By tblAssets.IPAddress,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now