Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

See About metric properties for Action settings.

Anchor
AboutMetricPropsforActionSettings
AboutMetricPropsforActionSettings
About metric properties for Action settings

An environment that is monitored by Alerts may generate alerts at any time. Sitting in front of the screen waiting for a metric to go critical may be strenuous and time consuming. Instead, you can set Alerts to inform you about any alert, or to run your repair utility to fix certain problems.

...

Old / NewCriticalNear-CriticalNormalNot sampled
CriticalDo not issueIssueIssueIssue
Near-CriticalIssueDo not issueIssueIssue
NormalIssueIssueDo not issueIssue
Not SampledIssueIssueDo not issueDo not issue

Anchor
EmailActionProperties
EmailActionProperties
Email action properties

Use the Email Action Type to set the email address of the recipient and the message text that will be sent when an alert is raised by the specified metric.

...

  1. From the Actions tab on the Metric Properties dialog, select the email option on the Action Type list box.
  2. Select the email action you want to edit.
  3. Click Delete.

Anchor
MessageActionProperties
MessageActionProperties
Message action properties

Use the Message Action Type to set the text message that will be displayed on every screen with an open Alerts user interface, when an alert is raised by the specified metric. The message text can also include dynamic parameters.

...

  1. From the Actions tab on the Metric Properties dialog, select the message option on the Action Type list box.
  2. Select the message action you want to edit.
  3. Click Delete.

Anchor
ProgramActionProperties
ProgramActionProperties
Program action properties

Use the Program Action Type to set your program to be ran as an action when an alert is raised by the specified metric.

...

  1. From the Actions tab on the Metric Properties dialog, select the program option on the Action Type list box.
  2. Select the program action you want to edit.
  3. Click Delete.

Anchor
SNMPActionProperties
SNMPActionProperties
SNMP action properties

Use the SNMP Action Type to set alerts to be reported to an SNMP based management tool that you may have, such as CA Unicenter® and HP OpenView.

...

  1. From the Actions tab, select the SNMP option on the Action Type list box.
  2. To apply SNMP traps, check Send an SNMP trap whenever the metric alert level changes.
  3. To test your definitions, click Test.
  4. To save your definitions, choose whether to save them either for the selected instance, or for all the environments’ instances. Then click Save and Close.

Anchor
MOMActionProperties
MOMActionProperties
MOM action properties

Use the MOM Action Type to set alerts to be reported to the MOM server whenever the metric alert level changes.

...

To enable this option, first create a Management Information Bases (MIB) file. The MIB file maps the Alerts database entities, such as the various environments, various instances, and the metrics relevant for each of the instances. Because different sites have different environments, instances, and so on, you must adjust the Alerts MIB file to each site.

Creating an MIB file

Alerts FocalPoint creates the MIB file and displays its status (success or failure) on the standard output. The newly created MIB file name is InformForAlertsMib.mib and is stored in the following directory:

...

On a Linux or UNIX server. <i3_root>/products/pulse/pulsefocal/bin/ createalertsmib.sh

Enabling the Get operation

To use your MIB browser to open the MIB file that you have created and browse the different metrics, you must set the Get parameters on both your SNMP manager and Alerts. The examples provided along with the following instructions relate to the CA Unicenter MIB browser, which is an SNMP management application.

...

  • Technology representation
  • Identifying environments and instances in the MIB
  • Identifying metrics in the MIB
  • Identifying property fields in the MIB
  • MIB structure

Technology representation

The MIB tree shows the technologies of the Precise environment as the numbers 1 - 15. The table below shows how each number in a MIB tree is mapped to a technology.

...

MIB numberMapped to ...
1Oracle
2Sybase
3MS-SQL
4Tuxedo
5Web
6J2EE
7SAP
8Oracle Applications
9Microsoft .NET
10RESERVED
11EMC Storage
12Other
13OS
14Precise status
15WebSphere MQ
16Sybase Replication Server
17DB2

Identifying environments and instances in the MIB

Alerts displays environments and instances by their names (environment_name, instance_name), while the MIB presents them by their identifiers (environment_id, instance_id).

...

  1. Retrieve a mapping table that maps the environment and instance names to their identifiers by running the following SQL statement in the Alerts schema:
    select
         INCE_ID INSTANCE_ID, INCE_NAME
         INSTANCE_NAME, INEN_ID
         ENVIRONMENT_ID, INEN_NAME
         ENVIRONMENT_NAME
    from
    PS_INCE_INSTANCE_INSTANCE, PS_INII_INSTANCE_APPTIER
    INSTANCE_APPTIER, PS_INAP_APP_TIER APPTIER,
    PS_INEN_ENVIRONMENT ENVIRONMENT
    where
         INCE_ID = INII_INCE_ID AND
         INAP_ID = INII_INAP_ID AND
         INAP_INEN_ID = INEN_ID AND
         INCE_DELETED = ‘F’ AND
         INII_DELETED = ‘F’ AND
         INAP_DELETED = ‘F’ AND
         INEN_DELETED = ‘F’ AND

Identifying metrics in the MIB

Alerts displays metrics by their names (metric_name), while the MIB presents them by their identifiers (metric_id).

...

  • Retrieve a mapping table that maps between the metric names and their identifiers by running the following SQL statement in the Alerts schema:
    select indicator_id,indicator_name, from pulse_indicators order by indicator_name;

Available property fields in the MIB

The table below describes the available property fields for a metric.

...

No.FieldDescriptionApplies to
0Value

Specifies the metric's value.

Same as the dynamic parameter: $METRIC_VALUE

Displayed in the Value metrics tab only. In case of a parent metric, only the sub-metrics show this field.

Get
1Status

Specifies the metric's status. Possible values: Critical, Near-critical, Normal, and Unsampled.

In the MIB browser, Downtime and Disabled statuses appear also as Unsampled status.

Get
2SampleRate

Specifies the sampling rate in minutes.

Same as the dynamic parameter: $SAMPLING_RATE

In case of a parent metric, only the parent shows this field.

Get
3NearCrThr

Specifies the metric's Near-critical threshold.

Same as the dynamic parameter: $NEAR_CRITICAL_THRESHOLD

In case of a parent metric, only the sub-metrics show this field.

Get
4CriticalThr

Specifies the metric's Critical threshold.

Same as the dynamic parameter: $CRITICAL_THRESHOLD

In case of a parent metric, only the sub-metrics show this field.

Get
5EnabledSpecifies whether or not the metric is enabled (values: yes or no).Get
6SampleTime

Specifies the metric's last sampling time.

Same as the dynamic parameter:  $ACTUAL_SAMPLING_TIME

Get
7MetricName

Specifies the metric's name.

Same as the dynamic parameter: $METRIC_NAME

Get
8InstanceName

Specifies the instance's name.

Same as the dynamic parameter: $INSTANCE_NAME

Get
9ItemsTable

Specifies the list of items returned by the metric sampling.

Same as the dynamic parameter: $ITEMS

Displayed in the list of items of the metrics list. For parent metrics, the list contains also the sub-metrics.

Get
10Technology

Specifies the Technology name.

Same as the dynamic parameter: $TECHNOLOGY_NAME

Get
11Machine

Specifies the Machine name.

Same as the dynamic parameter: $SERVER_MACHINE_NAME

Get
12AppTier

Specifies the AppTier name.

Same as the dynamic parameter: $APPTIER_NAME

Get
13Environment

Specifies the Environment name.

Same as the dynamic parameter: $ENVIRONMENT_NAME

Get
14MetricIDSpecifies the Metric ID name.Get
15Returned value

Specifies the Returned value name.

Same as the dynamic parameter: $METRIC_VALUE

Get
16Thresholds

Specifies the Thresholds name.

Same as the dynamic parameter :$THRESHOLDS

Get

MIB structure

The Alerts MIB structure complies with the Alerts SNMP Object Identifier (OID) structure. The OID of the Alerts Get requests for a specified metric is:

...

Alerts supports both SNMP message versions, SNMPv1 and SNMPv2. Alerts sends traps when a change occurs in a metric severity level, that is, when the metric state is changed between the following states: Critical, Near-Critical, Normal, and Unsampled.

Alerts trap message

The following is an example of an Alerts'SNMP trap message:

...

To activate and deactivate the Alerts integration with the MOM server, go to Setting a MOM server for actions on the MOM tab.

Setting anonymous access to a MOM server

Before integrating Alerts with the MOM server in AdminPoint, anonymous access to the MOM Web console must be set.

...

To simulate a run of customized metric, use a command line shell and type from the Precise root directory:

For Windows operating systems      .\products\pulse\userprograms\MYPROG.bat.

For UNIX or Linux operating systems     ./products/pulse/userprograms/MYPROG.sh.

...

Info

It is recommended to test your scripts in your environment before running them through Alerts. For UNIX scripts, verify that the script has rx security permissions.

Windows script examples

The examples for Windows scripts, whose file names end with _example, are listed in the following tables. These files can be found also in any server where InformPoint is installed, in the directory:

...

Script fileScript linesDescription
table_example.bat

@ECHO OFF
ECHO Demo 0
ECHO Demo2 1

ECHO Demo3 2
This script returns a list of items including their values for each sample. A tab character (not space) separates between the item name and the item value.

UNIX/Linux shell script examples

The examples for UNIX/Linux shell scripts, which their file names end with _example, are listed in the following tables. These files can be found also in any server where InformPoint is installed, in the directory:

...

In addition, the stored procedure can be defined only in Oracle or SQL Server AppTier instances. To create Oracle stored procedure metrics, you must install the Precise for Oracle FocalPoint with at least one instance. To create MS-SQL stored procedure metrics, you must install the Precise for SQL Server FocalPoint with at least one instance.

Creating MS-SQL stored procedures

When creating a stored procedure in MS-SQL, apply the following guidelines:

...

  1. Apply the following format:
    CREATE PROCEDURE user_def @@var1 type1, ...., @@var-n type-n
    AS
    - Custom query
    GO
  2. Use the following format within the call from the customized metric (the code should be entered in the Program box when adding a new Customized Metric):
    user_database..user_def val1, ...., val-n

Example of an MS-SQL stored procedure

The following stored procedure enables Alerts to send an email when the number of rows in a table called SALES.ITEMS reaches an amount that you set in the Thresholds tab.

...

  1. Connect to the database schema of the Precise for SQL Server.
  2. Run the function user_def in the user_database as follows:
    user_database..user_def sampling_rate , sampling_period

Creating Oracle stored procedures

When creating a stored procedure in Oracle, apply the following guidelines:

...

You can use any package or function name, and an unlimited number of parameters (including NONE).

Example of an Oracle stored procedure

The following stored procedure enables Alerts to send an email when the number of rows in a table called ITEMS, which belongs to a user called SALES, reaches an amount that you set in the Thresholds tab.

...