我们在当前的SCOM 2012 R2旁边建立了一个新的SCOM 2019。
导出MP是否会删除或禁用运维控制台(SCOM 2012 R2)中的原始MP?
正在考虑从SCOM2012 R2导出未密封的MP以导入到SCOM2019?,...这是否值得努力导入这些或更好地导入最新的MPs?这些是旧的MP,我不知道交互,因为自定义MP覆盖,...这是否有意义从全新的最新议员开始。
发布于 2021-06-23 07:06:33
我建议你重新开始你的国会议员。您可以使用以下脚本获取环境中的所有覆盖。在运行SCOM Data Collector之后,检查输出压缩文件:CSV\Overrides.csv
https://aka.ms/SCOM-DataCollector
或
您还可以使用以下TSQL查询来收集在OperationsManager DB上运行的SCOM环境中设置的所有覆盖:
Select WorkflowType, WorkflowName, Overview.OverrideName, OverrideableParameterName, OverrideValue, OverrideDescription, OverrideEnforced, OverrideScope, TargetedInstanceName, TargetedInstancePath, ORMPName, ORMPDescription, ORMPSealed, MPTargetClass, TargetManagementPack, ModuleOverrideId, ORMPLanguage, OverrideLastModified, OverrideCreatedOn from (
SELECT 'Rule' AS 'WorkflowType',
rv.displayname AS WorkflowName,
OverrideName,
op.OverrideableParameterName,
mo.value AS OverrideValue,
lt.ltvalue AS OverrideDescription,
mo.enforced AS OverrideEnforced,
mt.typename AS OverrideScope,
bme.displayname AS TargetedInstanceName,
bme.path AS TargetedInstancePath,
mpv.displayname AS ORMPName,
mpv.description AS ORMPDescription,
mpv.sealed AS ORMPSealed,
mpv.LanguageCode AS ORMPLanguage,
mo.lastmodified AS OverrideLastModified,
mo.timeadded AS OverrideCreatedOn
--op.TimeAdded AS MPTimeCreated
FROM moduleoverride mo
INNER JOIN managementpackview mpv
ON mpv.id = mo.managementpackid
INNER JOIN ruleview rv
ON rv.id = mo.parentid
INNER JOIN managedtype mt
ON mt.managedtypeid = mo.typecontext
LEFT JOIN localizedtext lt
ON lt.ltstringid = mo.moduleoverrideid
LEFT JOIN basemanagedentity bme
ON bme.basemanagedentityid = mo.instancecontext
LEFT JOIN overrideableparameter op
ON mo.overrideableparameterid = op.overrideableparameterid
--Where (lt.LTStringType = 2 and mpv.LanguageCode = 'ENU')
--Where (mpv.Sealed = 0 and mpv.LanguageCode = 'ENU')
--Where mpv.Sealed = 0
UNION ALL
SELECT 'Monitor' AS 'WorkflowType',
mv.displayname AS WorkflowName,
OverrideName,
op.OverrideableParameterName,
mto.value AS OverrideValue,
lt.ltvalue AS OverrideDescription,
mto.enforced AS OverrideEnforced,
mt.typename AS OverrideScope,
bme.displayname AS TargetedInstanceName,
bme.path AS TargetedInstancePath,
mpv.displayname AS ORMPName,
mpv.description AS ORMPDescription,
mpv.sealed AS ORMPSealed,
mpv.LanguageCode AS ORMPLanguage,
mto.lastmodified AS OverrideLastModified,
mto.timeadded AS OverrideCreatedOn
--mpv.TimeCreated AS MPTimeCreated
FROM monitoroverride mto
INNER JOIN managementpackview mpv
ON mpv.id = mto.managementpackid
INNER JOIN monitorview mv
ON mv.id = mto.monitorid
INNER JOIN managedtype mt
ON mt.managedtypeid = mto.typecontext
LEFT JOIN localizedtext lt
ON lt.ltstringid = mto.monitoroverrideid
LEFT JOIN basemanagedentity bme
ON bme.basemanagedentityid = mto.instancecontext
LEFT JOIN overrideableparameter op
ON mto.overrideableparameterid = op.overrideableparameterid
--Where (lt.LTStringType = 2 and mpv.LanguageCode = 'ENU')
--Where (mpv.Sealed = 0 and mpv.LanguageCode = 'ENU')
--Where mpv.Sealed = 0
UNION ALL
SELECT 'Discovery' AS 'WorkflowType',
dv.displayname AS WorkflowName,
OverrideName,
op.OverrideableParameterName,
mo.value AS OverrideValue,
lt.ltvalue AS OverrideDescription,
mo.enforced AS OverrideEnforced,
mt.typename AS OverrideScope,
bme.displayname AS TargetedInstanceName,
bme.path AS TargetedInstancePath,
mpv.displayname AS ORMPName,
mpv.description AS ORMPDescription,
mpv.sealed AS ORMPSealed,
mpv.LanguageCode AS ORMPLanguage,
mo.lastmodified AS OverrideLastModified,
mo.timeadded AS OverrideCreatedOn
--mpv.TimeCreated AS MPTimeCreated
FROM moduleoverride mo
INNER JOIN managementpackview mpv
ON mpv.id = mo.managementpackid
INNER JOIN discoveryview dv
ON dv.id = mo.parentid
INNER JOIN managedtype mt
ON mt.managedtypeid = mo.typecontext
LEFT JOIN localizedtext lt
ON lt.ltstringid = mo.moduleoverrideid
LEFT JOIN basemanagedentity bme
ON bme.basemanagedentityid = mo.instancecontext
LEFT JOIN overrideableparameter op
ON mo.overrideableparameterid = op.overrideableparameterid
--Where (lt.LTStringType = 2 and mpv.LanguageCode = 'ENU')
--Where (mpv.Sealed = 0 and mpv.LanguageCode = 'ENU')
)Overview
LEFT JOIN (
SELECT mo.ModuleOverrideId, mo.OverrideName, mpv.DisplayName as 'MPTargetClass', mpv.FriendlyName as [TargetManagementPack] FROM ModuleOverride mo
INNER JOIN Managedtype mt on mt.ManagedTypeId = mo.TypeContext
INNER JOIN ManagementPackView mpv on mpv.ID = mt.ManagementPackId
Where mpv.LanguageCode = 'ENU'
) OverridesOverview ON OverridesOverview.OverrideName = Overview.OverrideName
ORDER BY OverrideLastModified DESC
这样做可以避免您将潜在问题从SCOM 2012 R2环境重新添加到SCOM 2019环境中。
如果你正在做并行迁移,你应该看看这篇关于并行迁移的文章:
https://stackoverflow.com/questions/66507164
复制相似问题