Is there anyway to get windows update reports like pending updates, last patched kind of report for the nodes?
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
No i dont have patch manager, i'm talking is there anything with NPM and SAM. If we can get some reports for patching
There is a little bit of info in the Asset Inventory screen in SAM and you can do some reporting off of that data:
I didn't know that field was even there, Good call, and well played. Thanks.
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.
this is interesting
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.
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:
class="Term"
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
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
This component monitor shows amount of available hidden updates.
This component monitor shows amount of available critical updates. Should always be zero.
This component monitor shows amount of available optional updates.
This component monitor shows amount of installed updates.
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.
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
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?
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.
Once you get what you want then can add a custom query resource to your web pages to display the results.
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.
I have inventory enabled for all nodes. Where can I find "Add Column"
