nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

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"

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!

Find more posts tagged with

how-to

Accepted answers

All comments

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

ak00

Can you be more specific?

Both of those articles in there probably only make sense to someone who has created a lot of these reports (obviously not I).

This is what I did, and my results yielded nothing:

I went to WSUS Reports - Windows Server Update Service Analytics

Selected Computer Update Status with Update Information and created the following custom report:

Thanks!

David_Di_Blasio

Hi ak00,

I duplicated your report in my test environment and am getting the expected results. I think the next thing to look at is when/if wsus inventory was last run. Try running one now and then see if you get any results from the report. Here's a kb on how to run wsus inventory.

SolarWinds Knowledge Base :: How to configure Inventory tasks to populate Patch Manager reports

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

David_Di_Blasio

ak00,

I think your best bet for this particular issue would be to open a support case so someone on our team can take a closer look at what is happening. http://www.solarwinds.com/customerportal

ak00

Done. Thanks!

danielleh

ak00 - Could you please post your ticket #? Keep us updated with your progress.

Thanks!

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

Inventory and Reporting

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

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

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

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

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

charlesnm

I found this to be a lot of steps and very confusing to follow.