Please use the following report:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select Top 1000000 tblAssets1.AssetID
From tblAssets Inner Join tblAssetRelations On tblAssets.AssetID =
tblAssetRelations.ParentAssetID Inner Join tblAssets tblAssets1
On tblAssetRelations.ChildAssetID = tblAssets1.AssetID Inner Join
tsysAssetRelationTypes On tblAssetRelations.Type =
tsysAssetRelationTypes.RelationTypeID
Where tsysAssetRelationTypes.Name Like '%located%')