KACE Product Support Question
K1000: Top 10 Missing Critical Windows Patches
08/20/2015 1080 views
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..
Be the first to answer this question