Report - assets

[martintk]

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

[Andy_Sismey]

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