Duplicate Update Titles in reports

Question

I'm looking for a report that will display the name of the computer and possibly it's group membership with the total count of updates approved, not installed and installed, and the IP of the machine. Currently I have a report but it doesn't seem to make much sense. I'm seeing counts but they are for the updates themselves thought the computer name is also repeated. Some of these updates are duplicates across the row and just taking up space. Is there a way to craft a simple report rather than pages upon pages of information that would then have to be sifted through?

LGarvin · Accepted Answer

There are a couple of ways to create this report.

The count columns you've selected are the count of computers in each state for the selected update, which is identified in the Update Title column, but I believe what you actually want is the count of *updates* for each Computer Name. The Computer Update Status with Aggregate Counts of Install State for Approved Updates report template is likely a good place to start. If you want the counts in columnar form, you can export the report to Excel and pivot.