Winget Workstations Not latest version of Zoom

Select Top 1000000 tblAssets.AssetID,
  tblAssets.assetname,
  tblSoftwareUni.softwareName As Software,
  tblSoftwareUni.SoftwarePublisher As Publisher,
  tblSoftware.Lastchanged,
  tblSoftware.softwareVersion As Version,
  b.LatestVersion,
  tblAssets.lastseen
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  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
  Inner Join (Select __.SoftID,
      __.Major,
      __.Minor,
      __.Build,
      LatestVersion = __.softwareVersion
    From (Select *,
          r = Row_Number() Over (Partition By _.SoftID Order By _.Major Desc,
          _.Minor Desc, _.Build Desc)
        From (Select Distinct tblSoftware.SoftID,
              Major = CONVERT(INT, CASE WHEN CHARINDEX(' (', tblSoftware.softwareVersion) > 0 THEN SUBSTRING(tblSoftware.softwareVersion, 1, CHARINDEX('.', tblSoftware.softwareVersion) - 1) ELSE PARSENAME(tblSoftware.softwareVersion, 3) END),
        Minor = CONVERT(INT, PARSENAME(CASE WHEN CHARINDEX(' (', tblSoftware.softwareVersion) > 0 THEN LEFT(tblSoftware.softwareVersion, CHARINDEX(' (', tblSoftware.softwareVersion) - 1) ELSE tblSoftware.softwareVersion END, 2)),
        Build = CONVERT(INT, PARSENAME(CASE WHEN CHARINDEX(' (', tblSoftware.softwareVersion) > 0 THEN LEFT(tblSoftware.softwareVersion, CHARINDEX(' (', tblSoftware.softwareVersion) - 1) ELSE tblSoftware.softwareVersion END, 1)),
		
              tblSoftware.softwareVersion
            From tblSoftware
              Inner Join tblSoftwareUni On tblSoftware.SoftID =
                  tblSoftwareUni.SoftID
            Where tblSoftwareUni.softwareName = 'Zoom') _) __
    Where __.r = 1) b On tblSoftware.SoftID = b.SoftID And
      tblSoftware.softwareVersion <> b.LatestVersion
Where tblSoftwareUni.softwareName = 'Zoom' And tblState.Statename = 'Active' And
  tblAssets.Lastseen >= DateAdd(minute, -15, GetDate()) And
  tblComputersystem.Domainrole < 2