15 Replies Latest reply on Sep 5, 2017 9:15 AM by mayur2

    Windows Update reports

    abishek.dhavala

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

        • Re: Windows Update reports
          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

          2 of 2 people found this helpful
          • Re: Windows Update reports
            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

            1 of 1 people found this helpful
              • Re: Windows Update reports
                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?

                  • Re: Windows Update reports
                    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.

                      • Re: Windows Update reports
                        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.

                          • Re: Windows Update reports
                            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.