Winget Workstations Missing Zoom

Software

Discover which workstations do not have Zoom installed yet. This can be used to find devices that require a deployment or can be used to schedule deployment with Lansweeper to ensure that all your devices have a specific software installed on it. This specific report checks which workstations that have been scanned in the last 15 minutes do not have Zoom installed on it. 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 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,
  Case
    When WingetRegistry.AssetID Is Not Null Then 'Yes'
    Else 'No'
  End As [Has Winget],
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  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') As NotepadCheck On
      tblAssets.AssetID = NotepadCheck.AssetID
  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
Where tblAssets.Lastseen >= DateAdd(minute, -15, GetDate()) And
  tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1 And
  NotepadCheck.AssetID Is Null
Order By tblAssets.Domain,
  tblAssets.AssetName

Show

Hide