View in WSUS 3.0 SP2
-
Monday, November 19, 2012 6:41 AM
Hi,
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)Kindly help.
thank you in advance.
rgds,
Rajeev.
All Replies
-
Monday, November 19, 2012 5:33 PMModerator http://msdn.microsoft.com/en-us/library/bb410149(v=vs.85).aspx
Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
SolarWinds Head Geek
Microsoft MVP - Software Distribution (2005-2012)
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
.png)
