→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dpsomma
Engaged Sweeper
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!
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
Make sure to link tblState into your report and add tblState.Statename.
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

View solution in original post

3 REPLIES 3
mzipperer
Engaged Sweeper III
Thank you
dpsomma
Engaged Sweeper
thanks fam
RCorbeil
Honored Sweeper II
Make sure to link tblState into your report and add tblState.Statename.
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