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:
SMTP{GUID}
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:
- Open SQL Management Studio.
- Connect to the Operational DB database.
- Expand databases, and then select
OperationsManager.
- Right-click OperationsManager, and then
select New Query.
- 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
Collapse this tableExpand this table
| Language Codes | |
| ARA | Arabic |
| CHS | Chinese Simplified (PR China) |
| CHT | Chinese Traditional (Taiwan) |
| CHH | Chinese Traditional (Hong Kong Region) |
| CHP | Chinese Traditional (Hong Kong Region) |
| FRA | French |
| 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 |
| SKY | Slovak |
- 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.
Back to the top
