‎04-10-2016 12:41 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssetCustom.SystemSKU,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblWarranty.LastWarrantyTry,
tblWarranty.LastWarrantySuccess,
tblAssets.ServiceVersion As LansweeperVersion,
tblWarranty.Error,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Left Join tblWarranty On tblAssets.AssetID = tblWarranty.AssetId
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where (tblAssetCustom.Manufacturer Like '%dell%' Or
tblAssetCustom.Manufacturer Like '%fujitsu%' Or
tblAssetCustom.Manufacturer Like '%HP%' Or tblAssetCustom.Manufacturer Like
'%hewlett%packard%' Or tblAssetCustom.Manufacturer Like '%IBM%' Or
tblAssetCustom.Manufacturer Like '%lenovo%' Or
tblAssetCustom.Manufacturer Like '%toshiba%') And
(tblWarranty.LastWarrantySuccess Is Null Or tblWarranty.LastWarrantySuccess =
'' Or tblWarranty.LastWarrantySuccess < tblWarranty.LastWarrantyTry)
Order By tblAssets.Domain,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now