首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >将SCOM 2012 R2替换为SCOM 2019时,导入未密封的MP (运维控制台)或仅导入最新的MP有什么意义?

将SCOM 2012 R2替换为SCOM 2019时,导入未密封的MP (运维控制台)或仅导入最新的MP有什么意义?
EN

Stack Overflow用户
提问于 2021-03-06 23:10:45
回答 1查看 15关注 0票数 0

我们在当前的SCOM 2012 R2旁边建立了一个新的SCOM 2019。

导出MP是否会删除或禁用运维控制台(SCOM 2012 R2)中的原始MP?

正在考虑从SCOM2012 R2导出未密封的MP以导入到SCOM2019?,...这是否值得努力导入这些或更好地导入最新的MPs?这些是旧的MP,我不知道交互,因为自定义MP覆盖,...这是否有意义从全新的最新议员开始。

EN

回答 1

Stack Overflow用户

发布于 2021-06-23 07:06:33

我建议你重新开始你的国会议员。您可以使用以下脚本获取环境中的所有覆盖。在运行SCOM Data Collector之后,检查输出压缩文件:CSV\Overrides.csv

https://aka.ms/SCOM-DataCollector

您还可以使用以下TSQL查询来收集在OperationsManager DB上运行的SCOM环境中设置的所有覆盖:

代码语言:javascript
运行
复制
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://docs.microsoft.com/en-us/answers/questions/167044/whats-the-best-practice-to-migrate-scom-2012-to-sc.html

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/66507164

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档