Windows Patches needed

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.

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:
 

    $LAST_UPDATE_KEY_PATH = "HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Detect"

    If (Test-Path -Path $LAST_UPDATE_KEY_PATH)
    {
      $lastSuccessTime = [datetime](Get-ItemProperty -Path $LAST_UPDATE_KEY_PATH -name "LastSuccessTime").LastSuccessTime
          
      $DayDiff = $(New-TimeSpan -start $lastSuccessTime).Days
    }
    else
    {
      $DayDiff = -1
    }
    

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

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.

Thanks Mike, that's cool.

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.

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

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.

This is very nice, thanks!

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