Assets Scanned by Both Lansweeper and SCCM

Select Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypename As Type,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  Case (tblAssets.Assettype)
    When -1 Then tsysOS.OSname
    When 11 Then tblLinuxSystem.OSRelease
    When 13 Then tblMacOSInfo.SystemVersion
    Else ''
  End As OS,
  tblAssets.SP As SP,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssets
  Left Join tblSccmAsset On tblAssets.AssetID = tblSccmAsset.AssetId
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tblLinuxSystem On tblLinuxSystem.AssetID = tblAssets.AssetID
  Left Join tblMacOSInfo On tblMacOSInfo.AssetID = tblAssets.AssetID
Where tblAssets.ScannedBy & 3 = 3
Order By tblAssets.ScannedBy Desc,
  tblAssets.Assettype,
  tblAssets.AssetName