Discover what’s new in Lansweeper – Explore our 2024 Summer Launch! 🚀 Learn more

TRY NOW

Chocolatey Workstations Missing Zoom

Software

Discover which workstations that have Chocolatey installed, do not have Zoom installed. This can be used to discover workstations you want to deploy on but do not yet have Zoom or any other software you choose installed on it to support automatic version retrieval using Lansweeper deployment. You can find more info about this 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 Workstations Missing Zoom Lansweeper On-Prem Query

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

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You'll be up and running in no time.

Explore all our features, free for 14 days.