Winget 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,
  Case
    When WingetRegistry.AssetID Is Not Null Then 'Yes'
    Else 'No'
  End As [Has Winget],
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  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') As NotepadCheck On
      tblAssets.AssetID = NotepadCheck.AssetID
  Inner Join (Select Distinct tblregistry.AssetID
    From tblregistry
      Inner Join tblAssets On tblAssets.AssetID = tblregistry.AssetID
    Where
      tblregistry.Regkey Like
      '%Software\Microsoft\Windows\CurrentVersion\App Paths\winget.exe%' And
      tblAssets.Assettype = -1) As WingetRegistry On tblAssets.AssetID =
      WingetRegistry.AssetID
Where tblAssets.Lastseen >= DateAdd(minute, -15, GetDate()) And
  tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1 And
  NotepadCheck.AssetID Is Null
Order By tblAssets.Domain,
  tblAssets.AssetName