Versions Compared

Old Version 21

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 22

changes.mady.by.user Nadja Pollard

Saved on

Key

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

...

The two tables below indicate how rules are applied when issuing alerts (both Near-Critical and Critical) for different alert transitions (applies to the following actions: email, message, and program):

Table 16-1 Near-Critical

Old / NewCriticalNear-CriticalNormalNot sampled
CriticalDo not issueIssueDo not issueDo not issue
Near-CriticalIssueDo not issueDo not issueDo not issue
NormalIssueIssueDo not issueDo not issue
Not SampledIssueIssueDo not issueDo not issue

Table 16-2 Critical

Old / NewCriticalNear-CriticalNormalNot sampled
CriticalDo not issueDo not issueDo not issueDo not issue
Near-CriticalIssueDo not issueDo not issueDo not issue
NormalIssueDo not issueDo not issueDo not issue
Not SampledIssueDo not issueDo not issueDo not issue

The table below indicates how rules are applied when issuing alerts for different alert transitions (applies to the following actions: SNMP or MOM):

Table 16-3 SNMP or MOM

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

...

Table 16-4 Dynamic parameters

Dynamic parameterDefinition
$METRIC_NAMEName of the metric.
$METRIC_SETName of the metric set.
$TECHNOLOGY_NAMEName of the instance technology.
$INSTANCE_NAMEName of the instance sampled by the metric.
$APPTIER_NAMEName of one of the AppTiers to which the instance applies.
$APPTIERS_NAMECorrelated to $ENVIRONMENT_NAME.
$ENVIRONMENT_NAMEName of one of the environments to which the instance applies.
$ENVIRONMENTS_NAMEName of one of the environments to which the instance applies.
$METRIC_ALERTThe alert severity level of the metric that was issued when the action was activated.
$SAMPLE_REASON

Reason of the sample that caused the action. The reasons can be one of the following:

  • Schedule. A regular sample, which is initiated according to the sampling schedule.
  • Resample. A sample initiated by clicking the Resample button.
  • Restart. A sample of pre-configured metrics after InformPoint restarts.
  • Resample As Startup. A sample of pre-configured metrics after Alerts FocalPoint restarts.
  • Resample By Demand. A sample due to a change in the instance’s availability (for example, if the monitored Oracle database was shutdown, the Oracle Availability metric will be resampled by demand).
$ITEMSHas been deprecated (will not be used in future versions). Use $METRIC_VALUE instead.
$METRIC_VALUE
  • For Single value metrics:
    Value returned by the metric that was issued when the action was activated.
  • For list metrics:
    List of items returned by the metric sampling. The format of the returned string is as follows:
    Tab-delimited in Email and Message actions.
    Underscore-delimited in Program actions.
$METRIC_TIMEThe time of the last actual sampling.
$SAMPLE_RANGE_START_TIMEThe sampling period start time of the last sample.
$SAMPLE_RANGE_END_TIMEThe sampling period end time of the last sample.
$METRIC_PROGRESSProgress status of the metric.
$PROGRESS_UPDATING_USERRole name of last user that modified the progress status of the metric.
$PROGRESS_UPDATE_TIMETime of the last update of the progress status of the metric.
$THRESHOLDSWarning (near critical) and Critical threshold values defined for the metric. Relevant only for a metric with sub-metrics.
$NEAR_CRITICAL_THRESHOLDWarning (near critical) threshold value defined for the metric. Relevant only for a metric with no sub-metrics.
$CRITICAL_THRESHOLDCritical threshold value defined for the metric. Relevant only for a metric with no sub-metrics.
$SERVER_MACHINE_NAMEName of the server machine on which the instance is running.
$SAMPLING_RATESampling rate of the metric.
$SAMPLING_PERIODSampling period of the metric.
$MIN_VALUEMinimum value that is acceptable for the metric.

An example for using dynamic parameters in Email or Message actions can be found in the Message text box in the Email tab (default message).

...

Table 16-5 MIB tree mapping

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

...

Table 16-6 Available property fields in the MIB

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:

...

Table 16-7 SNMP trap structure

DescriptionAbbreviated object identifier (OID)
Metric7
Instance8
Technology10
Machine11
AppTier12
Environment13
Sampled on6
Alert1
Value15
Thresholds16
Message until v. 8.00

The trap can be parsed with a commercial trap catcher according to the position of the varbinds or their OID. The following apply only to the last varbind on the table (OID=0):

...

Table 16-8 Alert level names in the MOM operator console

Alerts alertMOM severity
NormalSuccess
Near_CriticalWarning
CriticalError
Critical (Key Metric)Critical Error
Not SampledUnknown (alert will not be seen in the MOM console)

Default SQL Server and MS .NET metrics MOM actions definitions

...

Table 16-9 Example of customized metrics with a single value - Windows

Script fileScript linesDescription
simple_example.bat@ECHO OFF ECHO <value>This script returns a constant value that creates a straight line graph.
simple2_example.bat@ECHO OFF

<program_run_command> ECHO

%ERRORLEVEL%		This script indicates whether or not a certain program is running. The script returns 0 if the program runs with no errors, and n>0 if errors occurred. You can set Near-Critical threshold to 1 to alert each time the program fails.

The table below shows an example of customized metrics with multiple values.

Table 16-10 Example of customized metrics with multiple values (table type) — Windows

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

...

Table 16-11 Examples of customized metrics with a single value (UNIX/Linux)

Script fileScript linesDescription
simple_example.sh#!/bin/ksh
echo <value>		This script returns a constant value that creates a straight line graph.
simple2_example.sh

#!/bin/ksh
if
test -e test.txt
then
cat test.txt | wc -c
else

echo 0
fi		This script counts the number of characters of a specified text file. For example, you can set the metric thresholds to alert when the file size exceeds a certain size.

The table below shows an example of customized metrics with multiple values (table type) for UNIX or Linux scripts.

Table 16-12 Example of customized metrics with multiple values (table type) - UNIX/Linux

Script fileScript linesDescription
table_example.bat#!/bin/ksh
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.

Creating customized stored procedures

...

Table 16-13 Dynamic parameters

Dynamic parameterDefinition
@METRIC_IDID of the customized metric.
@METRIC_NAMEName of the customized metric.
@INSTANCE_IDID of the instance that is sampled by the customized metric.
@INSTANCE_NAMEName of the instance that is sampled by the customized metric.
@SERVER_MACHINE_NAMEName of the server machine on which the InformPoint agent is installed.
@INSTANCE_SERVER_MACHINE_NAMEName of the server machine on which the instance is running. (May be differ from @SERVER_MACHINE_NAME only on MS-SQL instances.)
@TECHNOLOGY_CODEThe code of the metric's technology.
@SAMPLING_RATESampling rate (in minutes).
@ANSI_CURRENT_TIMETimestamp of the sampling.
@WARNING_THRESHOLDWarning (near critical) threshold value.
@CRITICAL_THRESHOLDCritical threshold value.
@INCLUDE_LIST

Include list of the items to consider when sampling data (the format is: value1, value2, value3, ...). The values of this parameter equal to the values that you set in the Consider only the following items text box in the threshold tab.

See Defining thresholds on the Thresholds tab.

@EXCLUDE_LIST

Exclude list of the items to ignore when sampling data (the format is: value1, value2, value3, ...). The values of this parameter equal to the values that you set in the Ignore the following items text box in the threshold tab.

See Defining thresholds on the Thresholds tab.

 

Precise. Performance intelligence from click to storage. Learn more > >

...


IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal