Page History
...
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 / New | Critical | Near-Critical | Normal | Not sampled |
---|---|---|---|---|
Critical | Do not issue | Issue | Do not issue | Do not issue |
Near-Critical | Issue | Do not issue | Do not issue | Do not issue |
Normal | Issue | Issue | Do not issue | Do not issue |
Not Sampled | Issue | Issue | Do not issue | Do not issue |
Table 16-2 Critical
Old / New | Critical | Near-Critical | Normal | Not sampled |
---|---|---|---|---|
Critical | Do not issue | Do not issue | Do not issue | Do not issue |
Near-Critical | Issue | Do not issue | Do not issue | Do not issue |
Normal | Issue | Do not issue | Do not issue | Do not issue |
Not Sampled | Issue | Do not issue | Do not issue | Do 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 / New | Critical | Near-Critical | Normal | Not sampled |
---|---|---|---|---|
Critical | Do not issue | Issue | Issue | Issue |
Near-Critical | Issue | Do not issue | Issue | Issue |
Normal | Issue | Issue | Do not issue | Issue |
Not Sampled | Issue | Issue | Do not issue | Do not issue |
Anchor | ||||
---|---|---|---|---|
|
...
Table 16-4 Dynamic parameters
Dynamic parameter | Definition |
---|---|
$METRIC_NAME | Name of the metric. |
$METRIC_SET | Name of the metric set. |
$TECHNOLOGY_NAME | Name of the instance technology. |
$INSTANCE_NAME | Name of the instance sampled by the metric. |
$APPTIER_NAME | Name of one of the AppTiers to which the instance applies. |
$APPTIERS_NAME | Correlated to $ENVIRONMENT_NAME. |
$ENVIRONMENT_NAME | Name of one of the environments to which the instance applies. |
$ENVIRONMENTS_NAME | Name of one of the environments to which the instance applies. |
$METRIC_ALERT | The 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:
|
$ITEMS | Has been deprecated (will not be used in future versions). Use $METRIC_VALUE instead. |
$METRIC_VALUE |
|
$METRIC_TIME | The time of the last actual sampling. |
$SAMPLE_RANGE_START_TIME | The sampling period start time of the last sample. |
$SAMPLE_RANGE_END_TIME | The sampling period end time of the last sample. |
$METRIC_PROGRESS | Progress status of the metric. |
$PROGRESS_UPDATING_USER | Role name of last user that modified the progress status of the metric. |
$PROGRESS_UPDATE_TIME | Time of the last update of the progress status of the metric. |
$THRESHOLDS | Warning (near critical) and Critical threshold values defined for the metric. Relevant only for a metric with sub-metrics. |
$NEAR_CRITICAL_THRESHOLD | Warning (near critical) threshold value defined for the metric. Relevant only for a metric with no sub-metrics. |
$CRITICAL_THRESHOLD | Critical threshold value defined for the metric. Relevant only for a metric with no sub-metrics. |
$SERVER_MACHINE_NAME | Name of the server machine on which the instance is running. |
$SAMPLING_RATE | Sampling rate of the metric. |
$SAMPLING_PERIOD | Sampling period of the metric. |
$MIN_VALUE | Minimum 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 number | Mapped to ... |
---|---|
1 | Oracle |
2 | Sybase |
3 | MS-SQL |
4 | Tuxedo |
5 | Web |
6 | J2EE |
7 | SAP |
8 | Oracle Applications |
9 | Microsoft .NET |
10 | RESERVED |
11 | EMC Storage |
12 | Other |
13 | OS |
14 | Precise status |
15 | WebSphere MQ |
16 | Sybase Replication Server |
17 | DB2 |
Identifying environments and instances in the MIB
...
Table 16-6 Available property fields in the MIB
No. | Field | Description | Applies to |
---|---|---|---|
0 | Value | Specifies the metric's value. Same as the dynamic parameter: Displayed in the Value metrics tab only. In case of a parent metric, only the sub-metrics show this field. | Get |
1 | Status | 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 |
2 | SampleRate | Specifies the sampling rate in minutes. Same as the dynamic parameter: In case of a parent metric, only the parent shows this field. | Get |
3 | NearCrThr | Specifies the metric's Near-critical threshold. Same as the dynamic parameter: In case of a parent metric, only the sub-metrics show this field. | Get |
4 | CriticalThr | Specifies the metric's Critical threshold. Same as the dynamic parameter: In case of a parent metric, only the sub-metrics show this field. | Get |
5 | Enabled | Specifies whether or not the metric is enabled (values: yes or no). | Get |
6 | SampleTime | Specifies the metric's last sampling time. Same as the dynamic parameter: | Get |
7 | MetricName | Specifies the metric's name. Same as the dynamic parameter: | Get |
8 | InstanceName | Specifies the instance's name. Same as the dynamic parameter: | Get |
9 | ItemsTable | Specifies the list of items returned by the metric sampling. Same as the dynamic parameter: Displayed in the list of items of the metrics list. For parent metrics, the list contains also the sub-metrics. | Get |
10 | Technology | Specifies the Technology name. Same as the dynamic parameter: | Get |
11 | Machine | Specifies the Machine name. Same as the dynamic parameter: | Get |
12 | AppTier | Specifies the AppTier name. Same as the dynamic parameter: | Get |
13 | Environment | Specifies the Environment name. Same as the dynamic parameter: | Get |
14 | MetricID | Specifies the Metric ID name. | Get |
15 | Returned value | Specifies the Returned value name. Same as the dynamic parameter: | Get |
16 | Thresholds | Specifies the Thresholds name. Same as the dynamic parameter : | 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
Description | Abbreviated object identifier (OID) |
---|---|
Metric | 7 |
Instance | 8 |
Technology | 10 |
Machine | 11 |
AppTier | 12 |
Environment | 13 |
Sampled on | 6 |
Alert | 1 |
Value | 15 |
Thresholds | 16 |
Message until v. 8.0 | 0 |
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 alert | MOM severity |
---|---|
Normal | Success |
Near_Critical | Warning |
Critical | Error |
Critical (Key Metric) | Critical Error |
Not Sampled | Unknown (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 file | Script lines | Description |
---|---|---|
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 file | Script lines | Description |
---|---|---|
table_example.bat | @ECHO OFF | 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 file | Script lines | Description |
---|---|---|
simple_example.sh | #!/bin/ksh echo <value> | This script returns a constant value that creates a straight line graph. |
simple2_example.sh | #!/bin/ksh 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 file | Script lines | Description |
---|---|---|
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 parameter | Definition |
---|---|
@METRIC_ID | ID of the customized metric. |
@METRIC_NAME | Name of the customized metric. |
@INSTANCE_ID | ID of the instance that is sampled by the customized metric. |
@INSTANCE_NAME | Name of the instance that is sampled by the customized metric. |
@SERVER_MACHINE_NAME | Name of the server machine on which the InformPoint agent is installed. |
@INSTANCE_SERVER_MACHINE_NAME | Name of the server machine on which the instance is running. (May be differ from @SERVER_MACHINE_NAME only on MS-SQL instances.) |
@TECHNOLOGY_CODE | The code of the metric's technology. |
@SAMPLING_RATE | Sampling rate (in minutes). |
@ANSI_CURRENT_TIME | Timestamp of the sampling. |
@WARNING_THRESHOLD | Warning (near critical) threshold value. |
@CRITICAL_THRESHOLD | Critical 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. |
@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. |
Precise. Performance intelligence from click to storage. Learn more > >
...
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal