You can use report as workaround
Select Top 1000000 tblassets.AssetID,
tblassets.domain,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
tblassets.LastLsAgentDirect,
tblassets.LsAgentVersionDirect
From tblassets
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Where tblassets.LastLsAgentDirect Is Not Null