Notification

Icon
Error

Report - assets - Show assets assigned at given date

Posted: Sunday, November 22, 2020 9:03:44 AM(UTC)
martintk

martintk

Member Original PosterPosts: 1
0
Like
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.S
#1Andy.S Member Posts: 51  
posted: 11/23/2020 2:42:01 PM(UTC)
Hi Martin,

Give this a go , just change the dates between :

Code:
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

Active Discussions

Lansweeper LanSweeper Reports - merge
by  NDR88   Go to last post Go to first unread
Last post: 1/14/2021 7:41:25 PM(UTC)
Lansweeper Duplicate computers in Webcam query
by  RC62N  
Go to last post Go to first unread
Last post: 1/14/2021 4:36:50 PM(UTC)
Lansweeper Performance REPORT:AVERAGE CPU, RAM & DISK USAGE IN %
by  MassimoAfros   Go to last post Go to first unread
Last post: 1/13/2021 3:57:47 PM(UTC)
Lansweeper Virtual Guest machines report- Add guest OS
by  Andy.S  
Go to last post Go to first unread
Last post: 1/12/2021 9:22:54 AM(UTC)
Lansweeper Print Last OU instead of Full OU
by  RC62N   Go to last post Go to first unread
Last post: 1/11/2021 10:08:39 PM(UTC)
Lansweeper Help Desk with Root Cause
by  Daniel B  
Go to last post Go to first unread
Last post: 1/5/2021 5:57:53 PM(UTC)
Report Center Show newly discovered software
by  dpjhoward  
Go to last post Go to first unread
Last post: 12/16/2020 10:15:05 PM(UTC)