Jean-Sébastien DUCHENE Blog's

Actualité, Tips, Articles sur l'ensemble des Technologies Microsoft (SCCM/SMS, EMS, Microsoft Intune, Microsoft Azure, Windows 10, SCOM, MDOP...)

Les rapports fournis avec System Center Operations Manager (SCOM) peuvent paraître parfois pauvres notamment en matière d’administration quotidienne du produit. Aujourd’hui, je vous propose un rapport listant tous les groupes et les Management Packs où ils sont stockés.

N’oubliez pas de vous créer une data source pointant sur la base de données opérationnelle avec les droits nécessaires pour que le rapport puisse être exécuté. Ce rapport marche pour System Center Operations Manager 2007 R2, System Center 2012 Operations Manager  et SQL Server 2008 RTM/R2.

Télécharger le rapport Groups - Management Pack used to store them

 

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 you a report listing all groups and Management Packs where they are stored.

Do not forget to create a datasource targeting to the operational database 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 BME.DisplayName AS 'Group', ManagementPack.MPFriendlyName AS 'MP used to store'

FROM         BaseManagedEntity AS BME LEFT OUTER JOIN

                      ManagedTypeView AS T1 WITH (NOLOCK) ON BME.BaseManagedEntityId = T1.Id INNER JOIN

                      ManagementPack WITH (NOLOCK) ON T1.ManagementPackId = ManagementPack.ManagementPackId

WHERE     (T1.Name LIKE 'UINameSpace%.Group') OR

                      (T1.Name LIKE '%MySpecificGroupName%')

GROUP BY ManagementPack.MPFriendlyName, BME.DisplayName

ORDER BY 'Group'

 

Download Groups - Management Pack used to store them Report

This report is provided "AS IS" without express or implied warranty of any kind.

Facebook Like
Anonymous