Windows Patches needed

N7R7YZ

See details on my blog . A DataSource that shows which Windows patches are needed. The patch names, and KB numbers show as instances and are grouped by Microsoft's 'classifications'. A special instance named 'summary' shows how many days since the last patch was installed and how many patches are needed.

Mike_Suding

Posted 7 years ago·Last reply 4 years ago

14 comments

ASCoates

·4 years ago

Apologies for reviving a somewhat old thread, this is working great for us so far
I was just wondering if its possible to turn the data into a dashboard?

As an example it would display / work something like this -

Widget: Security Updates
KB name/ information: KB4579979
Devices required: 5

Then click the 5 would display the machines its required on

Is something like this possible?

LM User

·5 years ago

WinRM is failing to connect to that server. Do you have WinRM enabled on that server and all the right credentials loaded into LM as properties on that device?

Dominique

·5 years ago

Hello,

This is my selection it should be 43 items but I have only 23 machines after 12 hours which get the datasource!

Looking in this issue

Thanks,

Dom

Dominique

·5 years ago

On 10/1/2018 at 7:40 AM, Mike Suding said:

N7R7YZ

See details on my blog . A DataSource that shows which Windows patches are needed. The patch names, and KB numbers show as instances and are grouped by Microsoft's 'classifications'. A special instance named 'summary' shows how many days since the last patch was installed and how many patches are needed.

Hello,

I imported the XML and now I am testing on a group of machines...

Several machines did not get the datasource at all...

For the machines receiving the datasource I have an issue with the parameter "updatecount"

It remains empty...

Any idea why?

THanks,

Dom

Vitor_Santos

·5 years ago

This is very nice, thanks!

Mosh

·5 years ago

On 1/6/2021 at 9:00 PM, Shack said:

@Mosh do you have this datasource alerting for you? Interested in seeing if I can get it to work.

Hi, yes it works okay for us.

Shack

·5 years ago

14 minutes ago, Shack said:
Tried this in my portal today and it fails during import with the error below.
Failed to parse LogicModule from XML: org.xml.sax.SAXParseException; lineNumber: 68; columnNumber: 90; Attribute name "data-pjax-transient" associated with an element type "meta" must be followed by the ' = ' character.

Appears to of imported even with the error above. Disregard.

Shack

·5 years ago

@Mosh do you have this datasource alerting for you? Interested in seeing if I can get it to work.

Shack

·5 years ago

Tried this in my portal today and it fails during import with the error below.


Failed to parse LogicModule from XML: org.xml.sax.SAXParseException; lineNumber: 68; columnNumber: 90; Attribute name "data-pjax-transient" associated with an element type "meta" must be followed by the ' = ' character.

LM User

·6 years ago

The KB# appears to be the first part of the instance name. I haven't looked at the code, but you could likely modify it to store the KB# as an instance level property.

Dominique

·6 years ago

Hello,

Excellent post thanks!

I wonder if we could add the KB# in the datapoint or there is another way to get them in a widget?

Thanks,

Dom

Mosh

·7 years ago

Hi @Mike Suding

I have found that sometimes it is possible to get a false $DayDiff when going by the most recently installed update. I found an example on a server where an older roll-up was installed recently and the returned date was way in the past. So, I'm using the following method, which so far has been returning the expected results:


    <span style="color:#b8860b;">$LAST_UPDATE_KEY_PATH</span> = <span style="color:#bb4444;">"HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Detect"</span>

    <span style="color:#aa22ff;">If</span> (<span style="color:#aa22ff;">Test-Path</span> -Path <span style="color:#b8860b;">$LAST_UPDATE_KEY_PATH</span>)
    {
      <span style="color:#b8860b;">$lastSuccessTime</span> = <span style="color:#880000;">[datetime]</span>(<span style="color:#aa22ff;">Get-ItemProperty</span> -Path <span style="color:#b8860b;">$LAST_UPDATE_KEY_PATH</span> -name <span style="color:#bb4444;">"LastSuccessTime"</span>).LastSuccessTime
          
      <span style="color:#b8860b;">$DayDiff</span> = $(<span style="color:#aa22ff;">New-TimeSpan</span> -start <span style="color:#b8860b;">$lastSuccessTime</span>).Days
    }
    <span style="color:#aa22ff;">else</span>
    {
      <span style="color:#b8860b;">$DayDiff</span> = -1
    }

Mosh

·7 years ago

Thanks Mike, that's cool.