Sign in
Microsoft.com
 
Windows Server TechCenter
 
 
 
Windows Server TechCenter > Windows Server Forums > WSUS > WSUS connecting to DB and reporting
Ask a questionAsk a question
Search Forums:
 

AnswerWSUS connecting to DB and reporting

  • Thursday, October 29, 2009 4:38 PMJaydDeuce Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Can anyone send me a guide on how to setup either MS Query or SQL query to connect to the WSUS Internal Db to view/run reports.

    I've seen a lot of VB scirpts etc...but would like to use the MS query or SQL query

    New to reporting....i've used wsus for years....but now required to run some custom reports.....help would be great and appreciated.

    Thanks
     

Answers

  • Thursday, October 29, 2009 9:35 PMLawrence GarvinMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    > Can anyone send me a guide on how to setup either MS Query or SQL query to connect to the WSUS Internal Db to view/run reports.

    Nope. It doesn't exist. :-)

    Directly accessing the database objects is not a supported activity.

    What is supported is using the SQL Server Report Builder and accessing data through the pre-defined PUBLIC VIEWS.

    See "Extending Reports" in the Creating Reports section of the WSUS Operations Guide. (Reprinted below for convenience.)

    If you're seriously interested in custom reporting, you might also find some value in the WSUS Extension Pack from EminentWare.

    Extending Reports

    You can customize WSUS reports in different ways:

    1. Use the WSUS APIs to create a custom report
    2. Use WSUS public views to create and extend custom reports

    Use WSUS APIs to Create Custom Reports

    For more information on WSUS APIs, see the Windows Server Update Services SDK documentation on MSDN. You can use these APIs to create reports on updates, approvals, installation information, and the like.

    Use WSUS Public Views to Create Custom Reports

    For more information on public views, as well as sample queries, see the WSUS SDK conceptual documentation on MSDN. If you are using SQL Server as the WSUS database, you can use the SQL Server Report Builder to generate custom reports using these views, or you can access the views from the command line. If you are using Windows Internal Database as the WSUS database, you can access it via the command line if you download the Microsoft SQL Server Command Line Query Utility and the SQL Native Client. You can download the install packages from the Microsoft Download Center.

    Lawrence Garvin, M.S., MCITP:EA, MCDBA
    Principal/CTO, Onsite Technology Solutions, Houston, Texas
    Microsoft MVP - Software Distribution (2005-2009)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    My Blog: http://onsitechsolutions.spaces.live.com
     

All Replies

  • Thursday, October 29, 2009 9:35 PMLawrence GarvinMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    > Can anyone send me a guide on how to setup either MS Query or SQL query to connect to the WSUS Internal Db to view/run reports.

    Nope. It doesn't exist. :-)

    Directly accessing the database objects is not a supported activity.

    What is supported is using the SQL Server Report Builder and accessing data through the pre-defined PUBLIC VIEWS.

    See "Extending Reports" in the Creating Reports section of the WSUS Operations Guide. (Reprinted below for convenience.)

    If you're seriously interested in custom reporting, you might also find some value in the WSUS Extension Pack from EminentWare.

    Extending Reports

    You can customize WSUS reports in different ways:

    1. Use the WSUS APIs to create a custom report
    2. Use WSUS public views to create and extend custom reports

    Use WSUS APIs to Create Custom Reports

    For more information on WSUS APIs, see the Windows Server Update Services SDK documentation on MSDN. You can use these APIs to create reports on updates, approvals, installation information, and the like.

    Use WSUS Public Views to Create Custom Reports

    For more information on public views, as well as sample queries, see the WSUS SDK conceptual documentation on MSDN. If you are using SQL Server as the WSUS database, you can use the SQL Server Report Builder to generate custom reports using these views, or you can access the views from the command line. If you are using Windows Internal Database as the WSUS database, you can access it via the command line if you download the Microsoft SQL Server Command Line Query Utility and the SQL Native Client. You can download the install packages from the Microsoft Download Center.

    Lawrence Garvin, M.S., MCITP:EA, MCDBA
    Principal/CTO, Onsite Technology Solutions, Houston, Texas
    Microsoft MVP - Software Distribution (2005-2009)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    My Blog: http://onsitechsolutions.spaces.live.com
     
  • Friday, November 06, 2009 8:42 AMEric Zhang - MSFTMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as ‘Answered’ as the previous steps should be helpful for many similar scenarios.

    If the issue still persists and you want to return to this question, please reply this post directly so we will be notified to follow it up. You can also choose to unmark the answer as you wish.

    In addition, we’d love to hear your feedback about the solution. By sharing your experience you can help other community members facing similar problems.

    Thanks!