‎06-04-2013 06:03 PM
Solved! Go to Solution.
‎07-03-2013 06:33 PM
‎07-03-2013 06:33 PM
‎06-27-2013 12:26 PM
‎06-26-2013 12:07 PM
‎06-26-2013 05:21 PM
Fossy777 wrote:
Shouldn´t then the devices get scanned for warranty at first contact and retried after 2 days if at first contact it fails?
‎06-07-2013 05:42 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