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 pauvre notamment en matière d’administration quotidienne du produit. Aujourd’hui, je vous propose un rapport permettant de lister les changements opérés (ajout, upgrade, suppression) sur les Management Packs dans un intervalle donné.

Vous pourrez ainsi retrouver des informations comme le Management Pack, la version la date de suppression, si celui-ci a été mis à jour, quelle est la dernière version…

N’oubliez pas de vous créer une data source pointant sur le data warehouse 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 Management Pack Changes

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 changes (add, upgrade, delete) on the Management Packs in a given interval. You can then retrieve information such as the Management Pack, the version, the date of removal, if it has been updated, what is the latest version ...

 

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     vManagementPack.ManagementPackDefaultName AS [Management Pack], vManagementPackVersion.ManagementPackVersion AS Version,

                      vManagementGroupManagementPackVersion.InstalledDateTime AS [Installed Date], vManagementGroupManagementPackVersion.DeletedDateTime AS [Delete Date],

                      vManagementGroupManagementPackVersion.UpgradedInd AS Upgrade,

                      CASE vManagementGroupManagementPackVersion.LatestVersionInd WHEN '1' THEN 'True' WHEN '0' THEN 'False' END AS [Latest Version],

                      vManagementGroupManagementPackVersion.DWCreatedDateTime AS [DW Created Date],

                      vManagementGroupManagementPackVersion.DWLastModifiedDateTime AS [DW Last Modified]

FROM         vManagementGroupManagementPackVersion WITH (NOLOCK) INNER JOIN

                      vManagementPackVersion WITH (NOLOCK) ON

                      vManagementGroupManagementPackVersion.ManagementPackVersionRowId = vManagementPackVersion.ManagementPackVersionRowId INNER JOIN

                      vManagementPack WITH (NOLOCK) ON vManagementPackVersion.ManagementPackRowId = vManagementPack.ManagementPackRowId

WHERE     (vManagementGroupManagementPackVersion.DWLastModifiedDateTime BETWEEN @StartDate AND @EndDate)

ORDER BY [DW Last Modified] DESC

 

Download Management Pack Changes report

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

Facebook Like
Anonymous