I am trying to get some windows patching data that breaks down patches by the MS## and Computer Type Property. I dont need a graph but just a table similar to the following.
You can make a full custom report for this or you can try using the Excel connector…
Here is some relevance to get the number of patches that are needed for each year (for all computers):
sum of (number of applicable computers of bes fixlets whose (name of it starts with “MS09”)),sum of (number of applicable computers of bes fixlets whose (name of it starts with “MS10”))
You can filter by servers / workstations to get the individual totals (or we can modify the relevance to filter).