Patch Manager Reporting: Multiple WSUS + Computer Groupings

Greetings,

I'm currently using Patch Manager v1.8 and managing multiple downstream WSUS servers.

I'm trying to create a report that shows

Name (Update Server)	Total Computers	Unassigned Computers	Windows Client	Windows Servers	Adobe Reader
Server 1	10	3	5	1	5
Server 2	20	5	10	2	10

The closest that I can get is:

Name (Update Server)	Computer Target Count	Name (Computer Group)	Domain (Update Server)
Server 1	3	Unassigned Computers	Domain. Name
Server 1	5	Windows Clients	Domain. Name
Server 1	1	Windows Servers	Domain. Name
Server 1	5	Adobe Reader	Domain. Name
Server 2	5	Unassigned Computers	Domain. Name
Server 2	10	Windows Clients	Domain. Name
Server 2	2	Windows Servers	Domain. Name
Server 2	5	Adobe Reader	Domain. Name

The objective is to have a consolidated report as I have over a hundred downstream servers.

The issue with this report is that there will be too many rows if I include 100 downstream servers.

Thanks in advance.

Cheers,

Shaiful Busari

Find more posts tagged with

Accepted answers

All comments

LGarvin

Greetings Shaiful

That is the extent of what you'll be able to get from the Patch Manager report itself, as Patch Manager has no way to define columns based on data values.

To convert what you have to what you want, I would suggest exporting to Excel and implementing a pivot table to make the Computer Group data be the column headers.

shaifulbusari

Greetings Lawrence,

Thanks for the update.

Was trying my luck hoping there would be a way to do it.

Another issue, how do I go about creating a report to see if the particular computer is 100% updated based on approved updates?

The objective is to do a summary for for all computers that is reporting to a WSUS.

Example:

Name (Server)	Computer Name	100%
WSUS01	Computer01	1
WSUS01	Computer02	0
WSUS01	Computer03	1

Note: 1 means 100% updated and 0 means not 100% updated, 99% or below

I'll then export this info to excel and create a pie chart.

If this isn't available, what is the next closes thing that I can have?

Cheers,

Shaiful Busari

LGarvin

This is also something you'll need to manipulate externally in Excel. Patch Manager does not have a boolean field for 100%patched-or-not. There is a system report that lists Percentage of Approved/Installed updates by Computer, and you can use an Excel formula to convert that percentage value (100% or not-100%) to a boolean value.

You could also define your pie chart based on the actual percentage (slice 1 = 100%; slice 2 = 0-99%) and not manipulate the data at all.

shaifulbusari

Greetings Lawrence,

Thanks again for the prompt reply.

I used the "Computers with approved update percentages" but is this only for Windows or inclusive of third party?

What can I do to create two separate reports for Windows Updates and Third Party?

Given that what I require is not off the shelf from Patch Manager, what reports do you feel is the most useful for which can be run automatically.

I am already running the 3rd party report which I took from one of your template (thanks for that =]) which is very useful, but I feel that there should be more off the shelf!

Cheers,

Shaiful Busari