zerologin posted report - your posted report could use a minor tweak

Posted: Friday, September 25, 2020 3:23:20 PM(UTC)


Member Alpha Tester Original PosterPosts: 236
This issue has been solved! Click here to view the solution
the report, as posted to your page shows assets that are marked with status other than active...such as destroyed, in-active etc. when one has a lot of assets in the report these should likely get filtered out so the active ones get priority in patching. could you show how to add that filter?
#1KevinA-REJIS Member Posts: 29  
posted: 9/25/2020 8:38:42 PM(UTC)
Ran into the same problem, found the parentheses in the Where statement were incorrect, here's my fixed code:

Where (tsysOS.OSname In ('Win 2008 R2', 'Win 2012', 'Win 2012 R2', 'Win 2016',
    'Win 2019') Or (tsysOS.OScode Like '10.0.18362' Or
      tsysOS.OScode Like '10.0.18363' Or tsysOS.OScode Like '10.0.19041')) And
  tblAssetCustom.State = 1 And tsysAssetTypes.AssetTypename Like 'Windows%' And
  tblComputersystem.Domainrole In (4, 5)
#2brodiemac-too Member Posts: 29  
posted: 9/28/2020 1:21:17 PM(UTC)
I believe there is also a problem with servers that are domain controllers in this report. Mine are all patched but this report lists all of my domain controllers are vulnerable.
#3mviel Member Posts: 2  
posted: 9/29/2020 9:06:59 PM(UTC)
I have the Problem that on Windows 2019 Server the latest Patches are installed , but still the Report tells that there are missing KBs.

Did someone else had the Same Question .

If I google for KB4570333 its shows on Microsofts WebPage that the Updates was replaced bei KB4577069, that could Explain the Differece . ( PackageDetails )


I would suggest to include KB4577069 with the Report so that false-positive are not shown .
#4Antikas Member Posts: 1  
posted: 10/1/2020 9:42:54 AM(UTC)
Found the exact same issue, mviel. Ran updates using KACE SMA which succeeding but Zerologon audit was showing systems out of date and vulnerable.

In my case, found KB4565349 has been superseded by KB4577069: -


I have updated our Lansweeper Zerologon audit report to include this update.

#5hanslepire Member Posts: 1  
posted: 10/23/2020 8:50:59 AM(UTC)
This is needed to add 2020-10 updates otherwise, the report will be red :



2012 R2

Active Discussions

Installer Cmd - WSUS Offline Update installation
by  jadeesh   Go to last post Go to first unread
Last post: 11/12/2020 9:07:11 AM(UTC)
Installer Deploy SolarWinds Take Control Agent
by  Corey Lambert  
Go to last post Go to first unread
Last post: 8/6/2020 2:23:22 PM(UTC)
Installer Microsoft Edge (Chromium) 84.0.522.44
by  PLSJohnJohn  
Go to last post Go to first unread
Last post: 7/24/2020 10:22:19 PM(UTC)
Installer Windows 10 Upgrade
by  CyberCitizen   Go to last post Go to first unread
Last post: 7/8/2020 1:07:47 AM(UTC)
Installer Installer - Microsoft Office
by  Florian_Eigsi  
Go to last post Go to first unread
Last post: 6/29/2020 3:33:20 PM(UTC)
Installer Firefox ESR 68.8.0 MSI Installer
by  PLSJohnJohn   Go to last post Go to first unread
Last post: 5/11/2020 4:33:50 PM(UTC)
Installer Update Chrome browser with GoogleUpdate.exe ?
by  Inna Ptushkina  
Go to last post Go to first unread
Last post: 5/4/2020 8:39:29 PM(UTC)