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

Article translations Article translations
Article ID: 971233 - View products that this article applies to.
Expand all | Collapse all


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 uniqueidentifier
    SELECT @NotificationManagementPackId = ManagementPackId FROM ManagementPack
    WHERE MPName = 'Microsoft.SystemCenter.Notifications.Internal'
    SELECT ModuleTypeId, MDTName 
    INTO #ActionsToRename
    FROM ModuleType 
    WHERE ManagementPackId = @NotificationManagementPackId
    AND MDTImplementationXML LIKE '%ContentGenerator%Transport%' AND MDTName <> 'DefaultSmtpAction'
    SELECT R.RuleId, M.ModuleTypeId, DSV.DisplayName 
    INTO #RulesToUseToRename
    FROM Rules R
    JOIN Module M ON R.RuleId = M.ParentId
    JOIN #ActionsToRename A ON A.ModuleTypeId = M.ModuleTypeId
    JOIN DisplayStringView DSV ON DSV.MPElementId = R.RuleId 
    WHERE R.ManagementPackId = @NotificationManagementPackId AND DSV.LanguageCode = 'ENU'
    UPDATE LocalizedText 
    SET LTValue = R.DisplayName
    FROM #RulesToUseToRename R
    WHERE R.ModuleTypeId = MPElementId AND LTStringType = 1 AND LanguageCode = 'ENU'
    DROP TABLE #RulesToUseToRename
    DROP 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.
    Collapse this tableExpand this table
    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: October 7, 2009 - Revision: 2.1
  • Microsoft System Center Operations Manager 2007 R2
kbtshoot kbexpertiseinter kbsurveynew kbprb KB971233

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from