Report on Last Seen

[dtsteinb]

I need to know if it possible to create a report based on First Seen. What I am looking for is we want all desktops that are older than say 5yrs to come up in the list. I would need the same for Monitors, switches, etc.

[MikeMc · Accepted solution]

This should get you started:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.Firstseen < DateAdd(Year, -5, GetDate()) And
  tblAssetCustom.State = 1