Cannot open report Asset: Out of warranty in 60 days

miketrike · ‎02-13-2014

This happened after I upgraded to version 5.1.0.31

Susan_A · ‎01-15-2015

FYI for everyone: the customer's database was full prior to updating, which caused an update failure. SQL Compact and SQL Server Express databases are limited in size by Microsoft. Solution:

Stop the Lansweeper and web server services.
Restore a database backup.
Free up space in the database, e.g. by clearing the event log tables (which are usually the biggest).
Restart the Lansweeper and web server services. The Lansweeper service will attempt the update again.

View solution in original post

Hemoco · ‎02-14-2014

Maybe you the default syntax was changed? Could you first replace the SQL syntax of the report back to the original?

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssetCustom.Model As [Device Model],
tblAssetCustom.Manufacturer As [Device Manufacturer],
tblAssetCustom.Location,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssetCustom.AssetID,
tblAssetCustom.Warrantydate
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssetCustom.Warrantydate > GetDate() And tblAssetCustom.Warrantydate <
GetDate() + 60 And tblAssetCustom.State = 1 And tblAssets.Assettype <> -1
Order By tblAssets.AssetName

Cannot open report Asset: Out of warranty in 60 days

New to Lansweeper?

Try Lansweeper For Free