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 sur les overrides dans un intervalle donné.
Vous pourrez ainsi retrouver des informations comme le Management Pack, le type, le nom, le context, la valeur et le management pack stockant le changement.
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 Information – All Overrides
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 operated on overrides in a given interval. You can then retrieve information such as the Management Pack, the type (monitor, discovery…), the type name, the context name, the override parameter name, the value, the enforced flag, the MP used to store this override...
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
MP.MPFriendlyName AS 'Management Pack', aov.ParentType AS 'Type',
(CASE WHEN AOV.OverrideType = 'RuleProperty' THEN R.RuleName WHEN AOV.OverrideType = 'MonitorProperty' THEN M.MonitorName WHEN AOV.OverrideType
= 'RuleConfiguration' THEN R.RuleName WHEN AOV.OverrideType = 'MonitorConfiguration' THEN M.MonitorName END) AS 'NameType',
mt.DisplayName AS ContextDisplayName, aov.OverrideableParameterName, aov.Value,
(CASE Enforced WHEN '0' THEN 'False' WHEN '1' THEN 'True' END) AS 'Enforced', aov.LastModified, aov.TimeAdded,
(CASE WHEN AOV.OverrideType = 'RuleProperty' THEN (CASE R.RuleEnabled WHEN '0' THEN 'False' WHEN '2' THEN 'True' WHEN '3' THEN 'True' WHEN
'4' THEN 'True' END)
WHEN AOV.OverrideType = 'MonitorProperty' THEN (CASE M.MonitorEnabled WHEN '0' THEN 'False' WHEN '2' THEN 'True' WHEN '3' THEN 'True' WHEN
'4' THEN 'True' END)
WHEN AOV.OverrideType = 'RuleConfiguration' THEN (CASE R.RuleEnabled WHEN '0' THEN 'False' WHEN '2' THEN 'True' WHEN '3' THEN 'True' WHEN
'4' THEN 'True' END)
WHEN AOV.OverrideType = 'MonitorConfiguration' THEN (CASE M.MonitorEnabled WHEN '0' THEN 'False' WHEN '2' THEN 'True' WHEN '3' THEN 'True'
WHEN '4' THEN 'True' END) END) AS 'Enable_by_default', MPSTORE.MPFriendlyName AS 'MP Stored'
FROM AllOverrideView AS aov LEFT OUTER JOIN
Rules AS R WITH (nolock) ON aov.TargetId = R.RuleId AND (aov.OverrideType = 'RuleProperty' OR
aov.OverrideType = 'RuleConfiguration') LEFT OUTER JOIN
Monitor AS M WITH (nolock) ON aov.TargetId = M.MonitorId AND (aov.OverrideType = 'MonitorProperty' OR
aov.OverrideType = 'MonitorConfiguration') LEFT OUTER JOIN
ManagementPack AS MP WITH (nolock) ON
(CASE WHEN AOV.OverrideType = 'RuleProperty' THEN R.ManagementPackId WHEN AOV.OverrideType = 'RuleConfiguration' THEN R.ManagementPackId
WHEN AOV.OverrideType = 'MonitorProperty' THEN M.ManagementPackId WHEN AOV.OverrideType = 'MonitorConfiguration' THEN M.ManagementPackId
END) = MP.ManagementPackId INNER JOIN
ManagementPack AS MPSTORE WITH (nolock) ON MPSTORE.ManagementPackId = aov.ManagementPackId LEFT OUTER JOIN
ManagedTypeView AS mt WITH (nolock) ON mt.Id = aov.ContextId LEFT OUTER JOIN
ManagedTypeView AS mtv WITH (nolock) ON mtv.Id = aov.ContextObjectId
WHERE (MP.MPFriendlyName IS NOT NULL) AND (aov.LastModified BETWEEN @StartDate AND @EndDate) OR
(MP.MPFriendlyName IS NOT NULL) AND (aov.TimeAdded BETWEEN @StartDate AND @EndDate)
ORDER BY aov.TimeAdded DESC
Download Information – All Overrides report
This report is provided "AS IS" without express or implied warranty of any kind.
