Tutorial need for WSUS APIs to Create Custom Reports

saravanapaul s 96 Reputation points
2021-01-04T03:40:22.397+00:00

HI,

We are using windows 2012 server for wsus. Now we have planned to create separate computer group for Work from home users in the WSUS server. We need to create custom report for particular computer group every month with approved updated percentage wise. is it possible to create the reports using windows API. I don't aware of the sql scripts. Work from users are connected our WSUS server through VPN access. Kindly advise and provide step by step tutorial. I am new in the WSUS domain.

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,209 questions
{count} votes

Accepted answer
  1. saravanapaul s 96 Reputation points
    2021-01-06T02:18:38.983+00:00

    Hi Rita,

    One more quires, is there any best option to implement patch updates for Permanent Work from users over VPN.
    We have already implemented as same like office environment and GPO applied as daily sync with WSUS server to the client. but most of the PWFH clients not sync automatically and downloaded the patches through our WSUS server via VPN. every time our IT engineers action required for manual update. Please guide us if any best option is there using our WSUS server.

    0 comments No comments

4 additional answers

Sort by: Most helpful
  1. Rita Hu -MSFT 9,641 Reputation points
    2021-01-06T01:33:13.127+00:00

    Hi saravanapauls-3857,

    I researched many articles and tested it in my lab environment. There is no such script which could achieve this feature. But we could check the installation status and install Percentage on the WSUS console. Please refer to the below picture:

    Tick the options on the WSUS console:
    53791-2.png

    Reference picture:
    53801-3.png

    In addition, the WSUS in-build report could make this feature come turn. Please refer to the below picture to create the report:
    53811-4.png

    Also I will research other scripts to see whether this issue will be resolved or not. In my opinion, WSUS did not have the other report except the in-build report. I will test the PowerShell script by others in my environment first. If there are any updates, I will inform you at once.

    Thanks for your time and have a nice day.

    Regards,
    Rita


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. saravanapaul s 96 Reputation points
    2021-01-06T02:11:54.227+00:00

    Hi Rita,

    Thanks for your response and valuable time . We have already using the above mentioned options.
    But as per our management requirement those option not given the full filled data's. So that i have raised the queries in this forum. Any how we will check and update if any solution figured out.


  3. Adam J. Marshall 9,506 Reputation points MVP
    2021-01-06T02:26:25.56+00:00

  4. Rita Hu -MSFT 9,641 Reputation points
    2021-01-06T02:31:39.19+00:00

    Hello,

    We could apply the below policy to prevent the clients from getting updates from the Internet.
    53824-6.png

    Regards,
    Rita


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.