cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
martintk
Engaged Sweeper
Hi,

New to Lansweeper, we're using it for asset management.

I've been asked to run a report to show assets added to Lansweeper at a given date?

I can't find that on the report section and not sure how to make a new report.

Any advice would be great.

thanks
Maritn
1 REPLY 1
Andy_Sismey
Champion Sweeper III
Hi Martin,

Give this a go , just change the dates between :

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Firstseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.Firstseen Between '11-19-2020' And '11-20-2020' And
tblAssetCustom.State = 1