→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dtsteinb
Engaged Sweeper II
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.
1 ACCEPTED SOLUTION
MikeMc
Champion Sweeper II
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

View solution in original post

1 REPLY 1
MikeMc
Champion Sweeper II
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