Blog Post

Default reports in SSMS

,

As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are the most common place to get the information we need but every now and again it’s nice to get an organized/pretty view. To that end, you can write your own reports or you can use the default reports that Microsoft makes available through SSMS. There are reports at the Server, Database and Agent level.

Server

DefaultReports

Database

DefaultReport2

Agent

DefaultReport3

It’s easy enough to get to them. Just right click (ServerName, DBName, or Agent) -> Reports -> Standard Reports -> Select your report. Then once you start using them your recent reports will start showing up under the reports menu.

DefaultReport4

Filed under: Documentation, Microsoft SQL Server, SQLServerPedia Syndication, SSMS Tagged: microsoft sql server, reports, SSMS

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating