10 Replies Latest reply on Mar 9, 2015 5:24 PM by charlesnm

    3rd Party Patch Reporting

    ak00

      In the PatchManager MMC I have an Update View called 3rd Party Updates.

      In that view the only criteria states that "Updates source is Third Party Updates"


      3rdPartyUpdates.jpg

       

      Question:  How do I configure/run a report that will show me of all the items/packages in that view, on which computers, they have been installed, and when?

      Suggestions?

       

      Thanks!

        • Re: 3rd Party Patch Reporting
          phil3

          Here's a KB article that will help:

           

          SolarWinds Knowledge Base :: How to create a Patch Manager report that shows only third-party updates

           

          If necessary, you can add/remove/modify fields and filters to provide the exact information you want.

           

          Let me know if you have any other questions.

           

          Phil

          • Re: 3rd Party Patch Reporting
            ak00

            Still getting nothing in the report - but noticed this error....

             

            Exception Details

            Computer:  WSUSSERVER

            Object:  report

            Source:  Data Grid Server (WSUSSERVER)

            Message:

            Exception occurred at 6/5/2012 11:24:29 AM: Incorrect syntax near the keyword 'WHEN'. Incorrect syntax near the keyword 'AS'. Incorrect syntax near the keyword 'WHEN'. Incorrect syntax near the keyword 'AS'. Incorrect syntax near 'END'. An exception occurred while executing a Transact-SQL statement or batch. Create failed for StoredProcedure 'dbo.tempreportsp-275eb965-b72f-4ce1-be09-20501796470d'. Unable to retrieve the information from the database. Message: Create failed for StoredProcedure 'dbo.tempreportsp-275eb965-b72f-4ce1-be09-20501796470d'. An exception occurred while executing a Transact-SQL statement or batch. Stored Procedure: BEGIN WITH ResultPage AS ( SELECT *,ROW_NUMBER() OVER (ORDER BY [Computer Name] ASC, [Update Title] ASC, UpdateInstallationState WHEN 0 THEN 'Unknown' WHEN 1 THEN 'NotApplicable' WHEN 2 THEN 'NotInstalled' WHEN 3 THEN 'Downloaded' WHEN 4 THEN 'Installed' WHEN 5 THEN 'Failed' WHEN 6 THEN 'Installed Pending Reboot' ELSE 'Unknown' END END ) ASC) AS RowNumber FROM ( SELECT dbo.WSUS_ComputerUpdateStatusToUpdatesView.fulldomainname AS [Computer Name], dbo.WSUS_ComputerUpdateStatusToUpdatesView.title AS [Update Title], (CASE WHEN dbo.WSUS_ComputerUpdateStatusToUpdatesView.UpdateInstallationState IS NULL THEN NULL ELSE CASE dbo.WSUS_ComputerUpdateStatusToUpdatesView.UpdateInstallationState WHEN 0 THEN 'Unknown' WHEN 1 THEN 'NotApplicable' WHEN 2 THEN 'NotInstalled' WHEN 3 THEN 'Downloaded' WHEN 4 THEN 'Installed' WHEN 5 THEN 'Failed' WHEN 6 THEN 'Installed Pending Reboot' ELSE 'Unknown' END END ) AS [Update Installation State (Friendly Name)], dbo.WSUS_ComputerUpdateStatusToUpdatesView.UpdateSource AS [Update Source], dbo.WSUS_ComputerUpdateStatusToUpdatesView.State FROM dbo.WSUS_ComputerUpdateStatusToUpdatesView WHERE dbo.WSUS_ComputerUpdateStatusToUpdatesView.UpdateSource = 'Other' ) AS InnerPage ) SELECT * FROM ResultPage WHERE RowNumber BETWEEN (@PageNum - 1) * @PageSize + 1 AND @PageNum * @PageSize ORDER BY RowNumber ASC; WITH ResultPage AS ( SELECT *,ROW_NUMBER() OVER (ORDER BY [Computer Name] ASC, [Update Title] ASC, UpdateInstallationState WHEN 0 THEN 'Unknown' WHEN 1 THEN 'NotApplicable' WHEN 2 THEN 'NotInstalled' WHEN 3 THEN 'Downloaded' WHEN 4 THEN 'Installed' WHEN 5 THEN 'Failed' WHEN 6 THEN 'Installed Pending Reboot' ELSE 'Unknown' END END ) ASC) AS RowNumber FROM ( SELECT dbo.WSUS_ComputerUpdateStatusToUpdatesView.fulldomainname AS [Computer Name], dbo.WSUS_ComputerUpdateStatusToUpdatesView.title AS [Update Title], (CASE WHEN dbo.WSUS_ComputerUpdateStatusToUpdatesView.UpdateInstallationState IS NULL THEN NULL ELSE CASE dbo.WSUS_ComputerUpdateStatusToUpdatesView.UpdateInstallationState WHEN 0 THEN 'Unknown' WHEN 1 THEN 'NotApplicable' WHEN 2 THEN 'NotInstalled' WHEN 3 THEN 'Downloaded' WHEN 4 THEN 'Installed' WHEN 5 THEN 'Failed' WHEN 6 THEN 'Installed Pending Reboot' ELSE 'Unknown' END END ) AS [Update Installation State (Friendly Name)], dbo.WSUS_ComputerUpdateStatusToUpdatesView.UpdateSource AS [Update Source], dbo.WSUS_ComputerUpdateStatusToUpdatesView.State FROM dbo.WSUS_ComputerUpdateStatusToUpdatesView WHERE dbo.WSUS_ComputerUpdateStatusToUpdatesView.UpdateSource = 'Other' ) AS InnerPage ) SELECT @TotalRowsNum = COUNT(*) FROM ResultPage; END

            • Re: 3rd Party Patch Reporting
              chechuoi

              I am new to this and I found these steps to be helpful. I hope this helps some newbies like myself.

               

              To create a custom WSUS report For ALL updates

              1. 1. In the left pane of the Patch Manager console, expand Administration and Reporting > Reporting > WSUS Reports.
              2. 2. Select Windows Server Update Services Analytics.
              3. 3. In the center pane, select Computer Update Status.
              4. 4. Under Available Datasources, select Computer Update Status With Update Information.
              5. 5. Under Available Fields, use Ctrl+click to select the following fields in this order:
              6. a. Computer Name
              7. b. Update Title
              8. c. Update Installation State (Friendly Name)
              9. d. Update ID
              10. e. Update Revision Number
              11. f. Name (Update Server)
              12. 6. In the Actions pane (right), click New Report.
              13. 7. Apply a sort preference to one of the columns:
              14. a. Click Not Sorted next to the column name.
              15. b. Point to Sort position 1, and then select a sort option. SolarWinds Patch Manager ³ Administrator Guide

              Inventory and Reporting

              1. 8. Add a filter to the report for updates that will install upon approval:
              2. a. Click [+] under Select the filter criteria for the report.
              3. b. Click Select Field for the new filter entry.
              4. c. Point to Computer Update Status With Update Information, and then select Update Approval Action (Friendly Name).
              5. d. Next to the new field name, click Select Operator, and then select equals.
              6. e. Next to the new operator, click <Enter Value>, and then select Enter Value.
              7. f. In the text box, enter Install.
              8. 9. Add a filter to the report for updates with states that are not Installed or Unknown:
              9. a. Click [+] next to the existing filter.
              10. b. Click Select Field for the new filter entry.
              11. c. Point to Computer Update Status With Update Information, and then select Update Installation State (Friendly Name).
              12. d. Next to the new field name, click Select Operator, and then select does not equal.
              13. e. Next to the new operator, click <Enter Value>, and then select Enter Value.
              14. f. In the text box, enter Installed.
              15. g. Click the arrow to the left of this filter, and then select Place in New Group.
              16. h. Click [+] within the new group.
              17. i. Click Select Field for the new filter entry.
              18. j. Point to Computer Update Status With Update Information, and then select Update Installation State (Friendly Name).
              19. k. Next to the new field name, click Select Operator, and then select does not equal.
              20. l. Next to the new operator, click <Enter Value>, and then select Enter Value.
              21. m. In the text box, enter Unknown.
              22. 10. Click Next. Administrator Guide ³ SolarWinds Patch Manager
              23. 11. In the Report Name field, enter a unique name. For example, enter Computers to Update.
              24. 12. Select Save and run report now.
              25. 13. Click Finish

              For 3rd Party Only add a few more steps to Step 9:

              1. 9.1 Click the arrow to the left of this filter, and then select Place in New Group.
              2. 9.2 Click [+] within the new group.
              3. 9.3 Click Select Field for the new filter entry.
              4. 9.4Point to Computer Update Status With Update Information, and then select Update Installation State (Friendly Name).
              5. 9.5Next to the new field name, click Select Operator, and then select equals.
              6. 9.6Next to the new operator, click <Enter Value>, and then select Enter Value.
              7. 9.7 In the text box, enter Other.

               

              1. 10. Click Next. Administrator Guide ³ SolarWinds Patch Manager
              2. 11. In the Report Name field, enter a unique name. For example, enter Computers to Update.
              3. 12. Select Save and run report now.
              4. 13. Click Finish

               

              Additional Tips: Remove or Add more fields if you wish. I found the date arrival to be useful.