Windows Update reports

[abishek.dhavala]

Is there anyway to get windows update reports like pending updates, last patched kind of report for the nodes?

[skyblademonkey]

Have a look @ SAM templates

Windows Update Monitoring

Available hidden updates

This component monitor returns the number of available hidden updates.

Available critical updates

This component monitor returns the number of available critical updates. This should always be zero.

Available optional updates

This component monitor returns the number of available optional updates.

Installed updates

This component monitor returns the number of installed updates.

Days passed from last Windows Update

This component monitor returns the number of days that have passed from the last Windows update installation. Additionally, this component returns the name of the last installed update.

Windows Updates activity status

This component monitor returns the installation status of Windows update.

Possible values:

• 0 – Windows currently is not installing updates.
• 1 – Windows currently is installing updates.

  class="Term"

• 1 – Reboot required before installing updates.

  class="Term"

• 1 – Updates installed. Reboot required.

Service: Windows Updates

This component monitors the Windows update service which enables the detection, download, and installation of updates for Windows and other programs. If this service is disabled, users of this computer will not be able to use Windows update or its automatic updating feature. If this service is down, programs will not be able to use the Windows Update Agent (WUA) API.

and

https://thwack.solarwinds.com/docs/DOC-147466#start=50

Windows Updates Monitoring

This template allows you to check status of Windows Updates. It monitors how many new (hidden, critical and optional) updates are available, how many updates installed, check is reboot required before/after installing updates and how many passed from last Windows Updates installation.

Prerequisites: WinRM must be installed and properly configured on the target server.

Credentials: Administrator on target server.

Monitored Components

Available hidden updates

This component monitor shows amount of available hidden updates.

Available critical updates

This component monitor shows amount of available critical updates. Should always be zero.

Available optional updates

This component monitor shows amount of available optional updates.

Installed updates

This component monitor shows amount of installed updates.

Days passed from last Windows Update

This component monitor returns how many days have passed from last Windows Updates installation. Also this component returns the name of last installed update.

Machine restart status after installing Windows Updates

This component monitor shows restart status after installing Windows Updates.

Possible values:
0 - No reboot requires.
1 - Updates installed. Reboot required.

Service: Windows Updates

This component monitors Windows Updates service which enables the detection, download, and installation of updates for Windows and other programs. If this service is disabled, users of this computer will not be able to use Windows Update or its automatic updating feature, and programs will not be able to use the Windows Update Agent (WUA) API.

You might also get some information using SWQL and the tables when collecting inventory.

SELECT Nodes.DisplayName, OSUpdates.DisplayName, OSUpdates.InstallDate, OSUpdates.InstalledBy, OSUpdates.Name, OSUpdates.Type, OSUpdates.Url FROM Orion.AssetInventory.OSUpdates INNER JOIN Orion.Nodes ON OSUpdates.NodeID=Nodes.NodeID

[aiolawale]

Thanks a million for your suggestion. However, I think SAM licenses is required to apply Windows Update Monitoring template to all my target systems but I don't have enough licenses for that. How do I use the SWQL query option or is there a way to create a custom report in Patch Manager to achieve the same results?

[skyblademonkey]

if want to do some quick testing on SWQL, change your web link to end with

    /Orion/admin/swis.aspx

Clear and paste in the query for some basic info.

SELECT Nodes.DisplayName, OSUpdates.DisplayName, OSUpdates.InstallDate, OSUpdates.InstalledBy, OSUpdates.Name, OSUpdates.Type, OSUpdates.Url FROM Orion.AssetInventory.OSUpdates INNER JOIN Orion.Nodes ON OSUpdates.NodeID=Nodes.NodeID

Once you get what you want then can add a custom query resource to your web pages to display the results.

[aiolawale]

Brilliant!! Thanks so much. I ran the query as directed and got useful report of installed updates per computer but how can I update the query to report on missing update per computer instead? Appreciate your help.

[bluefunelemental]

Don't forget to take into account the asset inventory polling date time.

its dot walkable from many of the asset inventory tables so easy to add a where statement like where daydiff(Your table.polling.lastpollingdate,getdate()) < 2

I found some of my results where from older stale asset inventory data till I ran this.

[jvb]

Are you already running patch manager or do you mean in conjunction with NPM /  SAM?

Your best bet for that would be Patch Manager:

Patch Manager

Patch Management Software - Software Patching | SolarWinds

[aiolawale]

Hi,

I'm also interested in creating reports to generate counts and list of missing approved updates for each computer on our network. We have Patch Manager but the report builder is not as user friendly like the Web Report Writer in Orion. I have so SAM with licenses just for the Domain Controllers and SQL Servers but would I be able to use it to generate update reports for all windows computers in the network?

Thanks in advance.

[jose.vazquez]

this is interesting

[abishek.dhavala]

No i dont have patch manager, i'm talking is there anything with NPM and SAM. If we can get some reports for patching

[jvb]

There is a little bit of info in the Asset Inventory screen in SAM and you can do some reporting off of that data:

[delfaver]

How do you get to the first image in your post?

[jvb]

Those icons should slide out from the left side of your node details page when you hover over them:

[mayur2]

I have inventory enabled for all nodes. Where can I find "Add Column"

[jeremymayfield]

I actually don't see the asset inventory area, mine looks different.  Where is that located.   Seems like in 12.1 RC we have some customizations and things appear differently.

[jvb]

Go to one of the nodes in question and click on "List Resources" ... Asset Inventory has to be selected for the left side navigation for it to appear.

Also remember this is SAM specific so if you meant you only have NPM 12.1 then Asset Inventory for servers will not be available.

[tallyrich]

Here's what I see under Node Details - I just updated to the latest RC(s) this week, but I've had this available for a while now.

[jeremymayfield]

I didn't know that field was even there, Good call, and well played.   Thanks.