Microsoft Operations Manager
The Microsoft Operations Manager DSM for JSA accepts Microsoft Operations Manager (MOM) events by polling the OnePoint database that allows JSA to record the relevant events.
Before you configure JSA to integrate with the Microsoft Operations Manager, you must ensure that a database user account is configured with appropriate permissions to access the MOM OnePoint SQL Server database. Access to the OnePoint database SDK views is managed through the MOM SDK View User database role. For more information, see your Microsoft Operations Manager documentation.
Make sure that the firewall rules are not blocking the communication between JSA and the SQL Server database that is associated with MOM. For MOM installations that use a separate, dedicated computer for the SQL Server database, the SDKEventView view is queried on the database system, not the system that runs MOM.
To configure JSA to receive MOM events:
- Click the Admin tab.
- On the navigation menu, click Data Sources.
- Click the Log Sources icon, and then click Add.
- Configure the following values:
Table 1: Microsoft Operations Manager JDBC Parameters
Log Source Name
Type a unique name for the log source.
Log Source Description
Type a description for the log source.
Log Source Type
Microsoft Operations Manager
Log Source Identifier
Type a name for the log source. The name can't contain spaces and must be unique among all log sources of the log source type that is configured to use the JDBC protocol.
If the log source collects events from a single appliance that has a static IP address or host name, use the IP address or host name of the appliance as all or part of the Log Source Identifier value; for example, 192.168.1.1 or JDBC192.168.1.1. If the log source doesn't collect events from a single appliance that has a static IP address or host name, you can use any unique name for the Log Source Identifier value; for example, JDBC1, JDBC2.
From the list, select MSDE.
Type OnePoint as the name of the Microsoft Operations Manager database.
IP or Hostname
Type the IP address or host name of the Microsoft Operations Manager SQL Server.
Type the port number that is used by the database server. The default port for MSDE is 1433.
The JDBC configuration port must match the listener port of the Microsoft Operations Manager database. The Microsoft Operations Manager database must have incoming TCP connections that are enabled to communicate with JSA.
If you define a Database Instance when MSDE is used as the database type, you must leave the Port parameter blank in your configuration.
Type the user name that is required to access the database.
Type the password that is required to access the database. The password can be up to 255 characters in length.
Confirm the password that is required to access the database. The confirmation password must be identical to the password entered in the Password parameter.
If you did not select Use Microsoft JDBC, Authentication Domain is displayed.
The domain for MSDE that is a Windows domain. If your network does not use a domain, leave this field blank.
If you have multiple SQL server instances on your database server, type the database instance.
If you use a non-standard port in your database configuration, or block access to port 1434 for SQL database resolution, you must leave the Database Instance parameter blank in your log source configuration.
Type SDKEventView as the name of the table or view that includes the event records.
The list of fields to include when the table is polled for events. You can use a comma separated list or type an asterisk (*) to select all fields from the table or view. If a comma-separated list is defined, the list must contain the field that is defined in the Compare Field.
Type TimeStored as the compare field. The compare field is used to identify new events that are added between queries to the table.
Use Prepared Statements
Select this check box to use prepared statements.
Prepared statements allow the JDBC protocol source to set up the SQL statement one time, then run the SQL statement many times with different parameters. For security and performance reasons, most JDBC protocol configurations use prepared statements.
Clearing this check box requires you to use an alternative method of querying that does not use pre-compiled statements.
Start Date and Time (Optional)
Type the start date and time for database polling in the following format: yyyy- MM-dd HH:mm with HH specified by using a 24-hour clock. If the start date or time is clear, polling begins immediately and repeats at the specified polling interval.
The amount of time between queries to the event table. The default polling interval is 10 seconds.
You can define a longer polling interval by appending H for hours or M for minutes to the numeric value. The maximum polling interval is 1 week in any time format. Numeric values that are entered without an H or M poll in seconds.
Type the number of Events Per Second (EPS) that you do not want this protocol to exceed. The default value is 20000 EPS.
Use Named Pipe Communication
If you did not select Use Microsoft JDBC, Use Named Pipe Communication is displayed.
MSDE databases require the user name and password field to use a Windows authentication user name and password and not the database user name and password. The log source configuration must use the default that is named pipe on the MSDE database
Database Cluster Name
If you select the Use Named Pipe Communication check box, the Database Cluster Name parameter is displayed. If you are running your SQL server in a cluster environment, define the cluster name to ensure Named Pipe communication functions properly.
If you did not select Use Microsoft JDBC, Use NTLMv2 is displayed.
Select this option if you want MSDE connections to use the NTLMv2 protocol when they are communicating with SQL servers that require NTLMv2 authentication. This option does not interrupt communications for MSDE connections that do not require NTLMv2 authentication.
Does not interrupt communications for MSDE connections that do not require NTLMv2 authentication.
Use Microsoft JDBC
If you want to use the Microsoft JDBC driver, you must enable Use Microsoft JDBC.
Select this option if your connection supports SSL.
Selecting a value greater than 5 for the Credibility parameter weights your Microsoft Operations Manager log source with a higher importance compared to other log sources in JSA.
Microsoft SQL Server Hostname
If you selected Use Microsoft JDBC and Use SSL, the Microsoft SQL Server Hostname parameter is displayed.
You must type the host name for the Microsoft SQL server.
- Click Save.
- On the Admin tab, click Deploy Changes.