Please contact support@lansweeper.com and provide:
- Link to this forum thread.
- Program Files (x86)\Lansweeper\Service\Errorlog.txt, as present on your Lansweeper server.
- Output of the report below, in Excel format. Replace YourAsset with the NetBIOS name of one problem asset.
To use the report, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.
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
Where tblAssets.AssetName = 'YourAsset'