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

• Anonymous
  January 01, 2003
  Kelly - I'm sure it's the same process.  Have you tried?  Thanks, Jonathan

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

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