The console shows customized subscriptions after you upgrade to System Center Operations Manager 2007 R2 from System Center Operations Manager 2007 Service Pack 1

This article has been archived. It is offered "as is" and will no longer be updated.
After you upgrade to System Center Operations Manager 2007 R2 from System Center Operations Manager 2007 Service Pack 1 (SP1), the console shows customized Channel names. These channels resemble the following under the Administration\Notifications\Channels\Channel Name node:
To resolve this problem, run the following script to translate the subscription names.

Note Before you run this script, make sure that you have a complete backup of your environment. For more information about how to back up and restore Systems Center Operations Manager 2007 components, visit the following Microsoft Web site:To run the script, follow these steps:
  1. Open SQL Management Studio.
  2. Connect to the Operational DB database.
  3. Expand databases, and then select OperationsManager.
  4. Right-click OperationsManager, and then select New Query.
  5. Copy the following script, and then paste it into the new query window:
    DECLARE @NotificationManagementPackId uniqueidentifierSELECT @NotificationManagementPackId = ManagementPackId FROM ManagementPackWHERE MPName = 'Microsoft.SystemCenter.Notifications.Internal'SELECT ModuleTypeId, MDTName INTO #ActionsToRenameFROM ModuleType WHERE ManagementPackId = @NotificationManagementPackIdAND MDTImplementationXML LIKE '%ContentGenerator%Transport%' AND MDTName <> 'DefaultSmtpAction'SELECT R.RuleId, M.ModuleTypeId, DSV.DisplayName INTO #RulesToUseToRenameFROM Rules RJOIN Module M ON R.RuleId = M.ParentIdJOIN #ActionsToRename A ON A.ModuleTypeId = M.ModuleTypeIdJOIN DisplayStringView DSV ON DSV.MPElementId = R.RuleId WHERE R.ManagementPackId = @NotificationManagementPackId AND DSV.LanguageCode = 'ENU' UPDATE LocalizedText SET LTValue = R.DisplayNameFROM #RulesToUseToRename RWHERE R.ModuleTypeId = MPElementId AND LTStringType = 1 AND LanguageCode = 'ENU'DROP TABLE #RulesToUseToRenameDROP TABLE #ActionsToRename
    Note If the language installed on your computer differs from English, change the two script entries that are labeled "LanguageCode" from "ENU" to the appropriate language code. Use the following table to determine the appropriate code.
    Language Codes
    CHSChinese Simplified (PR China)
    CHTChinese Traditional (Taiwan)
    CHHChinese Traditional (Hong Kong Region)
    CHPChinese Traditional (Hong Kong Region)
    DEU German
    HEB Hebrew
    ITA Italian
    JPN Japanese
    KOR Korean
    ESN Spanish
    ENU English US
    ENG English UK
    NLD Dutch
    SVE Swedish
    PTB Portuguese (Brazilian)
    NOR Norwegian
    DAN Danish
    FIN Finnish
    RUS Russian
    HUN Hungarian
    PLK Polish
    CSY Czech
    PTG Portuguese
    TRK Turkish
    ELL Greek
    SLV Slovenian
  6. On the toolbar, click Execute.

    Note We recommend using the /clearcache parameter to re-open the Operations Manage console. Otherwise, you may not be able to see the modifcation for a while.

Article ID: 971233 - Last Review: 01/16/2015 03:55:29 - Revision: 3.0

Microsoft System Center Operations Manager 2007 R2

  • kbnosurvey kbarchive kbtshoot kbexpertiseinter kbsurveynew kbprb KB971233