{"id":3569,"date":"2012-04-10T15:46:46","date_gmt":"2012-04-10T13:46:46","guid":{"rendered":"https:\/\/ingmarverheij.com\/?p=3569"},"modified":"2012-04-10T15:46:46","modified_gmt":"2012-04-10T13:46:46","slug":"opsmgr-wheres-my-management-pack","status":"publish","type":"post","link":"https:\/\/ingmarverheij.com\/en\/opsmgr-wheres-my-management-pack\/","title":{"rendered":"OpsMgr: Where’s my management pack?"},"content":{"rendered":"

\"\"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\u2019t working as expected. <\/p>\n

A common reason why the management pack (and the associated reports) aren\u2019t showed in the Operations Console is because the management packs are queued<\/strong> awaiting synchronization. <\/p>\n

<\/p>\n

Query<\/h4>\n

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 \u201cforce\u201d (remember, this still is a system center product \u2013 click-and-wait) resynchronizing a management pack by increasing the version number and reimport.<\/p>\n

USE OperationsManager\nSELECT ManagementPackId, \n       MPFriendlyName,\n       MPName, \n       MP.MPVersionDependentId, \n       MPLastModified, \n       MPKeyToken, \n       ContentReadable\nFROM ManagementPack mp\nWHERE MPVersionDependentId NOT IN (\n                                   SELECT mpv.ManagementPackVersionDependentGuid\n                                   FROM OperationsManagerDW.dbo.ManagementPackVersion mpv\n                                   JOIN OperationsMAnagerDW.dbo.ManagementGroupManagementPackVersion mgmpv ON (mpv.ManagementPackVersionRowId = mgmpv.ManagementPackVersionRowId)\n                                   WHERE (mgmpv.LatestVersionInd > 0)\n                                  )\n      AND NOT EXISTS (\n                      SELECT * FROM ManagementPackReferences mpr\n                      JOIN ManagementPack mpv ON (mpr.ManagementPackIdSource = mpv.ManagementPackId)\n                      WHERE (mpr.ManagementPackIdReffedBy = mp.ManagementPackId)\n                            AND\n                            (mpv.MPVersionDependentId NOT IN (\n                                                              SELECT mpv.ManagementPackVersionDependentGuid\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t  FROM OperationsManagerDW.dbo.ManagementPackVersion mpv\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t  JOIN OperationsManagerDW.dbo.ManagementGroupManagementPackVersion mgmpv ON (mpv.ManagementPackVersionRowId = mgmpv.ManagementPackVersionRowId)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t  WHERE (mgmpv.LatestVersionInd > 0)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t )\n\t\t\t\t\t\t\t)\n\t\t\t\t     )<\/pre>\n
 <\/h4>\n
Example<\/h4>\n
\"\"<\/a><\/p>","protected":false},"excerpt":{"rendered":"
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\u2019t working as expected. A common reason why the […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[311],"tags":[256,431,440,235],"class_list":["post-3569","post","type-post","status-publish","format-standard","hentry","category-system-center-operations-manager-scom","tag-management-pack","tag-opsmgr","tag-query","tag-scom"],"_links":{"self":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/3569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/comments?post=3569"}],"version-history":[{"count":1,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/3569\/revisions"}],"predecessor-version":[{"id":3570,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/3569\/revisions\/3570"}],"wp:attachment":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/media?parent=3569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/categories?post=3569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/tags?post=3569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}