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

One Comment

  1. 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 Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

en_USEnglish