Author: Ingmar Verheij
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, 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) ) ) )