[OpsMgr 2007 R2][OpsMgr 2012] 2 reports to work on references between MPs

Here is a new link to an article from Jean-Sebastien DUCHENE who provide 2 new reports to work with references between management packs. Please find more report on his blog >>> Here <<<

The reports provided with System Center Operations Manager (SCOM) may sometimes seem particularly poor in terms of daily operations on the product. Today, I offer a report to track references between Unsealed MP and Sealed MP.

Here are the reports:

• Management Pack - References by Override MP
• Management Pack - References by Sealed MP

Do not forget to create a datasource targeting to the data warehouse with security rights necessary to generate the report. This reports works with System Center Operations Manager 2007 R2, System Center 2012 Operations Manager and SQL Server 2008 RTM/R2.

Here is the query:

SELECT distinct Tgt.ManagementPackSystemName As 'Sealed MP', Src.ManagementPackSystemName As 'Override MP'
FROM vManagementPackVersionReference
INNER JOIN vManagementPack As Tgt on ReferencedManagementPackRowId = Tgt.ManagementPackRowId
INNER join vManagementPackVersion on ReferencingManagementPackVersionRowId = vManagementPackVersion.ManagementPackVersionRowId
INNER JOIN vManagementPack As Src on vManagementPackVersion.ManagementPackRowId = Src.ManagementPackRowId
WHERE Src.SealedInd = 0
AND Tgt.ManagementPackSystemName NOT IN
('Microsoft.SystemCenter.Library',
'Microsoft.SystemCenter.InstanceGroup.Library',
'Microsoft.Windows.Library',
'System.Library',
'System.Health.Library')
ORDER BY Tgt.ManagementPackSystemName

Download Management packs references Reports

This posting is provided "AS IS" with no warranties.