I am having difficulty creating a top 10 list of missing critical patches by machine count on our K1000 box. Any help on creating the SQL query for this report would be greatly appreciated.

It would be formatted something like below:

Critical Patch Name      |    # of systems missing this patch      |         # of systems this patch is applicable to
KB123456                                100                                                            120
KB7891011                                90                                                            120

and so forth..

0 Comments   [ - ] Hide Comments


Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity