Les rapports fournis avec System Center Operations Manager (SCOM) peuvent paraître parfois pauvre notamment en matière d’administration quotidienne du produit. Aujourd’hui, je vous propose un rapport permettant de lister la configuration d’un agent afin de connaître toutes les entités découvertes.
Vous pourrez ainsi retrouver des informations comme le Management Pack, la classe et l’instance.
N’oubliez pas de vous créer une data source pointant sur le data warehouse 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 Agent Configuration
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 list the agent configuration with the list of entities discovered. You can then retrieve information such as the Management Pack, the class and the instance discovered.
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 ManagedEntity.FullName, ManagedEntity.Path, ManagedEntity.Name, ManagedEntity.DisplayName, ManagedEntity.ManagedEntityDefaultName,
ManagedEntityType.ManagedEntityTypeSystemName, ManagedEntityType.ManagedEntityTypeDefaultName,
ManagedEntityType.ManagedEntityTypeDefaultDescription, TypedManagedEntity.FromDateTime, TypedManagedEntity.ToDateTime,
ManagementPack.ManagementPackSystemName, ManagementPack.ManagementPackDefaultName
FROM ManagedEntityType WITH (NOLOCK) INNER JOIN
ManagementPack WITH (NOLOCK) ON ManagedEntityType.ManagementPackRowId = ManagementPack.ManagementPackRowId INNER JOIN
TypedManagedEntity WITH (NOLOCK) ON ManagedEntityType.ManagedEntityTypeRowId = TypedManagedEntity.ManagedEntityTypeRowId INNER JOIN
ManagedEntity WITH (NOLOCK) ON ManagedEntityType.ManagedEntityTypeRowId = ManagedEntity.ManagedEntityTypeRowId AND
TypedManagedEntity.ManagedEntityRowId = ManagedEntity.ManagedEntityRowId
WHERE (TypedManagedEntity.ToDateTime IS NULL) AND (ManagedEntity.Path LIKE '%' + @ComputerName + '%') OR
(TypedManagedEntity.ToDateTime IS NULL) AND (ManagedEntity.Name LIKE @ComputerName) OR
(TypedManagedEntity.ToDateTime IS NULL) AND (ManagedEntity.Path LIKE N'%' + @ComputerName + N'%') OR
(TypedManagedEntity.ToDateTime IS NULL) AND (ManagedEntity.Name LIKE @ComputerName)
GROUP BY ManagedEntity.FullName, ManagedEntity.Path, ManagedEntity.Name, ManagedEntity.DisplayName, ManagedEntity.ManagedEntityDefaultName,
ManagedEntityType.ManagedEntityTypeSystemName, ManagedEntityType.ManagedEntityTypeDefaultName,
ManagedEntityType.ManagedEntityTypeDefaultDescription, TypedManagedEntity.FromDateTime, TypedManagedEntity.ToDateTime,
ManagementPack.ManagementPackSystemName, ManagementPack.ManagementPackDefaultName
ORDER BY ManagedEntity.Path
Download Information –Agent Configuration report
This report is provided "AS IS" without express or implied warranty of any kind.
