A server management report pack would be great. Theres so much info in msdb, reporting on it would be great.
Can see a conflict with MOM but what the heck.
Also with all the dm views reports on top of them, could be good, bad or plain ugly
It's very easy (and useful) a set of reports who scans the DTS logs on msdb. Of course this is for SQL Server 2000 (in Analysis Services there will be some difference) but at this time there are a lot of SQL 2000 installations and a way to quickly monitor the status of health of nightly scheduled DTS runs is very useful.
I already developed some report for my customer needs, but it would be great to have a more complete report solution.
I second the call for a SQL Server Management report pack. We run SQLH2 and the reports that come out of that a pretty good.
What's missing is reporting on current activity.
I was just scanning through Matt's blog and noticed this thread. In the latest builds (i.e. after but not including June CTP), check out the "Report" tab on the summary window in SQL management studio, which has some cool reports on top of the DMview (including current activity)
So a number of report packs have been released one for IIS, one for sharepoint (i think). What packs...
So a number of report packs have been released one for IIS, one for sharepoint (i think). What packs