Manualshelf

Owner's Manual

ManualsBrandsDell ManualsSoftwareDell EqualLogic Management Pack Version 4.1 for Microsoft System Center Operations Manager
12345678910
10 Overview
Pre-Upgrade Tasks
(Optional)
Before you upgrade to version 4.1 from version 4.0, perform the following
steps to back up the alerts generated through version 4.0:
1
Connect to the Database Server that is used by your SCOM/SCE
installation.
2
Replace
OperationsManager
in the following query with the name of your
SCOM/SCE database.
SQL Query:
USE [OperationsManager]
GO
SELECT [dbo].[Alert].*
FROM
[dbo].[Alert],[dbo].[BaseManagedEntity],
[dbo].ManagedType
WHERE
([dbo].[Alert].[BaseManagedEntityId]=
[dbo].[BaseManagedEntity].BaseManagedEntityId)
AND
([dbo].[BaseManagedEntity].[BaseManagedTypeId]=
[dbo].ManagedType.ManagedTypeId
AND
([dbo].ManagedType.TypeName=
'Dell.Storage.EqualLogicEthernetInterface')
GO
3
Execute the SQL query; save the results as a tab-delimited text file.
EQL-QIG.book Page 10 Wednesday, September 21, 2011 2:13 PM