While working on a customer project, I needed to retrieve the SQL Server SCOM Management Pack version. Unfortunately, the SCOM team took a while to answer and as I am the DBA, I have access to the SCOM databases. So let’s have a look at how we can get this the “hard” way.

On 30/06/2014, a new Management Pack was published for SQL Server.
I have installed the last package and a lot bugs were fixed in it.
The aim of this brief post is to inform you on the query to find the current version of the Management Pack for SQL Server without management permissions in SCOM.
On the Microsoft website, you can download the System Center Management Pack for SQL Server here.

b2ap3_thumbnail_scom02.jpg

The new version is 6.5.1.0 and I need to find the current version.

By default , the database for SCOM is OperationsManager12 and in this database, we have the table ManagementPack in the dbo schema:

SELECT [ManagementPackId],[MPName],[MPFriendlyName],[MPVersion],[MPLastModified],[MPCreated] FROM [OperationsManager12].[dbo].[ManagementPack] where MPFriendlyName like ‘%SQL Server%’

b2ap3_thumbnail_scom01.jpgAs you can see, in my environment, it is not updated (6.4.1.0).
But as for all updates, test it before!

A little bonus

Forthe  SharePoint 2010 Management Pack, the latest version is 14.0.4745.1000. You can find it easily by replacing “SQL Server” with “SharePoint” in the WHERE clause.

b2ap3_thumbnail_scom04.jpg

And I run the same query for the TFS Management Pack:

b2ap3_thumbnail_scom05.jpg

And you try the same with other tools…
I hope this will help you! 😀