Trying to make a custom report that sorts assets by state

[dpsomma]

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!

[mzipperer]

Thank you

[dpsomma]

thanks fam

[RCorbeil · Accepted solution]

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