Winget Workstations Not latest version of Zoom

Software

Discover which workstations support Winget and have older versions of zoom installed. This report looks at the latest zoom version detected and compares it to find older versions on your devices that have winget installed. This report is specifically designed for deployment. You can find more info the Pro Tips 52.

Before running the audit, add the following registry keys to your custom registry scanning.

Rootkey: HKEY_CURRENT_USER
Regpath: Software\Microsoft\Windows\CurrentVersion\App Paths\winget.exe
Regvalue: Path

Winget Workstations Not latest version of Zoom Lansweeper On-Prem Query

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

Show

Hide