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
I do not moderate this blog anymore. If you have a question regarding this post, send me a message.
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?