Video Screencast Help

Windows Targeted Update Compliance By Computer - ITMS 7.1 SP2

Created: 17 Sep 2012 | 1 comment
Andrew Bosch's picture
+1 1 Vote
Login to vote
This requires ITMS 7.1 SP2
I have modified the Windows Compliance By Computer report and created a new report called Windows Targeted Update Compliance By Computer.  Follow these steps.
  1. Download the attached stored procedure and run it in Management Studio.  It will create the new stored procedure needed for the report (spPMWindows_TargetedUpdateComplianceByComputer).
  2. Import the provided report XML by navigating to Reports->All Reports->Software->Patch Management.  Right click on the Compliance folder and choose Import.  Select the XML provided in the attachment.

You should now have a compliance by computer report that only includes updates that are included in a Patch policy.  The Distribution Status filter can be used to include all targeted updates or only those that are "active".  "Active" means that the policy of which they are a part of, is enabled.

Comments 1 CommentJump to latest comment

Rick D's picture

Good stuff, thank you.  Wish there was an easier way!

Login to vote