none
Limit 'Specific computer' report to a Software Update Group RRS feed

  • Question

  • I'm trying to get the SCCM 2012 report 'Compliance 5 - Specific computer' limited to an updae group rather than reporting against every applicable patch.

    In the environment I'm working in we are only interested in reporting on compliance against an agreed list of 'released' updates (we don't release all updates to our server estate). When you start reporting with the 'Compliance 1  - Overall compliance' we can select our 'master' software update group here and get the correct compliance status. We can then drillthrough these status into the next report, 'Compliance 7' and the update group is passed through into this report along with the collection and relevant status.

    However when we drillthrough to the next report, 'Compliance 5 - Specific computer', the update group is not passed through or used in this report so we get a compliance status for the specific computer against every update. I want to use the update group in the last report to limit what's returned here.

    Can anyone help with this? I'm lacking the SQL expertise to be able to add the relevant code to the last report.

    Friday, October 17, 2014 12:29 PM

Answers

All replies

  • I think you're looking for the Compliance 3 - Update group (per update) report. In this report you can select an update group and a collection and the report will return the compliance data of that combination.

    My Blog: http://www.petervanderwoude.nl/
    Follow me on twitter: pvanderwoude

    • Proposed as answer by Joyce LModerator Monday, October 20, 2014 7:30 AM
    • Unproposed as answer by Stephen Ess Monday, October 20, 2014 8:49 AM
    Friday, October 17, 2014 6:19 PM
  • I think you're looking for the Compliance 3 - Update group (per update) report. In this report you can select an update group and a collection and the report will return the compliance data of that combination.

    My Blog: http://www.petervanderwoude.nl/
    Follow me on twitter: pvanderwoude


    The report 'Compliance 3..' is a summary report for each patch against a collection. This is completely different from I'm trying to achieve which is a detailed breakdown of compliance against each patch in an update group for a specific computer.
    Monday, October 20, 2014 8:48 AM
  • Yes, I know this is an old post, but I’m trying to clean them up. Did you solve this problem, if so what was the solution?


    Garth Jones | My blogs: Enhansoft and Old Blog site | Twitter: @GarthMJ

    Saturday, July 4, 2015 5:05 PM
    Moderator
  • Since no one has answer this post, I recommend opening  a support case with Microsoft Customer Support Services (CSS) as they can work with you to solve this problem.


    Garth Jones | My blogs: Enhansoft and Old Blog site | Twitter: @GarthMJ

    Saturday, August 22, 2015 2:32 PM
    Moderator