Когда имеет смысл импортировать незапечатанный MP (консоль Ops) или импортировать только последний MP при замене SCOM 2012 R2 на SCOM 2019?

Мы представляем новый SCOM 2019 рядом с текущим SCOM 2012 R2.

Приведет ли экспорт MP к удалению или отключению исходного MP в консоли Ops (SCOM 2012 R2)?

Принимая во внимание экспорт незапечатанных MP из SCOM 2012 R2 для импорта в SCOM 2019?,... стоит ли пытаться импортировать их или лучше импортировать последние MP? Это старые MP, и я понятия не имею о взаимозависимости из-за пользовательских MP для переопределений... имеет ли смысл начинать с самого начала с совершенно новыми последними MP.


scom
person d1260    schedule 06.03.2021    source источник

Ответы (1)


arrow_upward
0
arrow_downward

Я бы порекомендовал начать заново с вашими депутатами. Вы можете использовать следующий сценарий, чтобы получить все переопределения в вашей среде. После запуска сборщика данных SCOM проверьте выходной zip-файл: CSV\Overrides.csv
https://aka.ms/SCOM-DataCollector

АЛЬТЕРНАТИВНО
Вы также можете использовать следующий запрос TSQL, чтобы собрать все переопределения, установленные в вашей среде SCOM, и выполнить их для базы данных OperationsManager:

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

person Blake Drumm    schedule 22.06.2021