01-09-2015 02:02 PM
Solved! Go to Solution.
01-19-2015 01:24 PM
http://support.lenovo.com
https://api.dell.com
http://www-947.ibm.com
http://support.ts.fujitsu.com
http://support.toshiba.com
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.ServiceVersion,
tblWarranty.WarrantyId,
tblWarranty.LastWarrantyTry,
tblWarranty.LastWarrantySuccess,
tblWarranty.PurchaseCountry,
tblWarranty.ShipDate,
tblWarranty.ForceUpdate,
tblWarranty.Error,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssetCustom.SystemSKU
From tblAssets
Left Join tblWarranty On tblAssets.AssetID = tblWarranty.AssetId
Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
01-19-2015 01:24 PM
http://support.lenovo.com
https://api.dell.com
http://www-947.ibm.com
http://support.ts.fujitsu.com
http://support.toshiba.com
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.ServiceVersion,
tblWarranty.WarrantyId,
tblWarranty.LastWarrantyTry,
tblWarranty.LastWarrantySuccess,
tblWarranty.PurchaseCountry,
tblWarranty.ShipDate,
tblWarranty.ForceUpdate,
tblWarranty.Error,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssetCustom.SystemSKU
From tblAssets
Left Join tblWarranty On tblAssets.AssetID = tblWarranty.AssetId
Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now