So I've been using SW PM for about 4 or 5 months or so. I am extremely new to the patching game and was thrown into it and have had to learn everything on my own. I'm just now trying to get reports to work. I used the following link to try the "Sample" report, but when I run it, I get 0 records returned.
SolarWinds Knowledge Base :: How to create a custom report using Patch Manager Report Definition Builder
Just in case the link doesn't work, I followed the below instructions to the letter and got 0 records returned. So I'm not sure what it is I'm missing...any help would be appreciated!
Thanks,
Jerm
To create a custom report that shows all pending updates (example):
- In the left pane of the Patch Manager console, expand Administration and Reporting > Reporting > WSUS Reports.
- Select Windows Server Update Services Analytics.
- In the center pane, select Computer Update Status.
- Under Available Datasources, select Computer Update Status With Update Information.
- Under Available Fields, use Ctrl+click to select the following fields in this order:
- Computer Name
- Update Title
- Update Installation State (Friendly Name)
- Update ID
- Update Revision Number
- Name (Update Server)
- In the Actions pane (right), click New Report.
- Apply a sort preference to one of the columns:
- Click Not Sorted next to the column name.
- Point to Sort position 1, and then select a sort option.
- Add a filter to the report for updates that will install upon approval:
- Click [+] under Select the filter criteria for the report.
- Click Select Field for the new filter entry.
- Point to Computer Update Status With Update Information, and then select Update Approval Action (Friendly Name).
- Next to the new field name, click Select Operator, and then select equals.
- Next to the new operator, click Enter Value, and then select Enter Value.
- In the text box, enter
Install.
- Add a filter to the report for updates with states that are not Installed or Unknown:
- Click [+] next to the existing filter.
- Click Select Field for the new filter entry.
- Point to Computer Update Status With Update Information, and then select Update Installation State (Friendly Name).
- Next to the new field name, click Select Operator, and then select does not equal.
- Next to the new operator, click Enter Value, and then select Enter Value.
- In the text box, enter
Installed. - Click the arrow to the left of this filter, and then select Place in New Group.
- Click [+] within the new group.
- Click Select Field for the new filter entry.
- Point to Computer Update Status With Update Information, and then select Update Installation State (Friendly Name).
- Next to the new field name, click Select Operator, and then select does not equal.
- Next to the new operator, click Enter Value, and then select Enter Value.
- In the text box, enter
Unknown.
- Click Next.
- In the Report Name field, enter a unique name. For example, enter
Computers to Update. - Select Save and run report now.
- Click Finish.