I have recently configured a WSUS server in my environment and I am running into problems with the WSUS Reports not being in-depth enough to give to an auditor. I am looking to be able to query:
1. A server name
2. The updates that were installed to it
3. The date when the updates were installed.
I am running my WSUS Database on a SQL Server and am aware of the WSUS views. I have little experience with databases and am having trouble finding a query that would suit my needs. I have been following "http://msdn.microsoft.com/en-us/library/windows/desktop/bb410149(v=vs.85).aspx"
but have not been getting far.
Has anyone made any custom queries that would be able to help me out?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.