SQL Views for Windows Updates RRS feed

  • Question

  • Hi Folks,

                 Under our governance policy our security team evaluate and approve/reject windows updates for deployment.  They do this by making updates as approved or not in SCCM.  The approved updates are then deployed to our server fleet (as per our deployment policy) via SCCM.  Sometimes however we need a list of approved update by operating system for use outside SCCM, e.g. updating offline images.

    I was hoping to find a way to extract this information from the database, and maybe turning it into a custom report.  The SQL view 'v_UpdateInfo' seems to fit the bill with the 'IsDeployed' flag. But I can't figure out a way from that view to work out which major OS release the update applies to, e.g. 2008 R2, 2012, 2012 R2, etc.  Is there a view that I can join to in order to find this information out?

    Thursday, March 12, 2015 6:11 AM