WSUS report

we have implemented wsus 3.0 sp1 on our corporate environment. we need create reports installed updates specific period of time.standard report of wsus not allow creation of such reports.such reports can created of sql select on sql server.could tell me "sql select"?

we have implemented wsus 3.0 sp1 on our corporate environment. need create reports installed updates specific period of time. standard report of wsus not allow creation of such reports. such reports can created of sql select on sql server. tell me "sql select"?

information on developing custom reports covered in wsus operations guide.

see section creating reports. @ end of section, of particular note, these paragraphs:

 

extending reports

you can customize wsus reports in different ways:

1. use wsus apis create custom report
2. use wsus public views create , extend custom reports

use wsus apis create custom reports

for more information on wsus apis, see windows server update services sdk documentation on msdn (http://go.microsoft.com/fwlink/?linkid=85713). can use these apis create reports on updates, approvals, installation information, , like.

use wsus public views create custom reports

for more information on public views, sample queries, see wsus sdk conceptual documentation on msdn (http://go.microsoft.com/fwlink/?linkid=85715.) if using sql server wsus database, can use sql server report builder generate custom reports using these views, or can access views command line. if using windows internal database wsus database, can access via command line if download microsoft sql server command line query utility , sql native client. can download install packages microsoft download center (http://go.microsoft.com/fwlink/?linkid=70728).

---

lawrence garvin, m.s., mcitp:ea, mcdba, mcsa
principal/cto, onsite technology solutions, houston, texas
microsoft mvp - software distribution (2005-2010)
my mvp profile: http://mvp.support.microsoft.com/profile/lawrence.garvin
my blog: http://onsitechsolutions.spaces.live.com

Windows Server  >  WSUS