Chocolatey Workstations With Outdated Zoom Versions

Software

Discover which workstations that have Chocolatey are running an outdated Zoom version. This report scans the highest Zoom version number in your environment and compares it to all the other Zoom versions to determine outdated versions.

Zoom versions sometimes have the revision in parenthesis, depending on the package you installed previously. The below report is similar to the winget report, but gets rid of that part in order to calculate the version comparisons. You can find more info on this topic in Pro Tips 52.

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

C:\ProgramData\chocolatey\bin\choco.exe

Chocolatey Outdated 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 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
  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
  tblComputersystem.Domainrole < 2

Show

Hide

Chocolatey Outdated Zoom (64-bit) 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 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
  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 (64-Bit)') _) __
    Where __.r = 1) b On tblSoftware.SoftID = b.SoftID And
      tblSoftware.softwareVersion <> b.LatestVersion
Where tblSoftwareUni.softwareName = 'Zoom (64-Bit)' And tblState.Statename = 'Active' And
  tblComputersystem.Domainrole < 2

Show

Hide