→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sbrunk
Engaged Sweeper II
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?
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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'

View solution in original post

2 REPLIES 2
sbrunk
Engaged Sweeper II
This works great. Thank you.
Susan_A
Lansweeper Alumni
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'