Command Shell Examples
Useful SQL Queries
Inventory and Configuration Reports - Jonathan Almquist on Operations Manager - Site Home - TechNet Blogs

Inventory and Configuration Reports

Inventory and Configuration Reports

  • Comments 3
  • Likes

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
clip_image001

clip_image002

Open the Custom Configuration Report
clip_image003

Add the All Databases group to the report
clip_image004

clip_image005

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
clip_image006

 

Run the report

clip_image001[6]

I do not moderate this blog anymore. If you have a question regarding this post, send me a message.

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

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

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