locked
Custom Views in WSUS RRS feed

  • Question

  • I know that MS doesn't support directly editing the database in their products, but what I would like to know is..

    Does Microsoft support the creation of my own views in the SUSDB Database? Microsoft has not update the tbOSMap table since WSUS 3.2. I would like to create my own view for this with updated OS Descriptions.


    Mike Brown

    Wednesday, January 2, 2019 4:50 PM

All replies

  • Am 02.01.2019 schrieb Mike.Brown:

    Does Microsoft support the creation of my own views in the SUSDB Database?

    If you are user Windows Internal Database, you can not save your
    changes in SUSDB. You have to use SQL Express or higher.

    Microsoft has not update the tbOSMap table since WSUS 3.2. I would like to create my own view for this with updated OS Descriptions.

    Have a look at this Scripts:
    https://wsus.de/de/Scripts/Windows-Editionen-anzeigen
    https://wsus.de/de/update_betriebssystem_in_susdb

    You can use this Scripts hourly in a scheduled task.

    Winfried


    WSUS Package Publisher:
    https://github.com/DCourtel/Wsus_Package_Publisher
    http://technet.microsoft.com/en-us/windowsserver/bb332157.aspx
    http://www.wsuswiki.com/Home
    GP-PACK - PRIVACY AND TELEMETRIE: http://www.gp-pack.com/

    Wednesday, January 2, 2019 10:15 PM
  • Hello Mike Brown,
      
    It is not suggested to edit the database directly, but it is not absolute. Sometimes we have to edit it such as clearing the synchronization history or maintaining WSUS, etc.
     
    If we use WID for WSUS, when connecting the database enter \\.\pipe\MICROSOFT##WID\tsql\query for server name in case if we are connecting to Windows Server 2012 or 2016. If we are connecting to windows 2008 then we use \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
     
    For your question "Does Microsoft support the creation of my own views in the SUSDB Database?", the answer is that you could do that but do not forget to back up the database first.
     
    And could you tell us why you are doing this? Are there any issues when using WSUS?
     
    Hope my answer could help you and look forward to your feedback.
     
    Best Regards,
    Ray

    Please remembers to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Thursday, January 3, 2019 7:53 AM
  • As I stated in my initial post:

    Microsoft has not update the tbOSMap table since WSUS 3.2.

    We are using full SQL for managing the database.

    We would like to have the information that this table once provided. We have the skills and the expertise to create our own view for our customer oriented WSUS server. If Microsoft doesn't mind us editing tables, I would just add the new(er) OSes to this table. However, the safest edit for us (and probably most acceptable to Microsoft) would be to just create a new view that provides this information.

    So far, this is the only information I see within tables that could be of use, but is not provided in any of the views. As I continue to dig into the SUSDB, I may find more information that could be useful for our customer server management. We may wish to create additional views as information is discovered.


    Mike Brown

    Thursday, January 3, 2019 2:09 PM
  • Hello Mike Brown,
      
    We mainly discuss technical issues here. I am afraid we cannot give an exact answer to your question.
     
    I suggest that you could contact Microsoft directly for your issue. And we are happy to assist you with technology and usage here.
     
    Hope my answer could help you.
     
    Best Regards,
    Ray

    Please remembers to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Friday, January 4, 2019 2:23 AM
  • I know that MS doesn't support directly editing the database in their products, but what I would like to know is..

    Does Microsoft support the creation of my own views in the SUSDB Database? Microsoft has not update the tbOSMap table since WSUS 3.2. I would like to create my own view for this with updated OS Descriptions.


    Mike Brown

    Go for it. My software modifies the SUSDB quite heavily with Indexes and other 'voodoo magic' (a reference from actual users of my software).

    The worst thing that could happen is that you need to reinstall WSUS - and you can follow my guide for that - https://www.ajtek.ca/wsus/how-to-remove-wsus-completely-and-reinstall-it/


    Adam Marshall, MCSE: Security
    https://www.ajtek.ca
    Microsoft MVP - Windows and Devices for IT

    Friday, January 4, 2019 2:30 AM