Monitors not connected to computer

[sbrunk]

I'm seeing a lot of monitors which do not have relations to any computer. How can I create a report to list all such monitors so I can delete them?

[sbrunk]

This works great. Thank you.

[Susan_A · Accepted solution]

I've posted a sample report below, which you can add to your Lansweeper installation by following these instructions.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select tblAssetRelations.ChildAssetID
  From tblAssetRelations) And tsysAssetTypes.AssetTypename = 'monitor'