Ageing of Assets

[s_subramanian]

Hi,

I need a report which list all the assets with the Ageing of each asset in years (Based on the purchase date). For Example

Asset Type Serial No Ageing (Years)
Windows 123456 4

Have mentioned few columns for example.

[s_subramanian]

Thanks a lot Daniel

[Daniel_B · Accepted solution]

Please use the report below for the information you are after. Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:
- Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
- Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.Lastseen,
  tblAssetCustom.Serialnumber,
  DateDiff(Year, tblAssetCustom.PurchaseDate, GetDate()) As Age
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1
Order By Age Desc