Notification

Icon
Error

Trying to make a custom report that sorts assets by state - Basically title

Posted: Thursday, August 8, 2019 5:01:10 PM(UTC)
Lansweeperlover99

Lansweeperlover99

Member Original PosterPosts: 2
1
Like
This issue has been solved! Click here to view the solution
Having trouble with making custom reports for Lansweeper. I'm trying to learn but I am having trouble getting the configuration down and can't find one already made on forums. If anyone has a report that can sort assets by state I would greatly appreciate it!
RC62N
#1RC62N Member Posts: 494  
posted: 8/8/2019 7:03:42 PM(UTC)
Make sure to link tblState into your report and add tblState.Statename.
Code:
Select Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblState.Statename
From
  tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblState On tblState.State = tblAssetCustom.State
Order By
  tblState.Statename
Lansweeperlover99
#2Lansweeperlover99 Member Original PosterPosts: 2  
posted: 8/8/2019 7:10:55 PM(UTC)
thanks fam
mzipperer
#3mzipperer Member Posts: 23  
posted: 11/25/2020 5:36:52 PM(UTC)
Thank you

Active Discussions

Lansweeper Rest API for Scanning
by  Brian Smith   Go to last post Go to first unread
Last post: Today at 7:35:27 PM(UTC)
Lansweeper Language translation not working anymore
by  Florian  
Go to last post Go to first unread
Last post: Today at 6:03:19 PM(UTC)
Lansweeper Use current user for scanning credentials?
by  pryan67   Go to last post Go to first unread
Last post: Today at 6:01:33 PM(UTC)
Lansweeper Bluetooth Info
by  FrankSc  
Go to last post Go to first unread
Last post: Today at 5:42:59 PM(UTC)
Lansweeper Question about Scanning Assets and Password Encryption
by  FrankSc   Go to last post Go to first unread
Last post: Today at 5:23:05 PM(UTC)
Action Check Asset Window Update Status Via Powershell
by  Andy.S  
Go to last post Go to first unread
Last post: Today at 3:30:09 PM(UTC)
Lansweeper How to enable HTTPS in ver 6.0.150.60
by  Duncan.Miles   Go to last post Go to first unread
Last post: Today at 1:11:19 PM(UTC)
Lansweeper INFO DateTimeService time refresh
by  miharix  
Go to last post Go to first unread
Last post: Yesterday at 3:22:29 PM(UTC)