OpsMgr: Where’s my management pack?

Written by Ingmar Verheij on April 10th, 2012. Posted in Operations Manager

After importing a management pack in System Center Operations Manager (SCOM) it might take a while until it is visible in the Operations Console. When developing a management pack (and especially when creating reports) this is frustrating since there are numerous reasons why the management pack isn’t working as expected.

A common reason why the management pack (and the associated reports) aren’t showed in the Operations Console is because the management packs are queued awaiting synchronization.


With the SQL query below will help you find the management packs that are pending.  Usually the management pack causing the delay are unsealed (XML) management packs. You can “force” (remember, this still is a system center product – click-and-wait) resynchronizing a management pack by increasing the version number and reimport.

USE OperationsManager
SELECT ManagementPackId, 
FROM ManagementPack mp
WHERE MPVersionDependentId NOT IN (
                                   SELECT mpv.ManagementPackVersionDependentGuid
                                   FROM OperationsManagerDW.dbo.ManagementPackVersion mpv
                                   JOIN OperationsMAnagerDW.dbo.ManagementGroupManagementPackVersion mgmpv ON (mpv.ManagementPackVersionRowId = mgmpv.ManagementPackVersionRowId)
                                   WHERE (mgmpv.LatestVersionInd > 0)
                      SELECT * FROM ManagementPackReferences mpr
                      JOIN ManagementPack mpv ON (mpr.ManagementPackIdSource = mpv.ManagementPackId)
                      WHERE (mpr.ManagementPackIdReffedBy = mp.ManagementPackId)
                            (mpv.MPVersionDependentId NOT IN (
                                                              SELECT mpv.ManagementPackVersionDependentGuid
															  FROM OperationsManagerDW.dbo.ManagementPackVersion mpv
															  JOIN OperationsManagerDW.dbo.ManagementGroupManagementPackVersion mgmpv ON (mpv.ManagementPackVersionRowId = mgmpv.ManagementPackVersionRowId)
															  WHERE (mgmpv.LatestVersionInd > 0)



Ingmar Verheij

At the time Ingmar wrote this article he worked for PepperByte as a Senior Consultant (up to May 2014). His work consisted of designing, migrating and troubleshooting Microsoft and Citrix infrastructures. He was working with technologies like Microsoft RDS, user environment management and (performance) monitoring. Ingmar is User Group leader of the Dutch Citrix User Group (DuCUG). RES Software named Ingmar RES Software Valued Professional in 2014.

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

Tags: , , ,

Comments (1)

  • 12 May 2013 at 14:20 |

    Hmm is anyone else encountering problems with the images on this blog
    loading? I’m trying

    to find out if its a problem on my end or if it’s the blog.

    Any feed-back would be greatly appreciated.

Leave a comment



%d bloggers like this: