Chocolatey Workstations Missing Zoom

Select Top 1000000 Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As
  icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysOS.OSname As OS,
  tblAssets.Domain,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tbladcomputers.OU,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Case
    When haschoco.AssetID Is Null Then 'no'
    Else 'yes'
  End As has_choco,
  Case
    When tblErrors.ErrorText Is Not Null And tblErrors.ErrorText != ''
      And tsysasseterrortypes.ErrorMsg Not Like '%PrinterSpoolDisabledError%'
    Then 'Scanning Error: ' + tsysasseterrortypes.ErrorMsg
    Else ''
  End As ScanningErrors
From tblComputersystem
  Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tbladcomputers On tblAssets.AssetID = tbladcomputers.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
      tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join (Select Distinct tblErrors.AssetID,
      Max(tblErrors.Teller) As ErrorID
    From tblErrors
    Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID =
      ScanningError.AssetID
  Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller And
      tblErrors.AssetID = tblAssets.AssetID
  Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype =
      tblErrors.ErrorType
  Left Join (Select Distinct tblSoftware.AssetID
    From tblSoftware
      Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.SoftID
    Where (tblSoftwareUni.softwareName = 'Zoom (64-bit)' Or
        tblSoftwareUni.softwareName = 'Zoom')) As ZoomCheck On
      tblAssets.AssetID = ZoomCheck.AssetID
  Inner Join (Select tblFileVersions.AssetID,
      tblFileVersions.Found,
      tblFileVersions.FilePathfull,
      tblFileVersions.FileVersion,
      tblFileVersions.CompanyName,
      tblFileVersions.Filesize,
      tblFileVersions.Lastchanged
    From tblFileVersions
    Where tblFileVersions.FilePathfull Like '%choco.exe' And
      tblFileVersions.found = 1) haschoco On tblAssets.AssetID =
      haschoco.AssetID
Where tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1 And
  ZoomCheck.AssetID Is Null
Order By tblAssets.Domain,
  tblAssets.AssetName