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!
Options
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
SOLUTION 0
Lansweeperlover99
#2Lansweeperlover99 Member Original PosterPosts: 2  
posted: 8/8/2019 7:10:55 PM(UTC)
thanks fam
0
mzipperer
#3mzipperer Member Posts: 23  
posted: 11/25/2020 5:36:52 PM(UTC)
Thank you
0

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)
Lansweeper Opened Help Desk tickets report during a specific time of the day
by  Brandon   Go to last post Go to first unread
Last post: 1/4/2021 6:57:22 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)