How to create a SCOM Windows Events Monitor and alert on the Description field

When creating a monitor that alerts on event logs you may want to be able to monitor based on key words in the description field. This is not a default parmater and needs a few extra steps. But is still very easy to accomplish once you now the steps.
here are the two variables you will be adding to the monitor
parameter name: EventDescription
Alert description: $Data/EventDescription$



1. When you are creating the Event Expression click on insert, then click on button “…: under parameter name
2. Select Use Parameter Name not specified above and enter EventDescription

$Data/EventDescription$

Select an Event Property-EventDescription

3. change your operator to Contains
4. under the Value, enter the words you want to find in the desction field.

Build Event Expresion - operator and value

THIS IS NOT DONE!!!!

5. Continue to build your rule until you arrive at the Configure Alerts page. Enter the value $Data/EventDescription$ in the Alert description window. If you do not you will receive errors.

6. Create the rule, and refresh how ever you like. When i am in a hurry i will restart the health service on the server that I am monitoring.
7. To test your rule the OpsMgr Event Creator tool is not going to work. It does not allow you to create custom descriptions. Log onto the server that you want to monitor and open a command window. Using the eventcreate command type the following

eventcreate /t error /ID 1000/d “fieldxu.exe THIS IS JUST A TEST BY Brad Hearn”
/t sets as an error
/ID is the event id
/d is what will be placed into the description field. Remeber to place quotes around your text.

The alerts will look something like this.

Hope this helps out.

How to move the OperationsManager Data Warehouse Database to a new SQL server

 

Stop all services on RMS and MS servers

a. On opsmgr-rms2 stop the following

·         Opsmgr config

·         Opsmgr sdk

·         Opsmgr health

b. On opsmgr-ms2 stop the following

·         Opsmgr heatlh

Backup database opsmgr-sql2

a. Backup the following

D:\backup\OperationsManagerDW.bak

Uninstall the Reporting Data Warehouse component opsmgr-sql2

A.      Click Start, click Control Panel, and then select Add or Remove Programs.

B.      In the Add or Remove Programs dialog box, select System Center Operations

Manager 2007Reporting Server, and then select Change.

C.      c. In the System Center Operations Manager 2007 Reporting Setup Wizard, on

the Operations Manager 2007 Maintenance page, select Modify, and then click Next.

D.      d. On the Custom Setup page, configure the Data Warehouse component with

the This component will not be available option.

E.       e. Complete the wizard.

Note

This does not physically remove the OperationsManagerDW database from SQL

Server.

4. Delete the OperationsManagerDW database opsmgr-sql2

A.      In Microsoft SQL Server Management Studio, navigate to Databases.

B.      Right-click OperationsManagerDW, and then select Delete.

C.      c. In the Delete Object dialog box, ensure that the Delete backup and restore

history information for databases and the Close existing connections options are

both checked

5.Install the Reporting Data Warehouse component Opsmgr-sql1

A.      run SetupOM.exe to install the Reporting Data Warehouse component as

follows

B.      On the System Center Operations Manager 2007 Setup page, select Install

Operations Manager 2007 Reporting.

C.       the System Center Operations Manager 2007 Reporting Setup wizard, on

the Custom Setup page,

·         configure Data Warehouse component for installation

·         Configure Reporting Server with the This component will not be

available option

D.      d. Database instance is opsmgr-sql1

E.       e. Database Files Location

·         D:\Data for both data and log file locations

6.Delete the New OperationsManagerDW On the new Data Warehouse server opsmgr-sql1

A.      In Microsoft SQL Server Management Studio, navigate to Databases.

B.       Right-click OperationsManagerDW, and then select Delete.

C.      In the Delete Object dialog, ensure that the Delete backup and restore history

             information for databases and the Close existing connections options are both checked.

7.restore the OperationsManagerDW From opsmgr-sql2 to opsmgr-sql1

A.      Copy the backup of the database from \\opsmgr-sql2\d$\restore

B.      b. On SQL1 open SQL Server Management Studio

·         In the left Colum Expand opsmgr-sql1 and right click on databases

·         Select restore database

·         Source for restore (do this before setting destination)

C.       Select "From device" click on the navigate button on the right

D.      Select file for Backup Media and say add

E.      Navigate to D:\Restore and select OperationsManagerDW.bak

               and say ok twice

F.       4. Select the most recent backup and say ok.

Destination for Restore

A.      Click on the dropdown arrow beside "To database"

B.      Select OperationsManager

C.       Place a checkmark beside OperationsManagerDW-Full Database Backup

D.      4. Click on OK

E.      5. Progress is shown in the bottom left corner. When complete

                   there will hopefully be a successful window popup. Say ok.

F.       6. You are done restoring the database

8. Add SDK Account

On opsmgr-sql1 hosting the OperationsManagerDW database, add the correct

permission for the Login of the Root Management Server on which the SDK

Account is running, as follows:

A.      Open Microsoft SQL Server Management Studio, and in the Object Explorer

pane, navigate to Security and then expand Logins.

B.      b. Add the SDK Account

·         Right click on Logins and select New Login

·         For login name use domain\mom_sdkconfig

·         Use windows authentication

·         Say ok

C.      Settings for SDK Account

·         Open Microsoft SQL Server Management Studio, and in the Object

Explorer pane, navigate to Security and then expand Logins.

·          Right click domain\mom_sdkconfig select properties

·          Under "select a page" on the left side click on User Mapping

D.      In the right window under "Users mapped to this login: place a

check beside OperationsMangerDW.

E.       In the right window under "Database role membership for:

OperationsManageDW" make sure the following items are checked:

·         OpsMgrReader

·         db_datareader

9.Add Data Warehouse Read account

On opsmgr-sql1 hosting the OperationsManagerDW database, add the

correct permission for the Login of the Root Management Server on which

the Data warehouse write Account is running, as follows:

A.      Open Microsoft SQL Server Management Studio, and in the Object Explorer

pane, navigate to Security and then expand Logins.

B.      Add the Data Warehouse read Account

·         Right click on Logins and select New Login

·         For login name use domain\DW_read_Account

·         Use windows authentication

·         Say ok

10. Settings for Data Warehouse write Account

A.      In the right window under "Database role membership for:

OperationsManagerDW" make sure the following items are checked:

·         db_datareader

·         OpsMgrReader

11.Add Action Account

On opsmgr-sql1 hosting the OperationsManagerDW database, add the correct

permission for the Login of the Root Management Server on which the Action

Account is running, as follows:

A.      Open Microsoft SQL Server Management Studio, and in the Object Explorer

pane, navigate to Security and then expand Logins.

B.      Add the Action Account

·         Right click on Logins and select New Login

·         For login name use domain\Action_Account

·         Use windows authentication

·         Say ok

C.      Settings for Action Account

·         In the right window under "Database role membership for:

OperationsManagerDW" make sure the following items are checked:

·         OpsMgrWriter

·         db_owner

12. Start the OpsMgr SDK Service On the Root Management Server, opsmgr-rms2

13. Modify the data source on SQL Server Reporting Services server Opsmgr-sql2

14. Log on to opsmgr-sql2.

A.      In Internet Explorer, open http://opsmgr-sql2/reports

B.      On the SQL Server Reporting Services Home page, ensure that you are

viewing the Contents page. Select Show Details.

D.      In the list that is displayed, click Data Warehouse Main.

E.       In the Data Warehouse Main properties page, in the Connection string text

box, change the name of the database server to opsmgr-sql1.

F.       Click Apply.

15.Update the registry to point to new Data Warehouse server Opsmgr-sql2

A.      Locate the key HKEY_LOCAL_MACHINE\Software\Microsoft\MicrosoftOperations Manager\3.0\Reporting.

B.      b. Create the following key as a string value

·         Name: DWDBInstance

·         Data: opsmgr-sql1

16. Configure the OperationsManager database with the name of the new Data

Warehouse server as followsOpsmgr-sql1

A.      On the server that hosts the OperationsManager database, open SQL Server

Management Studio and navigate to Databases, OperationsManager, and then to

Tables.

B.      Right-click dbo.MT_DataWarehouse, and then select Open Table.

C.      Change the value in the

MainDatabaseServerName_16781F33_F72D_033C_1DF4_65A2AFF32CA3

column to the name of the new Data Warehouse server opsmgr-sql1.

D.       Close SQL Server Management Studio to save your changes.

17.Configure the OperationsManagerDW database with the name of the new Data Warehouse server as follows Opsmgr-sql1

A.      On the new Data Warehouse server, open SQL Server Management Studio and

navigate to Databases, OperationsManagerDW, and then to Tables.

B.      b. Right-click dbo.MemberDatabase table and select Open Table.

C.      c. Change the value in the ServerName column to the name of the new Data

Warehouse server. Opsmgr-sql1          

D.      d. Close SQL Server Management Studio to save your changes.

18.Restart services Opsmgr-rms2, opsmgr-ms2

A.      On the Root Management Server,opsmgr-rms2

·         OpsMgr Config Service

·         OpsMgr Health Service

B.      b. On all Management Servers, opsmgr-ms2

·         OpsMgr Health Service.

19. To verify a successful move of the OperationsManagerDW database

a.       Verify that you can successfully run a report from the console.

b.      Ensure that the health state of all management servers in the management

group are Healthy.

If the health state of any management server is Critical, open HealthExplorer,

expand Availability - <server name>, and then continue to expand until you can

navigate to Data Warehouse SQL RS Deployed Management Pack List Request

State. Check the associated events to determine if there is an issue accessing

the OperationsManagerDW database.

c.       Check operating system events:

·         Open the operating system's Event Viewer. Navigate to Event Viewer,

and then to Operations Manager.

1.       In the Operations Manager pane, search for events with a

Source of Health Service Module and a Category of Data Warehouse.

The move was successful if event number 31570, 31558 or 31554

exists.

There is an issue accessing the OperationsManagerDW database if

event number 31563, 31551, 31569, or 31552 exists.

d.      Check events in Operations Manager:

·         In the Operations Manager console, select Monitoring.

·         Navigate to Monitoring, Operations Manager, Health Service Module

Events, and then to Performance Data Source Module Events.

Search the Performance Data Source Module Events pane for events with a Date and Time

that is later than the move.

There is a problem with the OperationsManagerDW database if events with a Source of

Health Service Module and an Event Number of 10103.

How to move the Operations Manager 2007 Reporting Server

1.Stop all services on RMS and MS servers
a. On opsmgr-rms2 stop the following

•  Opsmgr config
•  Opsmgr sdk
•  Opsmgr health

b. On opsmgr-ms2 stop the following

•  Opsmgr heatlh

2.Backup OperationsManagerDW Opsmgr-sql1
a. Backup to the following location
D:\restore\OperationsManagerDW.bak

3. On the current Operations Manager Reporting Server computer, uninstall the Operations
Manager Reporting Server component as follows:
a. Click Start, click Control Panel, and then click Add or Remove Programs.
b. In the Add or Remove Programs dialog box, select System Center Operations
Manager 2007 Reporting Server, and then select Change.
c. In the System Center Operations Manager 2007 Reporting Setup Wizard, on the
Operations Manager 2007 Maintenance page, select Modify, and then click Next.
d. On the Custom Setup page, configure the Reporting Server component with the
This component will not be available option.
e. Complete the wizard

4.restore the OperationsManagerDW opsmgr-sql1
a. On SQL1 open SQL Server Management Studio

• In the left Colum Expand opsmgr-sql1 and right click on databases
• Select restore database
• Source for restore (do this before setting destination)

1. Select "From device" click on the navigate button on the right
2. Select file for Backup Media and say add
3. Navigate to D:\Restore and select OperationsManagerDW.bak and say ok twice
4. Select the most recent backup and say ok.
.Destination for Restore
1. Click on the dropdown arrow beside "To database"
2. Select OperationsManager
3. Place a checkmark beside OperationsManagerDW-Full Database Backup
4. Click on OK
5. Progress is shown in the bottom left corner. When complete there will hopefully be a successful window     popup. Say ok.
6. You are done restoring the database

5.Update the OperationsManager DatabaseTable
With the New Database Server Name, ensure that the account
that you are logged on with has sufficient privileges on the SQL
Server instance.
a. Open SQL Server Management Studio.
b. Expand Databases, OperationsManager and Tables.
c. Right-click dbo.MT_ManagementGroup, and then click Open Table
d. Change the value in the
SQLServerName_6B1D1BE8_EBB4_B425_08DC_2385C5930B04 column to reflect the
name of the new SQL Server-based computer.
e. Save your change.

6. Restart all services on RMS and MS servers
a. On opsmgr-rms2 stop the following

• Opsmgr config
• Opsmgr sdk
• Opsmgr health

b. On opsmgr-ms2 stop the following

• Opsmgr heatlh

7.Install Reporting services Opsmgr-rpt1
a. run SetupOM.exe from the opsmgr install source
b. On the System Center Operations Manager 2007 Setup page, select Install Operations Manager 2007 Reporting.
c. In the System Center Operations Manager 2007 Reporting Setup Wizard, on theCustom Setup page, configure only the Reporting Server component for installation.
Configure the Data Warehouse component with the This component will not be available option.
d. Enter the root manager server name opsmgr-rms2
e. SQL Database instance: opsmgr-sql1
f. Data Warehouse Write Acount

• Mom-dw-write
• Password same as action account

g. Data Warehouse Read Acount

• Mom-dw-read
• Password same as action account

System Center Configuration Manager 2007

Here is each individual one if you are interested in only a single one:

General - http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/threads/

Announcements - http://social.technet.microsoft.com/Forums/en-US/configmgrannouncements/threads/

Admin Console - http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/threads/

Asset Intelligence – http://social.technet.microsoft.com/Forums/en-US/configmgrai/threads/

Backup and Recovery – http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/threads/

Desired Configuration Management – http://social.technet.microsoft.com/Forums/en-US/configmgrdcm/threads/

Documentation – http://social.technet.microsoft.com/Forums/en-US/configmgrdocs/threads/

Internet Clients and Native Mode – http://social.technet.microsoft.com/Forums/en-US/configmgribcm/threads/

Inventory - http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/threads/

Operating System Deployment – http://social.technet.microsoft.com/Forums/en-US/configmgrosd/threads/

SDK – http://social.technet.microsoft.com/Forums/en-US/configmgrsdk/threads/

Setup/Deployment – http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/threads/

Software Distribution – http://social.technet.microsoft.com/Forums/en-US/configmgrswdist/threads/

Software Updates Management – http://social.technet.microsoft.com/Forums/en-US/configmgrsum/threads/