K1000: Top 10 Missing Critical Windows Patches
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..
Please log in to answer
Be the first to answer this question