Windows Targeted Update Compliance By Computer - ITMS 7.1 SP2
- Download the attached stored procedure and run it in Management Studio. It will create the new stored procedure needed for the report (spPMWindows_TargetedUpdateComplianceByComputer).
- 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.