K1000 Report for patches deployed during December 2014 and the completion percentage?
I was requested to supply a report of all patches deployed in December 2014 and the percentage of completion for those patches, and I'm trying to figure out how to create a report for this. We deploy patches once a month during maintenance against patch labels and machine labels. The K1000 I'm working with only contains Windows Servers as clients, and is running version 6.2.109330.
I found the "Patch listing completion rate by patch (server)" report from http://www.itninja.com/blog/view/k1000-reports-patching-reports-for-completion-by-patch-machine-vendor-using-labels that outputs the patches, their patched/not patched counts, a completion percentage, and the release date of the patch. I like the format (and most of the contents) of that report, but I'd like to modify that to remove the release date of the patch and rather include the deploy date to be between 12/1/2014 and 1/1/2015. I believe I need to use the S.DEPLOY_STATUS_DT field in a SQL statement to achieve this, but I'm not sure how to format the date range or even how to use that field in a SQL statement. I'd also like to not limit it to "critical" patches as this report is set to do, but all patches that were deployed during that time.Any advice on how to achieve this goal?