none
WSUS Files

    Question

  • We'd like to do some reports based on information in the WSUS database.  We need to list the patches in the database by OS and language.  We don't need them linked to computers, because we just need a report of what patches are available by OS and language and product if possible.  I know we're not supposed to query the database directly, but this is just for reporting purposes
    Friday, August 30, 2013 7:31 PM

All replies

  • We'd like to do some reports based on information in the WSUS database.  We need to list the patches in the database by OS and language.  We don't need them linked to computers, because we just need a report of what patches are available by OS and language and product if possible.  I know we're not supposed to query the database directly, but this is just for reporting purposes

    Custom Reports can be generated by using the PUBLIC_VIEWS documented in the WSUS SDK.

    Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
    SolarWinds Head Geek
    Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2013)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    http://www.solarwinds.com/gotmicrosoft
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.

    Saturday, August 31, 2013 2:12 AM
  • The PUBLIC_VIEWS give a lot useful information, but we can't figure out what patches go with what languages and what operating systems.  Is there some way to do that with the views?
    Thursday, September 05, 2013 10:34 PM
  • The PUBLIC_VIEWS give a lot useful information, but we can't figure out what patches go with what languages and what operating systems.  Is there some way to do that with the views?

    Possibly.. but I've not dived in that deep.

    But here's some bullet points that may help:

    • For the most part, these days, updates are language agnostic. The exception would be updates for XP/2003, which may not be because the OS is not.
    • Generally the language association is with the installation FILE, not the update itself, so if you're trying to map updates to languages, that won't likely get you anywhere. You can get a clue as to the expected file/language relationships by using the console to query for the File Information associated with the update.
    • To determine OS associations with UpdateID, the best approach is to retrieve the Update Title, where almost always the applicable OS has been explicitly stated.


    Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
    SolarWinds Head Geek
    Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2013)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    http://www.solarwinds.com/gotmicrosoft
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.

    Friday, September 06, 2013 3:08 AM