Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
FernandoBueno
Engaged Sweeper

Hi there!

Since yesterday, I've been experiencing an issue that might be related to the query. All Windows Server 2022 machines — even though fully up to date — are still showing up as red in the report, indicating that KB5055526 is missing, along with the message: "Reboot might be required."

I’ve double-checked that the KB was successfully installed, rebooted the servers, and of course, rescanned them. However, the issue persists, and the same warning continues to appear.

Has anyone else run into this, or is there something I might be missing on the query side?

Thanks in advance!

1 ACCEPTED SOLUTION
ncjaneke
Engaged Sweeper

Similar issue, Fully updated Windows 2022 ( Build 20348.3453 ) - KB5055526 + KB5055688(.Net) and report shows as red. I presume a report edit is required ( again ) - I've changed this line to 3453:
"When tsysOS.OSname = 'Win 2022' And SubQuery2.Buildnumber >= 3453 
3rd edit!
When (tsysOS.OScode Like '10.0.14393%' Or
tsysOS.OSname = 'Win 2016') And SubQuery2.Buildnumber < 7969 ( for 2016 servers )

View solution in original post

4 REPLIES 4
ncjaneke
Engaged Sweeper

Similar issue, Fully updated Windows 2022 ( Build 20348.3453 ) - KB5055526 + KB5055688(.Net) and report shows as red. I presume a report edit is required ( again ) - I've changed this line to 3453:
"When tsysOS.OSname = 'Win 2022' And SubQuery2.Buildnumber >= 3453 
3rd edit!
When (tsysOS.OScode Like '10.0.14393%' Or
tsysOS.OSname = 'Win 2016') And SubQuery2.Buildnumber < 7969 ( for 2016 servers )

Thanks, worked perfectly. Frustrating that this keeps happening and I waste time sense checking update logs, patch delivery, pending reboots only to find the SQL query is wrong. 

Kenf
Engaged Sweeper II

Having same issue on Windows 11 23h2.  Showing as needing KB5055528 but also listing KB5055528 as installed

 

Kenf
Engaged Sweeper II

changed the line tsysOS.OScode Like '10.0.22631%') And SubQuery2.Buildnumber >= 5191 to >= 5189

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now