custom report in wsus

hi,

please assist me in writing custom  sql query in wsus server.

existing report not generate desire report.

below criteria needs included in report

servername  os version    ipaddress     wsus server group  missing patches compliance

hi,

here is a good reference:

http://blogs.technet.com/b/wsus/archive/2008/06/20/baseline-compliance-report-using-public-wsus-views.aspx

also, here technical article public view:

https://msdn.microsoft.com/en-us/library/bb410149%28v=vs.85%29.aspx?f=255&mspperror=-2147217396

best regards.

---

steven lee please remember mark replies answers if , unmark them if provide no help. if have feedback technet support, contact tnmff@microsoft.com.

Windows Server  >  WSUS