Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

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