Microsoft Patch Tuesday - August 2024

[Esben_D]

The August 2024 edition of Patch Tuesday brings us 86 new fixes, with 7 rated as critical and 6 exploited. Additionally, I've also used the the new format of report as was discussed on the forum here: https://community.lansweeper.com/t5/reports-analytics/patch-tuesday-improvement/m-p/75608

You can find all the info and report in the August blog post.

[Jvdster]

Good morning, in July there was still the "State" colum showing either Up to date or Out of date, it made for easy sorting. That seems to be gone now. Is there a way I could re-add this? I tried just copy pasting the line from the Patch Tuesday in July but that doesn't work.

[donohue17]

i agree with @Jvdster about wanting that column (State) back. that is an easy way to filter out the items that are already patched and only looking at what is left to patch. please bring that back. 

[Esben_D]

@Jvdster @donohue17 Its back!

I forgot to add it back after I did some changes.

[Ode2Joy]

Very nice, @Esben_D.  I really do like this new format.  One last thing for me: Is it possible to make the "EOL, update to a higher Windows version" lines show up in red?  Currently, they're marked green.

[Esben_D]

@JanC Can you refresh the report web page and copy the new version and try again?

I suspect there is a strange string in your tblUptime.EventTime which isn't a date and that is causing the conversion to fail. I added something to the query so that it only attempts to convert if its a date.

[Esben_D]

@Ode2Joy Fixed it! Another mistake 😅

[Ode2Joy]

This is a thing of beauty!  Thanks, @Esben_D!

[BethRich]

I have both the July audit report and the August audit report in the on-prem reports. The August report has fewer devices that meet the criteria for selection.

[Esben_D]

@BethRich I changed an inner join to a left join, which might fix it. If it doesn't I wouldn't know what would.

[BethRich]

@Esben_D 

Thank you. That brought back 2 of the 4 that were missing. I will try to see what happened to the other 2.

[BethRich]

@Esben_D 

Toward the middle of the joins, below ranked events, there is an inner join with tblQuickFixEngineering that appears to be the problem. By changing it to a left join or by commenting it out, the right number of assets are reported. I did not validate the report content and will leave that to you to sort out.

Thanks

[Esben_D]

@BethRich I see, I adjusted it as well. See if the new version is the same as yours.

[BethRich]

@Esben_D  The August count is now matching to the July count. Thank you.

I do have a comment. I had based a chart on the old subquery1 to put on a dashboard for patches. This new code is not sinking into my brain. It would be really appreciated if there was also a chart query each month, along with the report query.

[Esben_D]

@BethRich Yeah that sounds like a good idea. I've optimized the new report as well to make it easier for me to update every month, hence why is it has changed so much.

If I find some more spare time I'll take a look at it, but I can't make a promise. I might just use the September Pro Tips as an excuse to talk about Patch Tuesday and add some extra things like a chart example so people can easily create it themselves every month (it should just be copy-paste a specific piece of the report every month).

[GWVS]

@Esben_D  Hi, thank you for the monthly report! Unfortunately in this version I also get a date conversion error like @JanC, except my message is in german:  "Fehler beim Konvertieren einer Zeichenfolge in ein Datum und/oder eine Uhrzeit."