Chocolatey Workstations Missing Zoom
SoftwareDiscover 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