Inventory and Configuration Reports

Someone asked today if there was a way to generate a report displaying inventory/configuration of SQL Server.  Chris Harris, SCOM Program Manager, answered the question with one of our built-in configuration reports.  He was so kind as to provide screenshots and everything, and indicated that someone should blog it.  So, here you go.  Thanks, Chris!  Credits go to you…

Of course, this can be done with any discovered inventory in SCOM – not just SQL databases.  It’s a handy little trick you can use to look like a rock star to management.

Create a group called All Databases containing instances of the Database class


Open the Custom Configuration Report

Add the All Databases group to the report


Select the following report fields (obviously you may be interested in others, but these look good to me):

a.      Display Name

b.      DNS Name

c.      Database Size (MB) (Numeric)

d.      Log Autogrow Set

e.      Log Size (MB) (Numeric)

f.       Recovery Model

g.      Authentication Mode

h.      Service Pack Version

i.       Instance Name


Select the DNS Name report field, click Filter and specify the name of the SQL server you are interested in


Run the report


Comments (3)

  1. Kelly – I'm sure it's the same process.  Have you tried?  Thanks, Jonathan

  2. Anonymous says:

    When I generate this report, all the database size fields are returning just zeros. What could be causing this issue?

  3. KellyK says:

    Jonathan, how  cane we  create similar report for  2005 and sql 2008 databases with SCOM 2012?