Monday, December 10, 2012 7:00 AM
My wsus server is synchronizing with Microsoft’s wsus. Doing manual synchronization on second week of Wednesday.
Now I’ve to prepare the patch report on monthly basis.
Technically requesting I want the security updates and critical updates for 2003R2 and 2008R2 servers for Nov-2012 like this I’ve to prepare the patch report on every month.
How to perform the task.
Tuesday, December 11, 2012 3:24 AMModeratorHi,
Pls click the reports option in the left pane,then click update detailed status in the central pane.In the report option,filter by the security updates and critical updates for 2003R2 and 2008R2 servers,Click Run report.If the basic reporting functionality doesn't meet your requirement,see the section Creating Reports. At the end of the section, of particular note, are these paragraphs:
You can customize WSUS reports in different ways:
- Use the WSUS APIs to create a custom report
- 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 (http://go.microsoft.com/fwlink/?LinkId=85713). 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 (http://go.microsoft.com/fwlink/?LinkId=85715.) 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 (http://go.microsoft.com/fwlink/?LinkId=70728).
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
- Marked As Answer by Clarence ZhangModerator Monday, December 17, 2012 2:44 AM