want to know the view in the SQL server, that gives the below data from a WSUS 3.0 SP2 server.
this is to take the patch compliance information directly from SQL views, instead of using "Update Services 3.0 API Samples and Tools"
Update Name(KB#) (strPatchTitle) Classification (update.UpdateClassificationTitle) Status (UpdateStatus.UpdateInstallationState.ToString) Host Name (computer.FullDomainName) Last Reported (computer.LastReportedStatusTime.ToString) Bullettin (UpdateStatus.GetUpdate.Title)
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.