Need a report with Warranty End date before November 1st 2017

[netadm3]

Hi All,

I need to create a report that will put all asset that are out of warranty and will be out of warranty before November 1st 2017 for budget planning.

Thanks for your help

[Susan_A · Accepted solution]

I've posted a sample report below, which you can add to your Lansweeper installation by following these instructions. If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, more information on which can be found here. The dictionary explains in great detail what each table and field stores.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssetCustom.Serialnumber,
  tblAssetCustom.PurchaseDate As [Purchase Date],
  tblAssetCustom.Warrantydate As [Warranty Expiration],
  tsysAssetTypes.AssetTypename As Type,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssetCustom
  Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where (tblAssetCustom.Warrantydate < GetDate() And tblAssetCustom.State = 1) Or
  (tblAssetCustom.Warrantydate < '2017-11-01' And tblAssetCustom.State = 1)
Order By [Warranty Expiration] Desc