OpsMgr: Where’s my management pack?

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.

Query

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, 
       MPFriendlyName,
       MPName, 
       MP.MPVersionDependentId, 
       MPLastModified, 
       MPKeyToken, 
       ContentReadable
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)
                                  )
      AND NOT EXISTS (
                      SELECT * FROM ManagementPackReferences mpr
                      JOIN ManagementPack mpv ON (mpr.ManagementPackIdSource = mpv.ManagementPackId)
                      WHERE (mpr.ManagementPackIdReffedBy = mp.ManagementPackId)
                            AND
                            (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)
															 )
							)
				     )

Example