Notification

Icon
Error

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

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

AZHockeyNut

Member Alpha Tester Original PosterPosts: 236
0
Like
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?
KevinA-REJIS
#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:

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)
brodiemac-too
#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.
mviel
#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 )

https://www.catalog.upda...7-43e3-a5d4-bf64c1856363

I would suggest to include KB4577069 with the Report so that false-positive are not shown .
Antikas
#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: -

https://www.catalog.upda...2-4eaa-8c29-a755cc55f91d

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

Thanks,
Anthony.
hanslepire
#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 :

2019
KB4577668

2016
KB4580346

2012 R2
KB4580347
KB4580358

Active Discussions

Lansweeper Is there a limit to the number of incoming mail domains?
by  DrewT  
Go to last post Go to first unread
Last post: Today at 1:33:44 PM(UTC)
Lansweeper License renewal - but why
by  mrusso   Go to last post Go to first unread
Last post: Yesterday at 5:01:47 PM(UTC)
Lansweeper Deployment Package Error Message
by  Brandon  
Go to last post Go to first unread
Last post: Yesterday at 2:04:25 PM(UTC)
Lansweeper Asset Type Mail Server
by  MarkPayton   Go to last post Go to first unread
Last post: Yesterday at 1:03:54 PM(UTC)
Lansweeper Upgrade Win 10 build to version 2004
by  Jean-FB  
Go to last post Go to first unread
Last post: 10/28/2020 7:34:29 PM(UTC)
Lansweeper Uptime only shows Standby
by  Gst4r   Go to last post Go to first unread
Last post: 10/28/2020 4:19:33 PM(UTC)
Lansweeper Excepciones
by  Pablo  
Go to last post Go to first unread
Last post: 10/27/2020 7:35:21 PM(UTC)