Here are a couple of scripts to help you along.

No Agent for Asset listing.

Select
  ORG1.ASSET.NAME,
  ORG1.ASSET.MAPPED_ID as "No Agent",
  ORG1.ASSET_DATA_5.FIELD_10008 as "Status"
From
  ORG1.ASSET_DATA_5 Inner Join
  ORG1.ASSET On ORG1.ASSET.ASSET_DATA_ID = ORG1.ASSET_DATA_5.ID
Where
  ORG1.ASSET.MAPPED_ID = '0'

Order By
  ORG1.ASSET_DATA_5.FIELD_10008
 
Limit 500

Find Dup's. Change ^^ with your asset number.

Select
  ORG1.ASSET.NAME,
  ORG1.ASSET.MAPPED_ID,
  ORG1.MACHINE.USER
From
  ORG1.ASSET Inner Join
  ORG1.MACHINE On ORG1.ASSET.NAME = ORG1.MACHINE.NAME
Where
  (ORG1.ASSET.NAME Like '%^^') Or
  (ORG1.ASSET.NAME Like '%^^') Or
  (ORG1.ASSET.MAPPED_ID = '0')
Order By
  ORG1.ASSET.NAME
Limit 4000