‎07-12-2024 09:51 PM - edited ‎07-23-2024 02:19 PM
Hey,
A few years ago I tried to improve the patch Tuesday report to make it less error prone and also to prevent it from marking devices as "out-of-date" when they get a new update next month.
The main issues I ran in were
Luckily, since time has passed and older operating systems have gone end-of-life. This is becoming less of an issue. The only remaining supported OS with no build number info is Server 2012.
So with that, I have created a new version of Patch Tuesday, that uses the old method for Server 2012, but the new method for all the rest. The new method is simply using the build number of the operating system to check whether it is up-to-date. Meaning that if you were to use it after Patch Tuesday August, the report should still be accurate (aside from Server 2012).
Before I use this to send it to everyone, please give it a try and let me know if you come across issues. I attached the code in a TXT file to this post.
‎08-27-2024 10:06 AM
The Patch status column is still in the report, so you can still do that. If you don't have that column in your report, copy the latest version from the website again.
‎07-18-2024 02:27 PM
Report shows my Server 2019 devices as "EOL, update to a higher Windows version". The 2019 condition needs to be above the build 17763 condition as below
WHEN tsysOS.OScode LIKE '10.0.17134%' THEN 'EOL, update to a higher Windows version'
WHEN tsysOS.OSname = 'Win 2019' And SubQuery2.Buildnumber >= 6054 Then 'Up to date'
WHEN tsysOS.OScode LIKE '10.0.17763%' AND tblOperatingsystem.Caption NOT LIKE '%LTSC%' THEN 'EOL, update to a higher Windows version'
WHEN tsysOS.OScode LIKE '10.0.17763%' AND tblOperatingsystem.Caption LIKE '%LTSC%' And SubQuery2.Buildnumber >= 6054 Then 'Up to date'
‎07-18-2024 02:40 PM
I see what happened, its because the change I did with the wildcards. The SQL case statement is performed from top to bottom. So it matches with the non version OS first and therefore gives a false result.
The actual build number is correct though. The V3 version should fix that issue.
‎07-18-2024 02:33 PM
Also needs another condition added to prevent out-of-date Server 2019 devices showing as EOL
WHEN tsysOS.OSname = 'Win 2019' And SubQuery2.Buildnumber < 6054 Then 'Out of date'
‎07-18-2024 03:15 PM
‎07-18-2024 06:58 PM
Issue with priority of OR/AND is presented again
‎07-19-2024 05:32 PM
‎07-22-2024 05:31 AM
Not fixed in backgroundcolor section
‎07-23-2024 02:19 PM
‎07-18-2024 02:48 PM
you are right, but I think I'll mess with the wildcards instead.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now