09-20-2013 06:04 PM
09-24-2013 03:40 PM
09-23-2013 02:56 PM
09-23-2013 10:26 AM
09-20-2013 07:06 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Lasttriggered,
tblAssets.LastActiveScan,
tblAssets.LastScheduled,
tblAssets.LastIPScan,
tblAssets.LastLsPush,
tblAssets.LastSaved,
tblAssets.Scanserver,
tblAssets.ServiceVersion,
tblAssets.LsPushVersion,
tblWarranty.WarrantyId,
tblWarranty.LastWarrantyTry,
tblWarranty.LastWarrantySuccess,
tblWarranty.PurchaseCountry,
tblWarranty.ShipDate,
tblWarranty.ForceUpdate,
tblWarranty.Error
From tblAssets
Inner Join tblWarranty On tblAssets.AssetID = tblWarranty.AssetId
Order By tblAssets.AssetUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now