Table Of Contents
IPM 4.1 Database Schema
Source Table
Target Table
IPM Device Table
Operation Table
IPEcho Sub-Operation Table
UDPEcho Sub-Operation Table
PathEcho Sub-Operation Table
Jitter Sub-Operation Table
ICMP Jitter Sub-Operation Table
RTP Sub-Operation Table
Ethernet Sub-Operation Table
HTTP Operation Table
DNS Operation Table
FTP Operation Table
DHCP Operation Table
DLSw Operation Table
Post Dial Delay Operation Table
TcpConnect Operation Table
React Table
Collector Table
Collector Schedule Table
Latency Minute Statistics Table
Availability Latency Hourly Statistics Table
Availability Latency Daily Statistics Table
Availability Latency Weekly Statistics Table
Availability Latency Monthly Statistics Table
Jitter Minute Statistics Table
Jitter Hourly Statistics Table
Jitter Daily Statistics Table
Jitter Weekly Statistics Table
Jitter Monthly Statistics Table
ICMP Jitter Minute Statistics Table
ICMP Jitter Hourly Statistics Table
ICMP Jitter Daily Statistics Table
ICMP Jitter Weekly Status
ICMP Jitter Monthly Statistics Table
Ethernet Jitter Minute Statistics Table
Ethernet Jitter Hourly Statistics Table
Ethernet Jitter Daily Statistics Table
Ethernet Jitter Weekly Statistics Table
Ethernet Jitter Monthly Statistics Table
HTTP Minute Statistics Table
HTTP Hourly Statistics Table
HTTP Daily Statistics Table
HTTP Weekly Statistics Table
HTTP Monthly Statistics Table
Patheco Hourly Statistics Table
Pathecho Daily Statistics Table
Pathecho Weekly Statistics Table
Pathecho Monthly Statistics Table
RTP Minute Statistics Table
RTP Hourly Statistics Table
RTP Daily Statistics Table
RTP Weekly Statistics Table
RTP Monthly Statistics Table
IPM 4.1 Database Schema
A schema is a layout of a database that outlines the way a data is organized into tables. A schema defines the tables, fields in each table and the relationships between fields and tables.
This chapter contains the following tables:
•
Source Table
•Target Table
•IPM Device Table
•Operation Table
•IPEcho Sub-Operation Table
•UDPEcho Sub-Operation Table
•PathEcho Sub-Operation Table
•Jitter Sub-Operation Table
•ICMP Jitter Sub-Operation Table
•RTP Sub-Operation Table
•Ethernet Sub-Operation Table
•HTTP Operation Table
•DNS Operation Table
•FTP Operation Table
•DHCP Operation Table
•DLSw Operation Table
•Post Dial Delay Operation Table
•TcpConnect Operation Table
•React Table
•Collector Table
•Collector Schedule Table
•Latency Minute Statistics Table
•Availability Latency Hourly Statistics Table
•Availability Latency Daily Statistics Table
•Availability Latency Weekly Statistics Table
•Availability Latency Monthly Statistics Table
•Jitter Minute Statistics Table
•Jitter Hourly Statistics Table
•Jitter Daily Statistics Table
•Jitter Weekly Statistics Table
•Jitter Monthly Statistics Table
•ICMP Jitter Minute Statistics Table
•ICMP Jitter Hourly Statistics Table
•ICMP Jitter Daily Statistics Table
•ICMP Jitter Weekly Status
•ICMP Jitter Monthly Statistics Table
•Ethernet Jitter Minute Statistics Table
•Ethernet Jitter Hourly Statistics Table
•Ethernet Jitter Daily Statistics Table
•Ethernet Jitter Weekly Statistics Table
•Ethernet Jitter Monthly Statistics Table
•HTTP Minute Statistics Table
•HTTP Hourly Statistics Table
•HTTP Daily Statistics Table
•HTTP Weekly Statistics Table
•HTTP Monthly Statistics Table
•Patheco Hourly Statistics Table
•Pathecho Daily Statistics Table
•Pathecho Weekly Statistics Table
•Pathecho Monthly Statistics Table
•RTP Minute Statistics Table
•RTP Hourly Statistics Table
•RTP Daily Statistics Table
•RTP Weekly Statistics Table
•RTP Monthly Statistics Table
Source Table
Table B-1
Column Name
|
Type
|
Constraints
|
Description
|
DeviceID
|
Biginit
|
IDENTITY,
primary key
|
Unique identifier
|
IOSVersion
|
Varchar(64)
|
Null
|
Version of the IOS
|
MaxColl
|
Integer
|
Null
|
Estimated System.
The maximum number of entries in the router.
|
LastTimeSet
|
Timestamp
|
Null
|
The last time at which a set operation occured on any of the objects in this MIB.
See MIB object:
rttMonApplTimeOfLastSet
|
DisplayName
|
Varchar(255)
|
Null
|
Display name of the device
|
IPSLAVersion
|
Varchar(16)
|
Null
|
See MIB object:
rttMonApplVersion
MIB type: DisplayString
Round Trip Time monitoring application version string
|
CollCount
|
Integer
|
Null
|
Estimated number of configurable operations in the router.
See MIB object:
rttMonApplProbeCapacity
|
Source Table
Note Source Table (table name `Source') contains all necessary information about a source router. A unique device ID is assigned to each source router. This device ID acts as the Primary Key of the table.
Target Table
Table B-2 Target Table
Column Name
|
Type
|
Constraints
|
Description
|
DeviceID
|
Bigint
|
IDENTITY, Primary key
|
Unique identifier
|
DisplayName
|
Varchar(255)
|
Null
|
Display name of the device
|
DeviceType
|
Integer
|
Null
|
Type of target
0 = ip target
1 = responder enabled
2 = adhoc device
|
Note Target Table (table name `Target') contains all pertinent information about a target. This target could be an SAA router, IPSLA responder enabled device or an adhoc device. A unique device ID is assigned to each target in the table. This device ID acts as the Primary Key of the table.
IPM Device Table
Table B-3 IPM Device Table
Column Name
|
Type
|
Constraints
|
Description
|
DeviceID
|
Bigint
|
IDENTITY ,Primary key
|
Unique identifier
|
DCRID
|
Varchar(255)
|
Null
|
Device ID from the DCR table
|
snmptimeout
|
Bigint
|
Null
|
Duration of time that a system should wait for a device to respond before the system re-tries to access the device.
The SNMP timeout values are displayed in milliseconds.
The default value is 2.
The minimum value is 0.
There is no maximum value.
|
snmpretry
|
Bigint
|
Null
|
Number of times the system retries to access devices using SNMP options.
The default value is 3.
The minimum value is 0 .
The maximum value is 6.
|
Operation Table
Table B-4 Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
IDENTITY,
primary key
|
Unique identifier
|
CreationFlag
|
Integer
|
Not Null
|
Flag 0 - system defined operations
Flag 1 - user defined operations
|
Operation Name
|
Varchar(127)
|
Not Null
|
Unique operation name
|
Owner
|
Varchar(64)
|
Null
|
See MIB object:
rttMonCtrlAdminOwner
MIB type:
OwnerString
Owner of the Operation
|
Descr
|
Varchar(255)
|
Null
|
Description
|
RTTType
|
Integer
|
Null
|
See MIB object:
rttMonCtrlAdminRttType
MIB type:
RttMonRttType
Default Value:
{echo}
Specifies the type of RTT operation to be performed:
1 = echo
2 = pathEcho
5 = udpEcho
6 = tcpConnect
7 = http
8 = dns
9 = jitter
10 = dlsw
11 = dhcp
12 = ftp
14 = RTP
16 = icmpjitter
18 = VoipCallSetupPostDialDelay
19 = VoipGKRegDelay
1019-Ethernetping
1020-Ethernetjitter
1119-EthernetPingAutoIPSLA
1120-EthernetPingAutoIPSLA
|
Frequency
|
Integer
|
Null
|
See MIB object:
rttMonCtrlAdminFrequency
MIB type:
Integer32(0..604800)
The frequency values are displayed in seconds.
Default Value:
{ 60 }
Duration between initiating RTT
requests
|
timeout
|
Integer
|
Null
|
See MIB object:
rttMonCtrlAdminTimeout
MIB type:
Integer32(0..604800000)
Default Value:
{ 5000 }
Duration to wait for an RTT response
|
adminThreshold
|
Integer
|
Not Null
|
Threshold range in milli seconds
|
VRFName
|
Varchar(127)
|
Not Null
|
Unused
|
verifydata
|
smallint
|
Not Null
|
See MIB object:
rttMonCtrlAdminVerifyData
Default Value : false
|
Operation Table (table name `operation') contains general parameters for an operation, such as frequency, rtt type, threshold type,and so on.
For parameters tied to specific type of operation, check the detailed sub-operation table for the specific type of operation.
A unique Operation ID is also assigned to each operation in the table. This Operation ID acts as the Primary Key of the table.
IPEcho Sub-Operation Table
Table B-5 IP Echo Sub-Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
Not Null
|
Reference to operation(ID)
|
DataReqSize
|
Integer
|
Not Null
|
See MIB object:
rttMonEchoAdminPktDataRequestSize
MIB type:
Integer32(0..16384)
Default Value:
{1}
Number of OCTETS to include in the request data.
|
TypeOfService
|
Integer
|
Not Null
|
See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
|
UDPEcho Sub-Operation Table
Table B-6 UDP Echo Sub-Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
Not Null
|
Reference to operation(ID)
|
TypeOfService
|
Integer
|
Not Null
|
See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
|
ReqPayload
|
Integer
|
Not Null
|
See MIB object
rttMonEchoAdminPktDataRequestSize
MIB type
Integer32(0..16384)
Default Value
{1}
Number of OCTETS to include in the request data.
|
TargetPort
|
Integer
|
Not Null
|
See MIB object:
rttMonEchoAdminTargetPort
MIB type:
Integer32(0..65536)
Default Value:
{0}
The target's port number.
|
PathEcho Sub-Operation Table
Table B-7 Path Echo Sub-Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
Not Null
|
Reference to operation(ID)
|
TypeOfService
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
|
DataReqSize
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminPktDataRequestSize
MIB type:
Integer32(0..16384)
Default Value:
{1}
Number of OCTETS to include in the request data
|
MaximumPaths
|
Integer
|
Null
|
See MIB object:
rttMonStatisticsAdminNumPaths
MIB type:
Integer32(1..128)
Default Value:
{ 5 }
Maximum number of statistics route buckets to keep
|
MaximumHops
|
Integer
|
Null
|
See MIB object:
rttMonStatisticsAdminNumHops
MIB type:
Integer32(1..30)
Default Value:
{16}
Maximum number of statistics hop buckets to keep
|
LSREnable
|
Varchar(127)
|
Not Null
|
Reserved
|
LSRHop1
|
Varchar(127)
|
Not Null
|
Reserved
|
LSRHop2
|
Varchar(127)
|
Not Null
|
Reserved
|
LSRHop3
|
Varchar(127)
|
Not Null
|
Reserved
|
LSRHop4
|
Varchar(127)
|
Not Null
|
Reserved
|
LSRHop5
|
Varchar(127)
|
Not Null
|
Reserved
|
LSRHop6
|
Varchar(127)
|
Not Null
|
Reserved
|
LSRHop7
|
Varchar(127)
|
Not Null
|
Reserved
|
LSRHop8
|
Varchar(127)
|
Not Null
|
Reserved
|
Jitter Sub-Operation Table
Table B-8 Jitter Sub-Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
Not Null
|
Reference to operation(ID)
|
sampleinterval
|
|
|
Unused
|
TypeofService
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
|
reqPayload
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminCodecPayload
MIB type:
Integer32
|
trgtPort
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminTargetPort
MIB type:
Integer32(0..65536)
Default Value:
{0}
The target's port number.
|
numpacket
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminNumPackets
MIB type:
Integer32
Default Value:
{10}
Number of packets that need to be transmitted
|
pktInterval
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminInterval
MIB type:
Integer32(0..60000)
Default Value:
{20}
The inter-packet delay between packets. This is in milliseconds
|
respStatusOfTarget
|
Integer
|
Null
|
Statistics of the target
|
codecType
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminCodecType
MIB type: Integer32
|
icpifAdvFactor
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminICPIF
AdvFactor
MIB type: Integer32
|
isCodecSupport
|
Varchar(6)
|
Null
|
Codec support
|
precisionlevel
|
tinyint
|
Not Null
|
Precision level
See MIB object
rttMonEchoAdminPrecision
MIB type 32
DefaultValue:
millisecond(1)
Accuracy of statistics that needs to be calculated
•milliseconds(1). The accuracy of statistics will be in milliseconds.
•microseconds(2). The accuracy of statistics will be in microseconds
|
ICMP Jitter Sub-Operation Table
Table B-9 ICMP Jitter Sub-Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
UNIQUE
|
Reference to operation(ID)
|
TypeOfService
|
Integer
|
Not Null
|
See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
|
ReqPayload
|
Integer
|
Not Null
|
Unused
|
NumOfPackets
|
Integer
|
Not Null
|
See MIB object:
rttMonEchoAdminNumPackets
MIB type:
Integer32
Default Value:
{10}
Number of packets that need to be transmitted
|
PktInterval
|
Integer
|
Not Null
|
See MIB object:
rttMonEchoAdminInterval
MIB type: Integer32
|
RTP Sub-Operation Table
Table B-10 RTP Sub-Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
UNIQUE
|
Reference to operation(ID)
|
SourceIP
|
Varchar(127)
|
Null
|
Source IP
|
SourceVoicePort
|
Varchar(127)
|
Null
|
See MIB object:
rttMonEchoAdminSourceVoicePort
MIB type: Octets
|
CodecType
|
smallint
|
Null
|
See MIB object:
rttMonEchoAdminCodecType
MIB type: Integer32
|
CallDuration
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminCallDuration
MIB type: Integer32
|
AdvantageFactor
|
Integer
|
Null
|
Advantage Factor range from 0 to 20
|
Ethernet Sub-Operation Table
Table B-11 Ethernet Sub-Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
UNIQUE
|
Reference to operation(ID)
|
vlanID
|
Integer
|
Not Null
|
See MIB object:
•ethernetPing - rttMonEchoAdminTargetVLAN
•ethernetJitter - rttMonEchoAdminTargetVLAN
•ethernetPingAutoIPSLA - ipslaEthernetGrpCtrlVLAN
•ethernetJitterAutoIPSLA - ipslaEthernetGrpCtrlVLAN
|
domainName
|
Varchar(255)
|
Not Null
|
See MIB object:
•ethernetPing - rttMonEchoAdminTargetDomainName
•ethernetJitter - rttMonEchoAdminTargetDomainName
•ethernetPingAutoIPSLA - ipslaEthernetGrpCtrlDomainName
•ethernetJitterAutoIPSLA - ipslaEthernetGrpCtrlDomainName
|
mepIDs
|
Varchar(8192)
|
Null
|
See MIB object:
rttMonEchoAdminTargetMPID
|
exMepIDs
|
Varchar(8192)
|
Null
|
See MIB object:
ipslaEthernetGrpCtrlMPIDExLst
|
classOfService
|
Integer
|
Null
|
See MIB object:
•ethernetPing - rttMonEchoAdminEthernet
COS
•ethernetJitter - rttMonEchoAdminEthernet
COS
•ethernetPingAutoIPSLA - ipslaEthernetGrpCtrlCOS
•ethernetJitterAutoIPSLA - ipslaEthernetGrpCtrlCOS
|
packetReqSize
|
Integer
|
Null
|
See MIB object:
•ethernetPing,ethernetJitter - rttMonEchoAdminPktData
RequestSize
•ethernetPingAutoIPSLA, ethernetJitterAutoIPSLA - ipslaEthernetGrpCtrlReq
DataSize
|
numOfFrames
|
Integer
|
Null
|
Specify the number of frames between 1 and 60000
|
frameInterval
|
Integer
|
Null
|
Specify the interval between 1 and 60000
|
schedulePeriod
|
Integer
|
Null
|
Scheduling Period
|
HTTP Operation Table
Table B-12 HTTP Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
Not Null
|
Reference to operation(ID)
|
Port
|
Integer
|
Null
|
Target Port No
See MIB object
rttMonEchoAdminTargetPort
MIB type Integer32
DefaultValue:80
|
URLRelativePath
|
Varchar(127)
|
Null
|
See MIB object:
rttMonEchoAdminURL
MIB type:
DisplayString
Default Value:
{""}
String that represents the URL to which an HTTP probe should communicate with.
|
CachedPagesFlag
|
Smallint
|
Null
|
See MIB object:
rttMonEchoAdminCache
MIB type:
TruthValue
Default Value:
{true}
If false, then the HTTP request should not download cached pages. Hence, the request must be forwarded to the original server.
|
ProxyServer
|
Varchar(255)
|
Null
|
See MIB object:
rttMonTargetAddress
|
EnableProxy
|
Smallint
|
Null
|
Checkbox for enabling proxy server.
The default value is 2
|
TypeOfService
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP Header.
|
DnsNameServer
|
Varchar(127)
|
Not Null
|
See MIB object:
rttMonEchoAdminNameServer
MIB type: Octets
|
EnableDns
|
Smallint
|
Not Null
|
Checkbox for enabling dnsname server.
The default value is 2.
|
DNS Operation Table
Table B-13 DNS Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
Not Null
|
Reference to operation(ID)
|
targetaddr
|
Varchar(127)
|
Null
|
Unused
|
nameserver
|
Varchar(127)
|
Null
|
See MIB object:
rttMonEchoAdminNameServer
MIB type:
RttMonTargetAddress
Default Value:
{""}
The IP Address of the nameserver
|
namesvraddr
|
Varchar(127)
|
Null
|
IP Address of nameserver
|
FTP Operation Table
Table B-14 FTP Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
Not Null
|
Reference to operation(ID)
|
TypeOfService
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
|
FTPMode
|
Integer
|
Null
|
rttMonAdminMode
Set to active or passive FTP mode
|
UserName
|
Varchar(127)
|
Null
|
The username for FTP that enables you to access the FTP server.
|
Password
|
Varchar(127)
|
Null
|
The Password for FTP in encrypted format.
The password that enables you to access the FTP server.
|
FileLocation
|
Varchar(127)
|
Null
|
FTP file location
|
DHCP Operation Table
Table B-15 DHCP Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
Not Null
|
Reference to operation(ID)
|
targetaddr
|
Varchar(127)
|
Null
|
See MIB object:
rttMonEchoAdminTargetAddress
MIB type:
RttMonTargetAddress
Default Value:
{""}
The address of the target
|
targetipaddr
|
Varchar(127)
|
Null
|
IP Address of the DHCP server
|
DLSw Operation Table
Table B-16 DLSw Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
Not Null
|
Reference to operation(ID)
|
ReqPayload
|
Varchar(127)
|
Null
|
See MIB object:
rttMonEchoAdminCodecPayload
MIB type:
Integer32
|
ResponsePayload
|
Varchar(127)
|
Null
|
unused
|
Post Dial Delay Operation Table
Table B-17 Post Dial Delay Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
Not Null
|
Reference to operation(ID)
|
PhoneNumber
|
Varchar(127)
|
Null
|
Phone number
|
DetectPoint
|
Integer
|
Null
|
See MIB object
rttMonEchoAdminDetectPoint
Default value : 1: voipDTAlertRinging (name)
|
TcpConnect Operation Table
Table B-18 Tcp Connect Operation Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
Not Null
|
Reference to operation(ID)
|
TargetPort
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminTargetPort
MIB type:
Integer32(0..65536)
Default Value:
{0}
The target's port number.
|
ControlEnable
|
Smallint
|
Null
|
See MIB object:
rttMonEchoAdminControlEnable
MIB type:
TruthValue
Default Value:
{true}
If enabled, the RTR application will send control messages to a responder, in the target router.
This will respond to the data request packets being sent by the source router.
|
TypeOfService
|
Integer
|
Null
|
See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
|
React Table
Table B-19 React Table
Column Name
|
Type
|
Constraints
|
Description
|
OperationID
|
Bigint
|
Unique identifier,
primarykey
|
Reference to Operation (ID).
|
reactvar
|
Integer
|
Not Null
|
React variable
See MIB object:
rttMonReactVar
|
reactID
|
Integer
|
Not Null
|
React ID
See MIB object:
rttMonReactVar
|
RisingThresh
|
Integer
|
Null
|
Rising threshold value
See MIB object:
rttMonReactThreshold
Rising
|
FallingThresh
|
Integer
|
Null
|
Falling threshold value
See MIB object:
rttMonReactThreshold
Falling.
If this new MIB is not supported the following MIB will be used:
rttMonReactAdmin
ThresholdFalling
|
XthreshCount
|
Integer
|
Null
|
X threshold count
See MIB object:
rttMonReactThresholdCountX .
If this new MIB is not supported the following MIB will be used:
rttMonReactAdmin
ThresholdCount
|
YthreshCount
|
Integer
|
Null
|
Y thershold count
See MIB object:
rttMonReactThreshold
CountY
If this new MI B is not supported the following MIB will be used:
rttMonReactAdmin
ThresholdCount2
|
ThreshType
|
Integer
|
Null
|
Threshold type
See MIB object:
:rttMonReactThreshold
Type
If the new MIB is not used the following MIB will be used:
:rttMonReactAdmin
ThresholdType
|
ActionType
|
Integer
|
Null
|
Action type
See MIB object:
rttMonReactActionType
If the new MIB is not supported, the following MIB will be used.
:rttMonReactAdmin
ActionType
|
Collector Table
Table B-20 Collector Table
Column Name
|
Type
|
Constraints
|
Description
|
ID
|
Bigint
|
IDENTITY,
Primary key
|
Unique identifier for collector
|
Name
|
Varchar(255)
|
Null
|
Collector Name
|
descr
|
"
|
Null
|
Description
|
SourceID
|
Varchar(50)
|
"
|
Source.
Reference to source(ID)
|
SourceIntAddr
|
"
|
"
|
Source interface address
|
TargetID
|
"
|
"
|
Target.
Reference to target(ID)
|
OperationID
|
"
|
"
|
Operation.
Reference to operation (ID)
|
ScheduleID
|
bigint
|
"
|
ScheduleID of the collector
Reference to the Collector Schedule (ID).
|
Owner
|
Varchar(255)
|
"
|
Owner
|
Status
|
Integer
|
"
|
Current Statistics of the collector
1=Running
2=Completed
3=Dormant
4=Suspended
5=Cancelled
6=Config failed
7=Scheduled
8=Delete pending
10=Config pending
11=Update pending
12=Resume pending
13=Suspend pending
14=Cancel pending
15=Reconfig pending
16=Source not responding
17=Complete pending
18=Dormant pending
19=End point missing
|
PreviousStatus
|
"
|
"
|
Previous Statistics of the collector
|
StatusInfo
|
Varchar(255)
|
"
|
Statistics information of the collector
|
AdminIndex
|
Integer
|
"
|
Entry number assigned for this collector in the SAA agent
|
Tag
|
Varchar(255)
|
"
|
Name of the collector to be sent to device (15 char limit)
|
OpType
|
Integer
|
"
|
Operation type for this collector.
This information is duplicated in the Type column in the Operation table.
|
CollectorType
|
"
|
"
|
Collector type:
2 = Monitored.
1 = Statistical. Historical statistical data will be collected and saved into database.
|
PollInterval
|
bigint
|
"
|
Polling interval
|
OpName
|
Varchar(255)
|
"
|
Operation name
|
SourceAddress
|
Varchar(50)
|
"
|
IP Address or HostName of source device from DCR_device_detail of CMF table.
|
TargetAddress
|
"
|
"
|
IP Address or Host Name of the target device from DCR_device_detail of CMF table.
|
AutoIPSLA
Parent
|
bigint
|
Not Null
|
Associated Parent Collector ID
|
IsToBe
Reconfigured
|
smallint
|
Not Null
|
Flag whether to configure the collector or not.
|
Collector Schedule Table
Table B-21 Collector Schedule Table
Column Name
|
Type
|
Constraints
|
Description
|
ID
|
bigint
|
IDENTITY,
primary key
|
Unique identifier for collector
Reference to Collector (ID)
|
scheduleType
|
Integer
|
Null
|
Schedule type
|
startDate
|
bigint
|
"
|
Start date of the collector
|
startTime
|
Timestamp
|
"
|
Start time of the collector
|
endDate
|
bigint
|
"
|
End date
|
endTime
|
Timestamp
|
"
|
End time
|
daysOfWeek
|
Integer
|
"
|
Days of week for polling
|
suspendedTimestamp
|
bigint
|
"
|
Suspended time period
|
resumeTimestamp
|
"
|
"
|
Resume time period
|
Latency Minute Statistics Table
Table B-22 Latency Minute Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
RowID
|
Bigint
|
IDENTITY,
Primary key
|
Unique identifier
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
StartTime
|
Timestamp
|
Not Null
|
Start time of the latest RTT operation
|
Latency_RTT
|
Integer
|
Not Null
|
See MIB object:
rttMonLatestRttOperTim.
The value of the agent system time at the time of the latest RTT operation.
|
Availability Latency Hourly Statistics Table
Table B-23 Availability Latency Hourly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
RowID
|
Bigint
|
IDENTITY,
Primary key
|
Unique identifier
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
StartTime
|
Timestamp
|
Not Null
|
Start time of this hourly bucket
|
MinRTT
|
Integer
|
Not Null
|
See MIB object:
rttMonStatsCapture
Completion-
TimeMin
MIB type:
Gauge32
Minimum RTT
|
MaxRTT
|
Integer
|
Not Null
|
Maximum of RTT.
See MIB object:
rttMonStatsCapture
Completion-
TimeMax
MIB type:
Gauge32
Maximum RTT
|
SumRTT
|
Integer
|
Not Null
|
See MIB object:
rttMonStatsCaptureSum
CompletionTime
MIB type:
Gauge32
Accumulated RTTs
|
SumSqrdRTT
|
Integer
|
Not Null
|
Sum square of all RTT
See MIB object:
rttMonStatsCaptureSum
CompletionTime2Low, rttMonStatsCaptureSum
CompletionTime2HighionT
ime2High
Accumulated RTT Squares
|
Num
Completions
|
Integer
|
Not Null
|
See MIB object:
rttMonStatsCapture
CompletionsMIB type:
Integer32(0..2147483647)
Number of RTTs completed
|
NumOverThresholds
|
Integer
|
Not Null
|
Number of overthresholds.
See MIB object:
rttMonStatsCaptureOver
Thresholds
MIB type:
Integer32(0..2147483647)
Number of OverThresholds
|
NumDisconnects
|
Integer
|
Not Null
|
Number of Disconnects.
See MIB object:
rttMonStatsCollectNum
Disconnects
MIB type:
Integer32(0..2147483647)
|
NumTimeouts
|
Integer
|
Not Null
|
Number of Timeouts
See MIB object:
rttMonStatsCollectTimeout
MIB type:
Integer32(0..2147483647)
|
NumBusies
|
Integer
|
Not Null
|
Number of busies
See MIB object:
rttMonStatsCollectBusies
MIB type:
Integer32(0..2147483647)
Number of Busies
|
NumNoConnections
|
Integer
|
Not Null
|
See MIB object:
rttMonStatsCollectNo
Connections
MIB type:
Integer32(0..2147483647)
Number of Connections
|
NumDrops
|
Integer
|
Not Null
|
Number of drops.
See MIB object:
rttMonStatsCollectDrops
MIB type:
Integer32(0..2147483647)
Number of RTT Dropped
|
NumSeqErrors
|
Integer
|
Not Null
|
See MIB object:
rttMonStatscollectSequence
Errors
MIB type:
Integer32(0..2147483647)
Number of Sequence Errors
|
NumVerifyErrors
|
Integer
|
Not Null
|
See MIB object:
rttMonStatsCollectVerify
Errors
MIB type:
Integer32(0..2147483647)
Number of Verify Errors
|
NumTries
|
Integer
|
Not Null
|
Number of tries
|
AvgRTT
|
Numeric(30)
|
Not Null
|
Average of RTT
|
Standard
Deviation
|
Numeric(30)
|
Not Null
|
StandardDeviation
|
OverThres_
Percent
|
Numeric(30)
|
"
|
Over threshold percentage
|
Error_Percent
|
Numeric(30)
|
"
|
Error percentage
|
Availability_
Percent
|
Numeric(30)
|
"
|
Availability Percent
|
Availability Latency Daily Statistics Table
All the column values other than the Collector ID and Start Time are average values from the hourly table.
Table B-24 Availability Latency Daily Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
IDENTITY,
Primary key
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
Start Time
|
Bigint
|
Not Null
|
Start time of the day
|
MinRTT
|
Timestamp
|
Not Null
|
Average of all MinRTT.
|
MaxRTT
|
Bigint
|
IDENTITY,
Primary key
|
Average of all MaxRTT
|
SumRTT
|
Bigint
|
Not Null
|
Sum of all RTT
|
SumSqrdRTT
|
Integer
|
Not Null
|
Sum square of all RTT
|
NumCompletions
|
Integer
|
Not Null
|
Number of completions.
|
NumOverThresholds
|
Integer
|
Not Null
|
Number of over thresholds.
|
NumDisconnects
|
Integer
|
Not Null
|
Number of disconnects
|
NumTimeouts
|
Integer
|
Not Null
|
Number of Timeouts
|
NumBusies
|
Integer
|
Not Null
|
Number of busies
|
NumNoConnections
|
Integer
|
Not Null
|
Number of no connections.
|
NumDrops
|
Integer
|
Not Null
|
Number of drops.
|
NumSeqErrors
|
Integer
|
Not Null
|
Number of sequence errors
|
NumVerifyErrors
|
Integer
|
Not Null
|
Number of verify errors
|
NumTries
|
Integer
|
Not Null
|
Number of tires
|
AvgRTT
|
Numeric(30)
|
Not Null
|
Average of RTT
|
StandardDeviation
|
Numeric(30)
|
Not Null
|
StandardDeviation
|
OverThres_Percent
|
Numeric(30)
|
Not Null
|
Over threshold percentage
|
Error_Percent
|
Numeric(30)
|
Not Null
|
Error Percent
|
Availability_Percent
|
Numeric(30)
|
Not Null
|
Availability Percent
|
Availability Latency Weekly Statistics Table
All the column values other than the collector ID and Start Time are average values from Daily table.
Table B-25 Availability Latency Weekly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
IDENTITY,
Primary key
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Bigint
|
Not Null
|
Start time of the week.
|
MinRTT
|
Timestamp
|
Not Null
|
Average of all MinRTT.
|
MaxRTT
|
Bigint
|
IDENTITY,
Primary key
|
Average of all MaxRTT.
|
SumRTT
|
Bigint
|
Not Null
|
Sum of all RTT
|
SumSqrdRTT
|
Integer
|
Not Null
|
Sum square of all RTT
|
NumCompletions
|
Integer
|
Not Null
|
Number of completions.
|
NumOverThresholds
|
Integer
|
Not Null
|
Number of over thresholds.
|
NumDisconnects
|
Integer
|
Not Null
|
Number of Disconnects.
|
NumTimeouts
|
Integer
|
Not Null
|
Number of Timeouts
|
NumBusies
|
Integer
|
Not Null
|
Number of busies.
|
NumNoConnections
|
Integer
|
Not Null
|
Number of no connections.
|
NumDrops
|
Integer
|
Not Null
|
Number of drops.
|
NumSeqErrors
|
Integer
|
Not Null
|
Number of sequence errors
|
NumVerifyErrors
|
Integer
|
Not Null
|
Number of VerifyErrors
|
NumTries
|
Integer
|
Not Null
|
Number of tries
|
AvgRTT
|
Numeric(30)
|
Not Null
|
Average of RTT
|
StandardDeviation
|
Numeric(30)
|
Not Null
|
StandardDeviation
|
OverThres_Percent
|
Numeric(30)
|
Not Null
|
Over threshold percentage
|
Error_Percent
|
Numeric(30)
|
Not Null
|
Error percentage
|
Availability_Percent
|
Numeric(30)
|
Not Null
|
Availability Percent
|
Availability Latency Monthly Statistics Table
All the column values other than the collector ID and Start Time are average values from the weekly table.
Table B-26 Availability Latency Monthly Status
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
IDENTITY,
Primary key
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Bigint
|
Not Null
|
Start time of the month.
|
MinRTT
|
Timestamp
|
Not Null
|
Average of all MinRTT.
|
MaxRTT
|
Bigint
|
IDENTITY,
Primary key
|
Average of all MaxRTT.
|
SumRTT
|
Bigint
|
Not Null
|
Sum of all RTT
|
SumSqrdRTT
|
Integer
|
Not Null
|
Sum square of all RTT
|
NumCompletions
|
Integer
|
Not Null
|
Number of completions.
|
NumOverThresholds
|
Integer
|
Not Null
|
Number of over thresholds.
|
NumDisconnects
|
Integer
|
Not Null
|
Number of Disconnects.
|
NumTimeouts
|
Integer
|
Not Null
|
Number of Timeouts
|
NumBusies
|
Integer
|
Not Null
|
Number of busies.
|
NumNoConnections
|
Integer
|
Not Null
|
Number of no connections.
|
NumDrops
|
Integer
|
Not Null
|
Number of drops.
|
NumSeqErrors
|
Integer
|
Not Null
|
Number of sequence errors
|
NumVerifyErrors
|
Integer
|
Not Null
|
See MIB object:
|
NumTries
|
Integer
|
Not Null
|
Number of tries
|
AvgRTT
|
Numeric(30)
|
Not Null
|
Average of RTT
|
StandardDeviation
|
Numeric(30)
|
Not Null
|
StandardDeviation
|
OverThres_Percent
|
Numeric(30)
|
Not Null
|
Over threshold percentage
|
Error_Percent
|
Numeric(30)
|
Not Null
|
Error percentage
|
Availability_Percent
|
Numeric(30)
|
Not Null
|
Availability Percent
|
Jitter Minute Statistics Table
Table B-27 Jitter Minute Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
rowID
|
Bigint
|
Not Null
|
Unique identifier
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Timestamp
|
Not Null
|
Start time
|
MinRTT
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperRTTMin
MIB type: Gauge (32 bit)
|
MaxRTT
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperRTTMax
MIB type: Gauge (32 bit)
|
NumRTT
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperNumOfRTT
MIB type: Gauge (32 bit)
|
SumRTT
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperRTTSum
MIB type: Gauge (32 bit)
|
SumRTT2
|
Double
|
"
|
See MIB object:
rttMonLatestJitterOperRTTSum2
MIB type: Gauge (32 bit)
|
minofposisd
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperMinOf
PositivesSD
MIB type: Gauge (32 bit)
|
maxofposisd
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperMaxOf
PositivesSD
MIB type: Gauge (32 bit)
|
numofposisd
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperNumOf
PositivesSD
MIB type: Gauge (32 bit)
|
sumofposisd
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperSumOf
PositivesSD
MIB type: Gauge (32 bit)
|
sum2posisd
|
Double
|
"
|
See MIB object:
rttMonLatestJitterOperSum2
PositivesSD
MIB type: Gauge (32 bit)
|
minofnegasd
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperMinOf
NegativesSD
MIB type: Gauge (32 bit)
|
maxofnegasd
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperMaxOf
NegativesSD
MIB type: Gauge (32 bit)
|
numofnegasd
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperNumOf
NegativesSD
MIB type: Gauge (32 bit)
|
sumofnegasd
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperSumOf
NegativesSD
MIB type: Gauge (32 bit)
|
sum2negasd
|
Double
|
"
|
See MIB object:
rttMonLatestJitterOperSum2
NegativesSD
MIB type: Gauge (32 bit)
|
minofposids
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperMinOf
PositivesDS
MIB type: : Gauge (32 bit)
|
maxofposids
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperMaxOf
PositivesDS
MIB type: : Gauge (32 bit)
|
numofposids
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperNumOf
PositivesDS
MIB type: : Gauge (32 bit)
|
sumofposids
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperSumOf
PositivesDS
MIB type: : Gauge (32 bit)
|
sum2posids
|
Double
|
"
|
See MIB object:
rttMonLatestJitterOperSum2
PositivesDS
MIB type: : Gauge (32 bit)
|
minofnegads
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperMinOf
NegativesDS
MIB type: : Gauge (32 bit)
|
maxofnegads
|
Integer
|
"
|
See MIB object:
rttMonLatestJitterOperMaxOf
NegativesDS
MIB type: : Gauge (32 bit)
|
numofnegads
|
Integer
|
"
|
See MIB object: rttMonLatestJitterOperNumOf
NegativesDS
MIB type: : Gauge (32 bit)
|
sumofnegads
|
Integer
|
"
|
See MIB object: rttMonLatestJitterOperSumOf
NegativesDS
MIB type: : Gauge (32 bit)
|
sum2negads
|
Double
|
"
|
See MIB object: rttMonLatestJitterOperSum2
NegativesDS
MIB type: : Gauge (32 bit)
|
numpacketlosssd
|
Integer
|
"
|
See MIB object: rttMonLatestJitterOperPacket
LossSD
MIB type: : Gauge (32 bit)
|
numpacketlossds
|
Integer
|
"
|
See MIB object: rttMonLatestJitterOperPacket
LossDS
MIB type: : Gauge (32 bit)
|
numpacketseqerr
|
Integer
|
"
|
See MIB object: rttMonLatestJitterOperPacketOut
OfSequence
MIB type: : Gauge (32 bit)
|
numpacketmia
|
Integer
|
"
|
See MIB object: rttMonLatestJitterOperPacketMIA
MIB type: : Gauge (32 bit)
|
numpacketlate
|
Integer
|
Not Null
|
See MIB object: rttMonLatestJitterOperPacketLate
Arrival
MIB type : : Gauge (32 bit)
|
AvgRTT
|
Numeric(30)
|
Null
|
Average of RTT
|
AvgPosSD
|
Numeric(30)
|
"
|
Average of positive from Source to Destination (SD)
|
StdDevPosSD
|
Numeric(30)
|
"
|
Standard deviation of positive SD
|
AvgNegSD
|
Numeric(30)
|
"
|
Average of negative SD
|
StdDevNegSD
|
Numeric(30)
|
"
|
Standard deviation of negative SD
|
AvgPosDS
|
Numeric(30)
|
"
|
Average of positive DS
|
StdDevPosDS
|
Numeric(30)
|
"
|
Standard deviation of positive DS
|
AvgNegDS
|
Numeric(30)
|
"
|
Average of negative DS
|
StdDevNegDS
|
|
"
|
Standard deviation of negative DS
|
StdDevRTT
|
Numeric(30)
|
|
Standard deviation of RTT
|
mos
|
Integer
|
Not Null
|
See MIB object: rttMonLatestJitterOperMOS
MIB type: : Gauge (32 bit)
|
icpif
|
Integer
|
Not Null
|
See MIB object: rttMonLatestJitterOperICPIF
MIB type: : Gauge (32 bit)
|
Jitter Hourly Statistics Table
Table B-28 Jitter Hourly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
rowID
|
Bigint
|
Not Null
|
Unique identifier
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time for this hourly bucket
|
MinRTT
|
Integer
|
"
|
See MIB object: rttMonJitterStatsRTTMin
MIB type: Gauge (32 bit)
|
MaxRTT
|
Integer
|
"
|
See MIB object: rttMonJitterStatsRTTMax
MIB type: Gauge (32 bit)
|
NumRTT
|
Integer
|
"
|
See MIB object: rttMonJitterStatsNumOfRTT
MIB type: Gauge (32 bit)
|
SumRTT
|
Integer
|
"
|
See MIB object: rttMonJitterStatsRTTSum
MIB type: Gauge (32 bit)
|
SumRTT2
|
Double
|
"
|
See MIB object:
rttMonJitterStatsRTTSum2Low
and MIB object:
rttMonJitterStatsRTTSum2High
Accumulated RTT Squares
|
minofposisd
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsMinOfPositivesSD
MIB type:
Gauge32
The minimum of absolute values
of all positive jitter values from
packets sent from source to destination
|
maxofposisd
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsMaxOfPositivesSD
MIB type:
Gauge32
The maximum of absolute values
of all positive jitter values
from packets sent from source to
destination
|
numofposisd
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsNumOfPositivesSD
MIB type:
Gauge32
The sum of number of all positive
jitter values from packets
sent from source to destination
|
sumofposisd
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsSumOfPositivesSD
MIB type:
Counter32
The sum of all positive jitter values
from packets sent from
source to destination
|
sum2posisd
|
Double
|
"
|
Refer to MIB object:
rttMonJitterStatsSum2PositivesS
D2Low
and MIB object:
rttMonJitterStatsSum2PositivesS
D2High
The sum of square of RTT's of
all positive jitter values from
packets sent from source to destination
|
minofnegasd
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsMinOfNegativesSD
MIB type:
Gauge32
The minimum of absolute values
of all negative jitter values from
packets sent from source to destination
|
maxofnegasd
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsMaxOfNegativesSD
MIB type:
Gauge32
The maximum of absolute values
of all negative jitter values
from packets sent from source to
destination
|
numofnegasd
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsNumOfNegativesSD
MIB type:
Gauge32
The sum of number of all negative
jitter values from packets
sent from source to destination
|
sumofnegasd
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsSumOfNegativesSD
MIB type:
Counter32
The sum of all negative jitter
values from packets sent from
source to destination
|
sum2negasd
|
Double
|
"
|
Refer to MIB object:
rttMonJitterStatsSum2Negatives
SD2Low
and MIB object:
rttMonJitterStatsSum2Negatives
SD2High
The sum of square of RTT's of
all negative jitter values from
packets sent from source to destination
|
minofposids
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsMinOfPositivesDS
MIB type:
Gauge32
The minimum of absolute values
of all positive jitter values from
packets sent from destination to
source
|
maxofposids
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsMaxOfPositivesDS
MIB type:
Gauge32
The maximum of absolute values
of all positive jitter values
from packets sent from destination
to source
|
numofposids
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsNumOfPositivesDS
MIB type:
Gauge32
The sum of number of all positive
jitter values from packets
sent from destination to source
|
sumofposids
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsSumOfPositivesDS
MIB type:
Counter32
The sum of all positive jitter values
from packets sent from destination
to source
|
sum2posids
|
Double
|
"
|
Refer to MIB object:
rttMonJitterStatsSum2Positives
DS2Low
and MIB object:
rttMonJitterStatsSum2Positives
DS2High
The sum of square of RTT's of
all positive jitter values from
packets sent from destination to
source
|
minofnegads
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsMinOfNegativesDS
MIB type:
Gauge32
The minimum of absolute values
of all negative jitter values from
packets sent from destination to
source
|
maxofnegads
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsMaxOfNegativesDS
MIB type:
Gauge32
The maximum of absolute values
of all negative jitter values
from packets sent from destination
to source
|
numofnegads
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsNumOfNegativesDS
MIB type:
Gauge32
The sum of number of all negative
jitter values from packets
sent from destination to source
|
sumofnegads
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsSumOfNegativesDS
MIB type:
Counter32
The sum of all negative jitter
values from packets sent from
destination to source
|
sum2negads
|
Double
|
"
|
Refer to MIB object:
rttMonJitterStatsSum2Negatives
DS2Low
and MIB object:
rttMonJitterStatsSum2Negatives
DS2High
The sum of square of RTT's of
all negative jitter values from
packets sent from destination to
source
|
numcomplete
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsCompletions
MIB type:
Counter32
Number of RTTs completed
|
numoverthresh
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsOverThresholds
MIB type:
Counter32
Number of OverThresholds
|
numpacketlosssd
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsPacketLossSD
MIB type:
Counter32
The number of packets lost when
sent from source to destination
|
numpacketlossds
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsPacketLossDS
MIB type:
Counter32
The number of packets lost when
sent from destination to source
|
numpacketseqerr
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsPacketOutOf-
Sequence
MIB type:
Counter32
The number of packets arrived
out of sequence
|
numpacketmia
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsPacketMIA
MIB type:
Counter32
The number of packets that are
lost for which we cannot determine
the direction
|
numpacketlate
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsPacketLateArrival
MIB type:
Counter32
The number of packets that
arrived after the timeout
|
NumJitterStatsErrors
|
Integer
|
"
|
Refer mib object : rttMonJitterStatsError
Mib type : Counter (32 bit)
|
numerror
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsError
MIB type:
Counter32
The number of occasions when a
jitter operation could not be initiated
because an internal error
|
numbusy
|
Integer
|
"
|
Refer to MIB object:
rttMonJitterStatsBusies
MIB type:
Counter32
The number of occasions when a
jitter operation could not be initiated
because a previous jitter
operation has not been completed
|
AvgRtt
|
Numeric(30)
|
"
|
Average of RTT
|
Error_Percent
|
Numeric(30)
|
"
|
Error percent
|
NumTries
|
Integer
|
"
|
Number of tries
|
AvgPosSD
|
Numeric(30)
|
"
|
Average of positive SD
|
StdDevPosSD
|
Numeric(30)
|
"
|
Standard deviation of positive SD
|
AvgNegSD
|
Numeric(30)
|
"
|
Average of negative SD
|
StdDevNegSD
|
Numeric(30)
|
"
|
Standard deviation negative SD
|
AvgPosDS
|
Numeric(30)
|
"
|
Average of positive DS
|
StdDevPosDS
|
Numeric(30)
|
"
|
Standard deviation of positive DS
|
AvgNegDS
|
Numeric(30)
|
"
|
Average of negative DS
|
StdDevNegDS
|
Numeric(30)
|
Not Null
|
Standard deviation of negative DS
|
PacketErrorPercent
|
Numeric(30)
|
Null
|
Packet Error Percent
|
OverThresholdPercent
|
Numeric(30)
|
Null
|
Over Threshold Percent
|
StdDevRTT
|
Numeric(30)
|
Null
|
Standard deviation RTT
|
TotalPackets
|
Integer
|
Null
|
Total Packets
|
minmos
|
Integer
|
Not Null
|
Min of MOS
|
maxmos
|
Integer
|
"
|
Max of MOS
|
minicpif
|
Integer
|
"
|
Min of icpif
|
maxicpif
|
Integer
|
"
|
Max of icpif
|
Jitter Daily Statistics Table
All the column values other than the Collector ID and Start Time are average values from the hourly table.
Table B-29 Jitter Daily Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the day
|
MinRTT
|
Integer
|
"
|
Average of all Min RTT
|
MaxRTT
|
Integer
|
"
|
Average of all Max RTT
|
NumRTT
|
Integer
|
"
|
Number of RTT's that are successfully
measured
|
SumRTT
|
Integer
|
"
|
Accumulated RTTs
|
SumRTT2
|
Double
|
"
|
Accumulated RTT Squares
|
minofposisd
|
Integer
|
"
|
Minimum of positive SD
|
maxofposisd
|
Integer
|
"
|
Maximum of positive SD
|
numofposisd
|
Integer
|
"
|
Number of positve SD
|
sumofposisd
|
Integer
|
"
|
Sum of positive SD
|
sum2posisd
|
Double
|
"
|
Sum squared of positive SD
|
minofnegasd
|
Integer
|
"
|
Minimum of negative SD
|
maxofnegasd
|
Integer
|
"
|
Maximum of negative SD
|
numofnegasd
|
Integer
|
"
|
Number of negative SD
|
sumofnegasd
|
Integer
|
"
|
Sum of negative SD
|
sum2negasd
|
Double
|
"
|
Sum squared of negative SD
|
minofposids
|
Integer
|
"
|
Minimum of positive DS
|
maxofposids
|
Integer
|
"
|
Maximum of positive DS
|
numofposids
|
Integer
|
"
|
Number of positive DS
|
sumofposids
|
Integer
|
"
|
Sum of positive DS
|
sum2posids
|
Double
|
"
|
Sum squared of positive DS
|
minofnegads
|
Integer
|
"
|
Minimum of nagative DS
|
maxofnegads
|
Integer
|
"
|
Maximum of negative DS
|
numofnegads
|
Integer
|
"
|
Number of negative DS
|
sumofnegads
|
Integer
|
"
|
Sum of negative DS
|
sum2negads
|
Double
|
"
|
Sum squared of negative DS
|
numcomplete
|
Integer
|
"
|
Number of completions
|
numoverthresh
|
Integer
|
"
|
Number of overthreshold
|
numpacketlosssd
|
Integer
|
"
|
Number of packet loss SD
|
numpacketlossds
|
Integer
|
"
|
Number of packet loss DS
|
numpacketseqerr
|
Integer
|
"
|
Number of error packets
|
numpacketmia
|
Integer
|
"
|
Number of packet MIA
|
numpacketlate
|
Integer
|
"
|
Number of late packets
|
NumJitterStatsErrors
|
Integer
|
"
|
Number of JitterStatsErrors
|
numerror
|
Integer
|
"
|
Numerror
|
numbusy
|
Integer
|
"
|
Numbusy
|
AvgRtt
|
Numeric(30)
|
"
|
Average RTT
|
Error_Percent
|
Numeric(30)
|
"
|
Error percentage
|
NumTries
|
Integer
|
"
|
Number of tries
|
AvgPosSD
|
Numeric(30)
|
"
|
Average of positive SD
|
StdDevPosSD
|
Numeric(30)
|
"
|
Standared deviation of positive SD
|
AvgNegSD
|
Numeric(30)
|
"
|
Average of negative SD
|
StdDevNegSD
|
Numeric(30)
|
"
|
Standared deviation of negative SD
|
AvgPosDS
|
Numeric(30)
|
"
|
Average of positive DS
|
StdDevPosDS
|
Numeric(30)
|
"
|
Standared deviation of positive DS
|
AvgNegDS
|
Numeric(30)
|
"
|
Average of negative DS
|
StdDevNegDS
|
Numeric(30)
|
Not Null
|
Standared deviation of negative DS
|
PacketErrorPercent
|
Numeric(30)
|
Null
|
PacketErrorPercent
|
OverThresholdPercent
|
Numeric(30)
|
Null
|
OverThresholdPercent
|
StdDevRTT
|
Numeric(30)
|
Null
|
Standared deviation of RTT
|
TotalPackets
|
Integer
|
Null
|
TotalPackets
|
minmos
|
Integer
|
Not Null
|
Min MOS
|
maxmos
|
Integer
|
"
|
Max MOS
|
minicpif
|
Integer
|
"
|
Min ICPIF
|
maxicpif
|
Integer
|
"
|
Max ICPIF
|
Jitter Weekly Statistics Table
All the column values other than the collector ID and Start Time are average values from Daily table.
Table B-30 Jitter Weekly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the week
|
MinRTT
|
Integer
|
"
|
Average of all Min RTT
|
MaxRTT
|
Integer
|
"
|
Average of all Max RTT
|
NumRTT
|
Integer
|
"
|
Number of RTT's that are successfully
measured
|
SumRTT
|
Integer
|
"
|
Accumulated RTTs
|
SumRTT2
|
Double
|
"
|
Accumulated RTT Squares
|
minofposisd
|
Integer
|
"
|
Minimum of positive SD
|
maxofposisd
|
Integer
|
"
|
Maximum of positive SD
|
numofposisd
|
Integer
|
"
|
Number of positve SD
|
sumofposisd
|
Integer
|
"
|
Sum of positive SD
|
sum2posisd
|
Double
|
"
|
Sum squared of positive SD
|
minofnegasd
|
Integer
|
"
|
Minimum of negative SD
|
maxofnegasd
|
Integer
|
"
|
Maximum of negative SD
|
numofnegasd
|
Integer
|
"
|
Number of negative SD
|
sumofnegasd
|
Integer
|
"
|
Sum of negative SD
|
sum2negasd
|
Double
|
"
|
Sum squared of negative SD
|
minofposids
|
Integer
|
"
|
Minimum of positive DS
|
maxofposids
|
Integer
|
"
|
Maximum of positive DS
|
numofposids
|
Integer
|
"
|
Number of positive DS
|
sumofposids
|
Integer
|
"
|
Sum of positive DS
|
sum2posids
|
Double
|
"
|
Sum squared of positive DS
|
minofnegads
|
Integer
|
"
|
Minimum of nagative DS
|
maxofnegads
|
Integer
|
"
|
Maximum of negative DS
|
numofnegads
|
Integer
|
"
|
Number of negative DS
|
sumofnegads
|
Integer
|
"
|
Sum of negative DS
|
sum2negads
|
Double
|
"
|
Sum squared of negative DS
|
numcomplete
|
Integer
|
"
|
Number of completions
|
numoverthresh
|
Integer
|
"
|
Number of overthreshold
|
numpacketlosssd
|
Integer
|
"
|
Number of packet loss SD
|
numpacketlossds
|
Integer
|
"
|
Number of packet loss DS
|
numpacketseqerr
|
Integer
|
"
|
Number of error packets
|
numpacketmia
|
Integer
|
"
|
Number of packet MIA
|
numpacketlate
|
Integer
|
"
|
Number of late packets
|
NumJitterStatsErrors
|
Integer
|
"
|
Number of JitterStatsErrors
|
numerror
|
Integer
|
"
|
Numerror
|
numbusy
|
Integer
|
"
|
Numbusy
|
AvgRtt
|
Numeric(30)
|
"
|
Average RTT
|
Error_Percent
|
Numeric(30)
|
"
|
Error percentage
|
NumTries
|
Integer
|
"
|
Number of tries
|
AvgPosSD
|
Numeric(30)
|
"
|
Average of positive SD
|
StdDevPosSD
|
Numeric(30)
|
"
|
Standared deviation of positive SD
|
AvgNegSD
|
Numeric(30)
|
"
|
Average of negative SD
|
StdDevNegSD
|
Numeric(30)
|
"
|
Standared deviation of negative SD
|
AvgPosDS
|
Numeric(30)
|
"
|
Average of positive DS
|
StdDevPosDS
|
Numeric(30)
|
"
|
Standared deviation of positive DS
|
AvgNegDS
|
Numeric(30)
|
"
|
Average of negative DS
|
StdDevNegDS
|
Numeric(30)
|
Not Null
|
Standared deviation of negative DS
|
PacketErrorPercent
|
Numeric(30)
|
Null
|
PacketErrorPercent
|
OverThresholdPercent
|
Numeric(30)
|
Null
|
OverThresholdPercent
|
StdDevRTT
|
Numeric(30)
|
Null
|
Standared deviation of RTT
|
TotalPackets
|
Integer
|
Null
|
TotalPackets
|
minmos
|
Integer
|
Not Null
|
Min MOS
|
maxmos
|
Integer
|
"
|
Max MOS
|
minicpif
|
Integer
|
"
|
Min ICPIF
|
maxicpif
|
Integer
|
"
|
Max ICPIF
|
Jitter Monthly Statistics Table
All the column values other than the collector ID and Start Time are average values from the weekly table.
Table B-31 Jitter Monthly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the monthly
|
MinRTT
|
Integer
|
"
|
Average of all Min RTT
|
MaxRTT
|
Integer
|
"
|
Average of all Max RTT
|
NumRTT
|
Integer
|
"
|
Number of RTT's that are successfully
measured
|
SumRTT
|
Integer
|
"
|
Accumulated RTTs
|
SumRTT2
|
Double
|
"
|
Accumulated RTT Squares
|
minofposisd
|
Integer
|
"
|
Minimum of positive SD
|
maxofposisd
|
Integer
|
"
|
Maximum of positive SD
|
numofposisd
|
Integer
|
"
|
Number of positve SD
|
sumofposisd
|
Integer
|
"
|
Sum of positive SD
|
sum2posisd
|
Double
|
"
|
Sum squared of positive SD
|
minofnegasd
|
Integer
|
"
|
Minimum of negative SD
|
maxofnegasd
|
Integer
|
"
|
Maximum of negative SD
|
numofnegasd
|
Integer
|
"
|
Number of negative SD
|
sumofnegasd
|
Integer
|
"
|
Sum of negative SD
|
sum2negasd
|
Double
|
"
|
Sum squared of negative SD
|
minofposids
|
Integer
|
"
|
Minimum of positive DS
|
maxofposids
|
Integer
|
"
|
Maximum of positive DS
|
numofposids
|
Integer
|
"
|
Number of positive DS
|
sumofposids
|
Integer
|
"
|
Sum of positive DS
|
sum2posids
|
Double
|
"
|
Sum squared of positive DS
|
minofnegads
|
Integer
|
"
|
Minimum of nagative DS
|
maxofnegads
|
Integer
|
"
|
Maximum of negative DS
|
numofnegads
|
Integer
|
"
|
Number of negative DS
|
sumofnegads
|
Integer
|
"
|
Sum of negative DS
|
sum2negads
|
Double
|
"
|
Sum squared of negative DS
|
numcomplete
|
Integer
|
"
|
Number of completions
|
numoverthresh
|
Integer
|
"
|
Number of overthreshold
|
numpacketlosssd
|
Integer
|
"
|
Number of packet loss SD
|
numpacketlossds
|
Integer
|
"
|
Number of packet loss DS
|
numpacketseqerr
|
Integer
|
"
|
Number of error packets
|
numpacketmia
|
Integer
|
"
|
Number of packet MIA
|
numpacketlate
|
Integer
|
"
|
Number of late packets
|
NumJitterStatsErrors
|
Integer
|
"
|
Number of JitterStatsErrors
|
numerror
|
Integer
|
"
|
Numerror
|
numbusy
|
Integer
|
"
|
Numbusy
|
AvgRtt
|
Numeric(30)
|
"
|
Average RTT
|
Error_Percent
|
Numeric(30)
|
"
|
Error percentage
|
NumTries
|
Integer
|
"
|
Number of tries
|
AvgPosSD
|
Numeric(30)
|
"
|
Average of positive SD
|
StdDevPosSD
|
Numeric(30)
|
"
|
Standared deviation of positive SD
|
AvgNegSD
|
Numeric(30)
|
"
|
Average of negative SD
|
StdDevNegSD
|
Numeric(30)
|
"
|
Standared deviation of negative SD
|
AvgPosDS
|
Numeric(30)
|
"
|
Average of positive DS
|
StdDevPosDS
|
Numeric(30)
|
"
|
Standared deviation of positive DS
|
AvgNegDS
|
Numeric(30)
|
"
|
Average of negative DS
|
StdDevNegDS
|
Numeric(30)
|
Not Null
|
Standared deviation of negative DS
|
PacketErrorPercent
|
Numeric(30)
|
Null
|
PacketErrorPercent
|
OverThresholdPercent
|
Numeric(30)
|
Null
|
OverThresholdPercent
|
StdDevRTT
|
Numeric(30)
|
Null
|
Standared deviation of RTT
|
TotalPackets
|
Integer
|
Null
|
TotalPackets
|
minmos
|
Integer
|
Not Null
|
Min MOS
|
maxmos
|
Integer
|
"
|
Max MOS
|
minicpif
|
Integer
|
"
|
Min ICPIF
|
maxicpif
|
Integer
|
"
|
Max ICPIF
|
ICMP Jitter Minute Statistics Table
Table B-32 ICMP Jitter Minute Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
rowID
|
Bigint
|
IDENTITY,
primary key
|
Unique identifier
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Integer
|
"
|
Starttime
|
MinRTT
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterRTTMin
MIB type: Gauge (32 bit)
|
MaxRTT
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterRTTMax
MIB type: Gauge (32 bit)
|
NumRTT
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterNumRTT
MIB type: Gauge (32 bit)
|
SumRTT
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterRTTSum
MIB type: Gauge (32 bit)
|
SumRTT2
|
Double
|
"
|
See MIB object:
rttMonLatestIcmpJitterRTTSum2
MIB type: Gauge (32 bit)
|
minofposisd
|
Integer
|
"
|
See MIB object:
rttMonLatestIcmpJitterMinPosSD
MIB type: Gauge (32 bit)
|
maxofposisd
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterMaxPosSD
MIB type: Gauge (32 bit)
|
numofposisd
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterNumPosSD
MIB type: Gauge (32 bit)
|
sumofposisd
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterSumPosSD
MIB type: Gauge (32 bit)
|
sum2posisd
|
Double
|
"
|
See MIB object:
rttMonLatestIcmpJitterSum2PosSD
MIB type: Gauge (32 bit)
|
minofnegasd
|
Integer
|
"
|
See MIB object:
rttMonLatestIcmpJitterMinNegSD
MIB type: Gauge (32 bit)
|
maxofnegasd
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterMaxNegSD
MIB type: Gauge (32 bit)
|
numofnegasd
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterNumNegSD
MIB type: Gauge (32 bit)
|
sumofnegasd
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterSumNegSD
MIB type: Gauge (32 bit)
|
sum2negasd
|
Double
|
"
|
See MIB object:
rttMonLatestIcmpJitterSum2NegSD
MIB type: Gauge (32 bit)
|
minofposids
|
Integer
|
"
|
See MIB object:
rttMonLatestIcmpJitterMinPosDS
MIB type: Gauge (32 bit)
|
maxofposids
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterMaxPosDS
MIB type: Gauge (32 bit)
|
numofposids
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterNumPosDS
MIB type: Gauge (32 bit)
|
sumofposids
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterSumPosDS
MIB type: Gauge (32 bit)
|
sum2posids
|
Double
|
"
|
See MIB object:
rttMonLatestIcmpJitterSum2PosDS
MIB type: Gauge (32 bit)
|
minofnegads
|
Integer
|
"
|
See MIB object:
rttMonLatestIcmpJitterMinNegDS
MIB type: Gauge (32 bit)
|
maxofnegads
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterMaxNegDS
MIB type: Gauge (32 bit)
|
numofnegads
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterNumNegDS
MIB type: Gauge (32 bit)
|
sumofnegads
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterSumNegDS
MIB type: Gauge (32 bit)
|
sum2negads
|
Double
|
"
|
See MIB object:
rttMonLatestIcmpJitterSum2NegDS
MIB type: Gauge (32 bit)
|
numPktLoss
|
Integer
|
"
|
See MIB object:
rttMonLatestIcmpJitterPktLoss
MIB type: Counter (32 bit)
|
numPktOutSeqBoth
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJPktOutSeqBoth
MIB type: Counter (32 bit)
|
numPktOutSeqSDes
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJPktOutSeqSD
MIB type: Counter (32 bit)
|
numPktOutSeqDSes
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJPktOutSeqDS
MIB type: Counter (32 bit)
|
numPktSkippeds
|
"
|
"
|
unused
|
numPktLateAs
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterPktLateA
MIB type: Counter (32 bit)
|
minSuccPktLoss
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterMinSucPktL
MIB type: Gauge (32 bit)
|
maxSuccPktLoss
|
"
|
"
|
See MIB object:
rttMonLatestIcmpJitterMaxSucPktL
MIB type: Gauge (32 bit)
|
AvgRTT
|
Numeric(30,6)
|
Null
|
Average of RTT
|
AvgPosSD
|
"
|
"
|
Average of positive SD
|
StdDevPosSD
|
"
|
"
|
Standard deviation of positive SD
|
AvgNegSD
|
"
|
"
|
Average of negative SD
|
StdDevNegSD
|
"
|
"
|
Standard deviation of negative SD
|
AvgPosDS
|
"
|
"
|
Average of positive DS
|
StdDevPosDS
|
"
|
"
|
Standard deviation of positive DS
|
AvgNegDS
|
"
|
"
|
Average of negative DS
|
StdDevNegDS
|
"
|
"
|
Standard deviation of negative DS
|
StdDevRTT
|
"
|
"
|
Standard deviation of RTT
|
ICMP Jitter Hourly Statistics Table
Table B-33 ICMP Jitter Hourly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
rowID
|
Bigint
|
IDENTITY,
primary key
|
Unique identifier
|
CollectorID
|
"
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID).
|
starttime
|
Timestamp
|
"
|
Start time of the hourly bucket
|
MinRTT
|
Integer
|
"
|
See MIB object:
rttMonIcmpJitterStatsRTTMin
MIB type: Gauge (32 bit)
|
MaxRTT
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsRTTMax
MIB type: Gauge (32 bit)
|
NumRTT
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsNumRTTs
MIB type: Gauge (32 bit)
|
SumRTT
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsRTTSums
MIB type: Gauge (32 bit)
|
SumRTT2
|
Double
|
"
|
See MIB object:
rttMonIcmpJStatsRTTSum2Lows,rttMonIcmpJStatsRTTSum2Highs.
The high and low order 32 bits of the accumulated squares of completion times (in milliseconds) of RTT operations that complete successfully.
|
minofposisd
|
Integer
|
|
See MIB object: rttMonIcmpJitterStatsMinPosSD
MIB type: Gauge (32 bit)
|
maxofposisd
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsMaxPosSD
MIB type: Gauge (32 bit)
|
numofposisd
|
"
|
"
|
See MIB object:
rttMonIcmpJitter
StatsNumPosSDs
MIB type: Gauge (32 bit)
|
sumofposisd
|
"
|
"
|
See MIB object:
rttMonIcmpJitter
StatsSumPosSDs
MIB type: Gauge (32 bit)
|
sum2posisd
|
Double
|
|
See MIB object:
Sum2PosSDLows,rttMonIcmpJStatsSum2PosSDHighs.
The sum of the square of RTTs of all positive jitter values from packets sent from source to destination
(Low and higher order 32 bits).
|
minofnegasd
|
Integer
|
|
See MIB object:
rttMonIcmpJitterStatsMinNegSD
MIB type: Gauge (32 bit)
|
maxofnegasd
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsMaxNegSD
MIB type: Gauge (32 bit)
|
numofnegasd
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsNumNegSDs
MIB type: Gauge (32 bit)
|
sumofnegasd
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsSumNegSDs
MIB type: Gauge (32 bit)
|
sum2negasd
|
Double
|
"
|
See MIB object:
rttMonIcmpJStatsSum2NegSDLows,rttMonIcmpJStatsSum2NegSDHighs.
The sum of the square of RTTs of all negative jitter values from packets sent from source to destination.
(Low and higher order 32 bits
|
minofposids
|
Integer
|
"
|
See MIB object:
rttMonIcmpJitterStatsMinPosDS
MIB type: Gauge (32 bit)
|
maxofposids
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsMaxPosDS
MIB type: Gauge (32 bit)
|
numofposids
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsNumPosDSes
MIB type: Gauge (32 bit)
|
sumofposids
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsSumPosDSes
MIB type: Gauge (32 bit)
|
sum2posids
|
Double
|
"
|
See MIB object:
|
minofnegads
|
Integer
|
"
|
See MIB object:
rttMonIcmpJitterStatsMinNegDS
MIB type: Gauge (32 bit)
|
maxofnegads
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsMaxNegDS
MIB type: Gauge (32 bit)
|
numofnegads
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsNumNegDSes
MIB type: Gauge (32 bit)
|
sumofnegads
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsSumNegDSes
MIB type: Gauge (32 bit)
|
sum2negads
|
Double
|
"
|
|
numcomplete
|
Integer
|
"
|
See MIB object:
rttMonIcmpJitterStatsCompletions
MIB type: Counter (32 bit)
|
numoverthresh
|
"
|
"
|
See MIB object:
rttMonIcmpJStatsOverThresholds
MIB type: Counter (32 bit)
|
numPktLoss
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsPktLosses
MIB type: Counter (32 bit)
|
numPktOutSeqBoth
|
"
|
"
|
See MIB object:
rttMonIcmpJStatsPktOutSeqBoth
MIB type: Counter (32 bit)
|
numPktOutSeqSDes
|
"
|
"
|
See MIB object:
rttMonIcmpJStatsPktOutSeqSDs
MIB type: Counter (32 bit)
|
numPktOutSeqDSes
|
"
|
"
|
See MIB object:
rttMonIcmpJStatsPktOutSeqDSes
MIB type: Counter (32 bit)
|
numPktSkippeds
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsPktSkippeds
MIB type: Counter (32 bit)
|
numPktLateAs
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsPktLateAs
MIB type: Counter (32 bit)
|
minSuccPktLoss
|
"
|
"
|
See MIB object:
rttMonIcmpJitterMinSucPktLoss
MIB type:gauge(32)
|
maxSuccPktLoss
|
"
|
"
|
See MIB object:
rttMonIcmpJitterMaxSucPktLoss
MIB type:gauge(32)
|
numerror
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsErrors
MIB type: Counter (32 bit)
|
numbusy
|
"
|
"
|
See MIB object:
rttMonIcmpJitterStatsBusies
MIB type: Counter (32 bit)
|
AvgRtt
|
Numeric(30)
|
"
|
Average RTT
|
Error_Percent
|
"
|
"
|
Error percentage
|
NumTries
|
Integer
|
"
|
Number of tries
|
AvgPosSD
|
Numeric(30)
|
"
|
Average positive SD
|
StdDevPosSD
|
"
|
"
|
Standard deviation positive SD
|
AvgNegSD
|
"
|
"
|
Average negative SD
|
StdDevNegSD
|
"
|
"
|
Standard deviation negative SD
|
AvgPosDS
|
"
|
"
|
Average of positive SD
|
StdDevPosDS
|
"
|
"
|
Standard deviation positive DS
|
AvgNegDS
|
"
|
"
|
Average negative DS
|
StdDevNegDS
|
"
|
"
|
Standard deviation negative DS
|
PacketErrorPercent
|
"
|
Null
|
Packet error percentage
|
OverThresholdPercent
|
"
|
"
|
Over threshold percentage
|
StdDevRTT
|
"
|
"
|
Standard deviation RTT
|
TotalPackets
|
Integer
|
"
|
Total packets
|
ICMP Jitter Daily Statistics Table
All the column values other than the Collector ID and Start Time are average values from the hourly table.
Table B-34 ICMP Jitter Daily Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the day
|
MinRTT
|
Integer
|
"
|
Average of all MinRTT
|
MaxRTT
|
"
|
"
|
Average of all MaxRTT.
|
NumRTT
|
"
|
"
|
Number of total RTT
|
SumRTT
|
"
|
"
|
Sum of all RTT
|
SumRTT2
|
Double
|
"
|
Sum of all RTT squars
|
minofposisd
|
Integer
|
|
Minimum of all positive SD
|
maxofposisd
|
"
|
"
|
Maximum of all positive SD
|
numofposisd
|
"
|
"
|
Number of all positive SD
|
sumofposisd
|
"
|
"
|
Sum of all positive SD
|
sum2posisd
|
Double
|
|
Sum square of all positive SD square
|
minofnegasd
|
Integer
|
|
Minimum of all negative SD
|
maxofnegasd
|
"
|
"
|
Maximum of all negative SD
|
numofnegasd
|
"
|
"
|
Number of all negative SD
|
sumofnegasd
|
"
|
"
|
Sum of all negative SD
|
sum2negasd
|
Double
|
"
|
Sum square of all negative SD
|
minofposids
|
Integer
|
"
|
Minimum of all positive DS
|
maxofposids
|
"
|
"
|
Maximum of all positive DS
|
numofposids
|
"
|
"
|
Number of all positive DS
|
sumofposids
|
"
|
"
|
Sum of all positive DS
|
sum2posids
|
Double
|
"
|
Sum square of all positive DS
|
minofnegads
|
Integer
|
"
|
Minimum of all negative DS
|
maxofnegads
|
"
|
"
|
Maximum of all negative DS
|
numofnegads
|
"
|
"
|
Number of all negative DS
|
sumofnegads
|
"
|
"
|
Sum of all negative DS
|
sum2negads
|
Double
|
"
|
Sum square of all negative DS
|
numcomplete
|
Integer
|
"
|
Number of total RTT completions
|
numoverthresh
|
"
|
"
|
Number of overthreshold
|
numPktLoss
|
"
|
"
|
Number of packet loss
|
numPktOutSeqBoth
|
"
|
"
|
Number of packet out sequence for both DS, SD
|
numPktOutSeqSDes
|
"
|
"
|
Number of packet out sequence for SD
|
numPktOutSeqDSes
|
"
|
"
|
Number of packet out sequence for DS
|
numPktSkippeds
|
"
|
"
|
Number of packets skipped
|
numPktLateAs
|
"
|
"
|
Number of late pakets
|
minSuccPktLoss
|
"
|
"
|
Minimum of successful packet loss
|
maxSuccPktLoss
|
"
|
"
|
Maximum of successful packet loss
|
numerror
|
"
|
"
|
Number of errors
|
numbusy
|
"
|
"
|
Number of busies
|
AvgRtt
|
Numeric(30)
|
"
|
Average of all RTT
|
Error_Percent
|
"
|
"
|
Error percentage
|
NumTries
|
Integer
|
"
|
Number of all tries
|
AvgPosSD
|
Numeric(30)
|
"
|
Average of positive SD
|
StdDevPosSD
|
"
|
"
|
Standard deviation of positive SD
|
AvgNegSD
|
"
|
"
|
Average negative SD
|
StdDevNegSD
|
"
|
"
|
Standard deviation negative SD
|
AvgPosDS
|
"
|
"
|
Average of positive DS
|
StdDevPosDS
|
"
|
"
|
Standard deviation positive DS
|
AvgNegDS
|
"
|
"
|
Average negative DS
|
StdDevNegDS
|
"
|
"
|
Standard deviation negative DS
|
PacketErrorPercent
|
"
|
Null
|
Packet error percentage
|
OverThreshold
Percent
|
"
|
"
|
Over threshold percentage
|
StdDevRTT
|
"
|
"
|
Standard deviation RTT
|
TotalPackets
|
Integer
|
"
|
Total packets
|
ICMP Jitter Weekly Status
All the column values other than the collector ID and Start Time are average values from Daily table.
Table B-35 ICMP Jitter Weekly Statistics
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
BIGINT
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the weekly
|
MinRTT
|
Integer
|
"
|
Average of all MinRTT
|
MaxRTT
|
"
|
"
|
Average of all MaxRTT.
|
NumRTT
|
"
|
"
|
Number of total RTT
|
SumRTT
|
"
|
"
|
Sum of all RTT
|
SumRTT2
|
Double
|
"
|
Sum of all RTT squars
|
minofposisd
|
Integer
|
|
Minimum of all positive SD
|
maxofposisd
|
"
|
"
|
Maximum of all positive SD
|
numofposisd
|
"
|
"
|
Number of all positive SD
|
sumofposisd
|
"
|
"
|
Sum of all positive SD
|
sum2posisd
|
Double
|
|
Sum square of all positive SD square
|
minofnegasd
|
Integer
|
|
Minimum of all negative SD
|
maxofnegasd
|
"
|
"
|
Maximum of all negative SD
|
numofnegasd
|
"
|
"
|
Number of all negative SD
|
sumofnegasd
|
"
|
"
|
Sum of all negative SD
|
sum2negasd
|
Double
|
"
|
Sum square of all negative SD
|
minofposids
|
Integer
|
"
|
Minimum of all positive DS
|
maxofposids
|
"
|
"
|
Maximum of all positive DS
|
numofposids
|
"
|
"
|
Number of all positive DS
|
sumofposids
|
"
|
"
|
Sum of all positive DS
|
sum2posids
|
Double
|
"
|
Sum square of all positive DS
|
minofnegads
|
Integer
|
"
|
Minimum of all negative DS
|
maxofnegads
|
"
|
"
|
Maximum of all negative DS
|
numofnegads
|
"
|
"
|
Number of all negative DS
|
sumofnegads
|
"
|
"
|
Sum of all negative DS
|
sum2negads
|
Double
|
"
|
Sum square of all negative DS
|
numcomplete
|
Integer
|
"
|
Number of total RTT completions
|
numoverthresh
|
"
|
"
|
Number of overthreshold
|
numPktLoss
|
"
|
"
|
Number of packet loss
|
numPktOutSeqBoth
|
"
|
"
|
Number of packet out sequence for both DS, SD
|
numPktOutSeqSDes
|
"
|
"
|
Number of packet out sequence for SD
|
numPktOutSeqDSes
|
"
|
"
|
Number of packet out sequence for DS
|
numPktSkippeds
|
"
|
"
|
Number of packets skipped
|
numPktLateAs
|
"
|
"
|
Number of late pakets
|
minSuccPktLoss
|
"
|
"
|
Minimum of successful packet loss
|
maxSuccPktLoss
|
"
|
"
|
Maximum of successful packet loss
|
numerror
|
"
|
"
|
Number of errors
|
numbusy
|
"
|
"
|
Number of busies
|
AvgRtt
|
Numeric(30)
|
"
|
Average of all RTT
|
Error_Percent
|
"
|
"
|
Error percentage
|
NumTries
|
Integer
|
"
|
Number of all tries
|
AvgPosSD
|
Numeric(30)
|
"
|
Average of positive SD
|
StdDevPosSD
|
"
|
"
|
Standard deviation of positive SD
|
AvgNegSD
|
"
|
"
|
Average negative SD
|
StdDevNegSD
|
"
|
"
|
Standard deviation negative SD
|
AvgPosDS
|
"
|
"
|
Average of positive DS
|
StdDevPosDS
|
"
|
"
|
Standard deviation of positive DS
|
AvgNegDS
|
"
|
"
|
Average negative DS
|
StdDevNegDS
|
"
|
"
|
Standard deviation negative DS
|
PacketErrorPercent
|
"
|
Null
|
PacketErrorPercent
|
OverThresholdPercent
|
"
|
"
|
OverThresholdPercent
|
StdDevRTT
|
"
|
"
|
StdDevRTT
|
TotalPackets
|
Integer
|
"
|
TotalPackets
|
ICMP Jitter Monthly Statistics Table
All the column values other than the collector ID and Start Time are average values from the weekly table.
Table B-36 ICMP Jitter Monthly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
BIGINT
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the month
|
MinRTT
|
Integer
|
"
|
Average of all MinRTT
|
MaxRTT
|
"
|
"
|
Average of all MaxRTT.
|
NumRTT
|
"
|
"
|
Number of total RTT
|
SumRTT
|
"
|
"
|
Sum of all RTT
|
SumRTT2
|
Double
|
"
|
Sum of all RTT squars
|
minofposisd
|
Integer
|
|
Minimum of all positive SD
|
maxofposisd
|
"
|
"
|
Maximum of all positive SD
|
numofposisd
|
"
|
"
|
Number of all positive SD
|
sumofposisd
|
"
|
"
|
Sum of all positive SD
|
sum2posisd
|
Double
|
|
Sum square of all positive SD
|
minofnegasd
|
Integer
|
|
Minimum of all negative SD
|
maxofnegasd
|
"
|
"
|
Maximum of all negative SD
|
numofnegasd
|
"
|
"
|
Number of all negative SD
|
sumofnegasd
|
"
|
"
|
Sum of all negative SD
|
sum2negasd
|
Double
|
"
|
Sum square of all negative SD
|
minofposids
|
Integer
|
"
|
Minimum of all positive DS
|
maxofposids
|
"
|
"
|
Maximum of all positive DS
|
numofposids
|
"
|
"
|
Number of all positive DS
|
sumofposids
|
"
|
"
|
Sum of all positive DS
|
sum2posids
|
Double
|
"
|
Sum square of all positive DS
|
minofnegads
|
Integer
|
"
|
Minimum of all negative DS
|
maxofnegads
|
"
|
"
|
Maximum of all negative DS
|
numofnegads
|
"
|
"
|
Number of all negative DS
|
sumofnegads
|
"
|
"
|
Sum of all negative DS
|
sum2negads
|
Double
|
"
|
Sum square of all negative DS
|
numcomplete
|
Integer
|
"
|
Number of total RTT completions
|
numoverthresh
|
"
|
"
|
Number of overthreshold
|
numPktLoss
|
"
|
"
|
Number of packet loss
|
numPktOutSeqBoth
|
"
|
"
|
Number of packet out sequence for both DS, SD
|
numPktOutSeqSDes
|
"
|
"
|
Number of packet out sequence for SD
|
numPktOutSeqDSes
|
"
|
"
|
Number of packet out sequence for DS
|
numPktSkippeds
|
"
|
"
|
Number of packets skipped
|
numPktLateAs
|
"
|
"
|
Number of late pakets
|
minSuccPktLoss
|
"
|
"
|
Minimum of successful packet loss
|
maxSuccPktLoss
|
"
|
"
|
Maximum of successful packet loss
|
numerror
|
"
|
"
|
Number of errors
|
numbusy
|
"
|
"
|
Number of busies
|
AvgRtt
|
Numeric(30)
|
"
|
Average of all RTT
|
Error_Percent
|
"
|
"
|
Error percentage
|
NumTries
|
Integer
|
"
|
Number of all tries
|
AvgPosSD
|
Numeric(30)
|
"
|
Average of positive SD
|
StdDevPosSD
|
"
|
"
|
Standard deviation of positive SD
|
AvgNegSD
|
"
|
"
|
Average negative SD
|
StdDevNegSD
|
"
|
"
|
Standard deviation negative SD
|
AvgPosDS
|
"
|
"
|
Average of positive DS
|
StdDevPosDS
|
"
|
"
|
Standard deviation of positive DS
|
AvgNegDS
|
"
|
"
|
Average negative DS
|
StdDevNegDS
|
"
|
"
|
Standard deviation negative DS
|
PacketErrorPercent
|
"
|
Null
|
PacketErrorPercent
|
OverThresholdPercent
|
"
|
"
|
OverThresholdPercent
|
StdDevRTT
|
"
|
"
|
StdDevRTT
|
TotalPackets
|
Integer
|
"
|
TotalPackets
|
Ethernet Jitter Minute Statistics Table
Table B-37 Ethernet Jitter Minute Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
rowID
|
Bigint
|
IDENTITY, primary key
|
Identifier
|
CollectorID
|
"
|
"
|
Collector (Running Instance) ID
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time
|
MinRTT
|
Integer
|
"
|
See MIB object:
ipslaEtherJitterLatestRTTMin
|
MaxRTT
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestRTTMax
|
NumRTT
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestNumRTT
|
SumRTT
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestRTTSum
|
SumRTT2
|
Double
|
"
|
See MIB object:
ipslaEtherJitterLatestRTTSum2
|
minofposisd
|
Integer
|
"
|
See MIB object:
ipslaEtherJitterLatestMinPosSD
|
maxofposisd
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestMaxPosSD
|
numofposisd
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestNumPosSD
|
sumofposisd
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestSumPosSD
|
sum2posisd
|
Double
|
"
|
See MIB object:
ipslaEtherJitterLatestSum2PosSD
|
minofnegasd
|
Integer
|
"
|
See MIB object:
ipslaEtherJitterLatestMinNegSD
|
maxofnegasd
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestMaxNegSD
|
numofnegasd
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestNumNegSD
|
sumofnegasd
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestSumNegSD
|
sum2negasd
|
Double
|
"
|
See MIB object:
ipslaEtherJitterLatestSum2NegSD
|
minofposids
|
Integer
|
"
|
See MIB object:
ipslaEtherJitterLatestMinPosDS
|
maxofposids
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestMaxPosDS
|
numofposids
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestNumPosDS
|
sumofposids
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestSumPosDS
|
sum2posids
|
Double
|
"
|
See MIB object:
ipslaEtherJitterLatestSum2PosDS
|
minofnegads
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestMinNegDS
|
maxofnegads
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestMaxNegDS
|
numofnegads
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestNumNegDS
|
sumofnegads
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestSumNegDS
|
sum2negads
|
Double
|
"
|
See MIB object:
ipslaEtherJitterLatestSum2NegDS
|
numframeLossSD
|
Integer
|
"
|
See MIB object:
ipslaEtherJitterLatestFrmLossSD
|
numframeLossDS
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestFrmLossDS
|
minSuccframeLoss
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestMinSucFrmL
|
maxSuccframeLoss
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestMaxSucFrmL
|
IAJitterOut
|
"
|
Null
|
See MIB object:
ipslaEtherJitterLatestIAJOut
|
IAJitterIn
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestIAJIn
|
numframeoutOfSeq
|
Double
|
not Null
|
See MIB object:
ipslaEtherJitterLatestFrmOutSeq
|
numframeSkips
|
Integer
|
"
|
See MIB object:
ipslaEtherJitterLatestFrmSkipped
|
numframeUnpro
|
"
|
"
|
See MIB object:
ipslaEtherJLatestFrmUnProcessed
|
numframelate
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestFrmLateA
|
numframemia
|
"
|
"
|
See MIB object:
ipslaEtherJitterLatestFrmMIA
|
AvgRTT
|
Numeric(30,6)
|
Null
|
Average of RTT
|
AvgPosSD
|
"
|
"
|
Average of positive SD
|
StdDevPosSD
|
"
|
"
|
Standard deviation of positive SD
|
AvgNegSD
|
"
|
"
|
Average of negative SD
|
StdDevNegSD
|
"
|
"
|
Standard deviation of negative SD
|
AvgPosDS
|
"
|
"
|
Average of positive DS
|
StdDevPosDS
|
"
|
"
|
Standard deviation of positive DS
|
AvgNegDS
|
"
|
"
|
Average of negative DS
|
StdDevNegDS
|
"
|
"
|
Standard deviation of negative DS
|
StdDevRTT
|
"
|
"
|
Standard deviation of RTT
|
Ethernet Jitter Hourly Statistics Table
Table B-38 Ethernet Jitter Hourly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
RowID
|
Bigint
|
IDENTITY,
primary key
|
identifier
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the hourly bucket
|
MinRTT
|
Integer
|
"
|
See MIB object:
ipslaEtherJAggMeasuredRTTMin
|
MaxRTT
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredRTTMax
|
NumRTT
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredNumRTTs
|
SumRTT
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredRTTSums
|
SumRTT2
|
Double
|
"
|
Sum square of RTT
See MIB object:
ipslaEtherJAggMeasuredRTTSum2Ls, ipslaEtherJAggMeasuredRTTSum2Hs.
|
minofposisd
|
Integer
|
"
|
See MIB object:
ipslaEtherJAggMeasuredMinPosSD
|
maxofposisd
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredMaxPosSD
|
numofposisd
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredNumPosSDs
|
sumofposisd
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredSumPosSDs
|
sum2posisd
|
Double
|
"
|
Sum square of positive SD
See MIB object:
ipslaEtherJAggMeasuredSum2PSDLs, ipslaEtherJAggMeasuredSum2PSDHs
|
minofnegasd
|
Integer
|
"
|
See MIB object:
ipslaEtherJAggMeasuredMinNegSD
|
maxofnegasd
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredMaxNegSD
|
numofnegasd
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredNumNegSDs
|
sumofnegasd
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredSumNegSDs
|
sum2negasd
|
Double
|
"
|
Sum square of negative SD
See MIB object:
ipslaEtherJAggMeasuredSum2NSDLs, ipslaEtherJAggMeasuredSum2NSDHs
|
minofposids
|
Integer
|
"
|
See MIB object:
ipslaEtherJAggMeasuredMinPosDS
|
maxofposids
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredMaxPosDS
|
numofposids
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredNumPosDSes
|
sumofposids
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredSumPosDSes
|
sum2posids
|
Double
|
"
|
Sum square of positive DS
See MIB object:
ipslaEtherJAggMeasuredSum2PDSLs, ipslaEtherJAggMeasuredSum2PDSHs
|
minofnegads
|
Integer
|
"
|
See MIB object:
ipslaEtherJAggMeasuredMinNegDS
|
maxofnegads
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredMaxNegDS
|
numofnegads
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredNumNegDSes
|
sumofnegads
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredSumNegDSes
|
sum2negads
|
Double
|
"
|
Sum square of negative DS
See MIB object:
ipslaEtherJAggMeasuredSum2NDSLs, ipslaEtherJAggMeasuredSum2NDSLs
|
numcomplete
|
Integer
|
"
|
See MIB object:
ipslaEtherJAggMeasured
Cmpletions
|
numoverthresh
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredOvThrshlds
|
numframeLossSD
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredFrmLossSDs
|
numframeLossDS
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredFrmLssDSes
|
minSuccframeLoss
|
"
|
"
|
See MIB object:
ipslaEtherJAggMinSucFrmLoss
|
maxSuccframeLoss
|
"
|
"
|
See MIB object:
pslaEtherJAggMaxSucFrmLoss
|
IAJitterOut
|
"
|
Null
|
See MIB object:
ipslaEtherJAggMeasuredIAJOut
|
IAJitterIn
|
"
|
Null
|
See MIB object:
ipslaEtherJAggMeasuredIAJIn
|
numerror
|
"
|
not Null
|
See MIB object:
ipslaEtherJAggMeasured
Errors
|
numbusy
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasured
Busies
|
numframeoutOfSeq
|
Double
|
"
|
See MIB object:
ipslaEtherJAggMeasuredrm
OutSeqs
|
numframeSkips
|
Integer
|
"
|
See MIB object:
ipslaEtherJAggMeasuredFrmSkippds
|
numframeUnpro
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredFrmUnPrcds
|
numframelate
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredFrmLateAs
|
numframemia
|
"
|
"
|
See MIB object:
ipslaEtherJAggMeasuredFrmMIAes
|
AvgRtt
|
Numeric(30,6)
|
"
|
Average of RTT
|
Error_Percent
|
"
|
"
|
Error percentage
|
NumTries
|
Integer
|
"
|
Number of tries
|
AvgPosSD
|
Numeric(30,6)
|
"
|
Average of positive SD
|
StdDevPosSD
|
"
|
"
|
Standard deviation of positive SD
|
AvgNegSD
|
"
|
"
|
Average of negative SD
|
StdDevNegSD
|
"
|
"
|
Standard deviation of negative SD
|
AvgPosDS
|
"
|
`
|
Average of positive DS
|
StdDevPosDS
|
"
|
"
|
Standard deviation of positive DS
|
AvgNegDS
|
"
|
"
|
Average of negative DS
|
StdDevNegDS
|
"
|
"
|
Standard deviation of negative DS
|
PacketErrorPercent
|
"
|
Null
|
Packet error percentage
|
OverThresholdPercent
|
"
|
"
|
Over threshold percentage
|
StdDevRTT
|
"
|
"
|
Standard deviation of RTT
|
TotalPackets
|
Integer
|
"
|
Total packets
|
Ethernet Jitter Daily Statistics Table
All the column values other than the Collector ID and Start Time are average values from the hourly table.
Table B-39 Ethernet Jitter Daily Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the day
|
rttmin
|
Integer
|
"
|
Average of all MinRTT
|
rttmax
|
"
|
"
|
Average of all MaxRTT
|
numrtt
|
"
|
"
|
Number of RTT
|
sumrtt
|
"
|
"
|
Sum of RTT
|
sumrtt2
|
Double
|
"
|
Sum square of RTT
|
minofposisd
|
Integer
|
"
|
Minimum of positive SD
|
maxofposisd
|
"
|
"
|
Maximum of positive SD
|
numofposisd
|
"
|
"
|
Number of positive SD
|
sumofposisd
|
"
|
"
|
Sum of positive SD
|
sum2posisd
|
Double
|
"
|
Sum square of positive SD
|
minofnegasd
|
Integer
|
"
|
Minimum of negative SD
|
maxofnegasd
|
"
|
"
|
Maximum of negative SD
|
numofnegasd
|
"
|
"
|
Number of negative SD
|
sumofnegasd
|
"
|
"
|
Sum of negative SD
|
sum2negasd
|
Double
|
"
|
Sum square of negative SD
|
minofposids
|
Integer
|
"
|
Minimum of positive DS
|
maxofposids
|
"
|
"
|
Maximum of positive DS
|
numofposids
|
"
|
"
|
Number of positive DS
|
sumofposids
|
"
|
"
|
Sum of positive DS
|
sum2posids
|
Double
|
"
|
Sum square of positive DS
|
minofnegads
|
Integer
|
"
|
Minimum of negative DS
|
maxofnegads
|
"
|
"
|
Maximum of negative Ds
|
numofnegads
|
"
|
"
|
Number of negative DS
|
sumofnegads
|
"
|
"
|
Sum of negative DS
|
sum2negads
|
Double
|
"
|
Sum square of negative DS
|
numcomplete
|
Integer
|
"
|
Number of completions
|
numoverthresh
|
"
|
"
|
Number of over threshold
|
numframeLossSD
|
"
|
"
|
Number of frame loss SD
|
numframeLossDS
|
"
|
"
|
Number of frame loss DS
|
minSuccframeLoss
|
"
|
"
|
Minimum of successful frame loss
|
maxSuccframeLoss
|
"
|
"
|
Maximum of successful frame loss
|
IAJitterOut
|
"
|
Null
|
IA jitter out
|
IAJitterIn
|
"
|
Null
|
IA jitter In
|
numerror
|
"
|
not Null
|
Number of errors
|
numbusy
|
"
|
"
|
Number of busies
|
numframeoutOfSeq
|
Double
|
"
|
Number of frame out of sequence
|
numframeSkips
|
Integer
|
"
|
Number of frame skips
|
numframeUnpro
|
"
|
"
|
Number of frames un processed
|
numframelate
|
"
|
"
|
Number of late frames
|
numframemia
|
"
|
"
|
Number of frame MIA
|
AvgRtt
|
Numeric(30,6)
|
"
|
Average of RTT
|
Error_Percent
|
"
|
"
|
Error percentage
|
NumTries
|
Integer
|
"
|
Number of tires
|
AvgPosSD
|
Numeric(30,6)
|
"
|
Average of positive SD
|
StdDevPosSD
|
"
|
"
|
Standard deviation of positive SD
|
AvgNegSD
|
"
|
"
|
Average of negative SD
|
StdDevNegSD
|
"
|
"
|
Standard deviation of negative SD
|
AvgPosDS
|
"
|
`
|
Avergae of positve DS
|
StdDevPosDS
|
"
|
"
|
Standared deviation of positive DS
|
AvgNegDS
|
"
|
"
|
Average of negative DS
|
StdDevNegDS
|
"
|
"
|
Standard deviation of negative DS
|
PacketErrorPercent
|
"
|
Null
|
Packet error percenatge
|
OverThresholdPercent
|
"
|
"
|
Over thershold percentage
|
StdDevRTT
|
"
|
"
|
Standard devaition of RTT
|
TotalPackets
|
Integer
|
"
|
Total packets
|
Ethernet Jitter Weekly Statistics Table
All the column values other than the collector ID and Start Time are average values from Daily table.
Table B-40 Ethernet Jitter Weekly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the day
|
MinRTT
|
Integer
|
"
|
Average of all MinRTT
|
MaxRTT
|
"
|
"
|
Average of all MaxRTT
|
NumRTT
|
"
|
"
|
Number of RTT
|
SumRTT
|
"
|
"
|
Sum of RTT
|
SumRTT2
|
Double
|
"
|
Sum square of RTT
|
minofposisd
|
Integer
|
"
|
Minimum of positive SD
|
maxofposisd
|
"
|
"
|
Maximum of positive SD
|
numofposisd
|
"
|
"
|
Number of positive SD
|
sumofposisd
|
"
|
"
|
Sum of positive SD
|
sum2posisd
|
Double
|
"
|
Sum square of positive SD
|
minofnegasd
|
Integer
|
"
|
Minimum of negative SD
|
maxofnegasd
|
"
|
"
|
Maximum of negative SD
|
numofnegasd
|
"
|
"
|
Number of negative SD
|
sumofnegasd
|
"
|
"
|
Sum of negative SD
|
sum2negasd
|
Double
|
"
|
Sum square of negative SD
|
minofposids
|
Integer
|
"
|
Minimum of positive DS
|
maxofposids
|
"
|
"
|
Maximum of positive DS
|
numofposids
|
"
|
"
|
Number of positive DS
|
sumofposids
|
"
|
"
|
Sum of positive DS
|
sum2posids
|
Double
|
"
|
Sum square of positive DS
|
minofnegads
|
Integer
|
"
|
Minimum of negative DS
|
maxofnegads
|
"
|
"
|
Maximum of negative Ds
|
numofnegads
|
"
|
"
|
Number of negative DS
|
sumofnegads
|
"
|
"
|
Sum of negative DS
|
sum2negads
|
Double
|
"
|
Sum square of negative DS
|
numcomplete
|
Integer
|
"
|
Number of completions
|
numoverthresh
|
"
|
"
|
Number of over threshold
|
numframeLossSD
|
"
|
"
|
Number of frame loss SD
|
numframeLossDS
|
"
|
"
|
Number of frame loss DS
|
minSuccframeLoss
|
"
|
"
|
Minimum of successful frame loss
|
maxSuccframeLoss
|
"
|
"
|
Maximum of successful frame loss
|
IAJitterOut
|
"
|
Null
|
IA jitter out
|
IAJitterIn
|
"
|
Null
|
IA jitter In
|
numerror
|
"
|
not Null
|
Number of errors
|
numbusy
|
"
|
"
|
Number of busies
|
numframeoutOfSeq
|
Double
|
"
|
Number of frame out of sequence
|
numframeSkips
|
Integer
|
"
|
Number of frame skips
|
numframeUnpro
|
"
|
"
|
Number of frames un processed
|
numframelate
|
"
|
"
|
Number of late frames
|
numframemia
|
"
|
"
|
Number of frame MIA
|
AvgRtt
|
Numeric(30,6)
|
"
|
Average of RTT
|
Error_Percent
|
"
|
"
|
Error percentage
|
NumTries
|
Integer
|
"
|
Number of tires
|
AvgPosSD
|
Numeric(30,6)
|
"
|
Average of positive SD
|
StdDevPosSD
|
"
|
"
|
Standard deviation of positive SD
|
AvgNegSD
|
"
|
"
|
Average of negative SD
|
StdDevNegSD
|
"
|
"
|
Standard deviation of negative SD
|
AvgPosDS
|
"
|
`
|
Avergae of positve DS
|
StdDevPosDS
|
"
|
"
|
Standared deviation of positive DS
|
AvgNegDS
|
"
|
"
|
Average of negative DS
|
StdDevNegDS
|
"
|
"
|
Standard deviation of negative DS
|
PacketErrorPercent
|
"
|
Null
|
Packet error percenatge
|
OverThresholdPercent
|
"
|
"
|
Over thershold percentage
|
StdDevRTT
|
"
|
"
|
Standard devaition of RTT
|
TotalPackets
|
Integer
|
"
|
Total packets
|
Ethernet Jitter Monthly Statistics Table
All the column values other than the collector ID and Start Time are average values from the weekly table.
Table B-41 Ethernet Jitter Monthly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the month
|
MinRTT
|
Integer
|
"
|
Average of all MinRTT
|
MaxRTT
|
"
|
"
|
Average of all MaxRTT
|
NumRTT
|
"
|
"
|
Number of RTT
|
SumRTT
|
"
|
"
|
Sum of RTT
|
SumRTT2
|
Double
|
"
|
Sum square of RTT
|
minofposisd
|
Integer
|
"
|
Minimum of positive SD
|
maxofposisd
|
"
|
"
|
Maximum of positive SD
|
numofposisd
|
"
|
"
|
Number of positive SD
|
sumofposisd
|
"
|
"
|
Sum of positive SD
|
sum2posisd
|
Double
|
"
|
Sum square of positive SD
|
minofnegasd
|
Integer
|
"
|
Minimum of negative SD
|
maxofnegasd
|
"
|
"
|
Maximum of negative SD
|
numofnegasd
|
"
|
"
|
Number of negative SD
|
sumofnegasd
|
"
|
"
|
Sum of negative SD
|
sum2negasd
|
Double
|
"
|
Sum square of negative SD
|
minofposids
|
Integer
|
"
|
Minimum of positive DS
|
maxofposids
|
"
|
"
|
Maximum of positive DS
|
numofposids
|
"
|
"
|
Number of positive DS
|
sumofposids
|
"
|
"
|
Sum of positive DS
|
sum2posids
|
Double
|
"
|
Sum square of positive DS
|
minofnegads
|
Integer
|
"
|
Minimum of negative DS
|
maxofnegads
|
"
|
"
|
Maximum of negative Ds
|
numofnegads
|
"
|
"
|
Number of negative DS
|
sumofnegads
|
"
|
"
|
Sum of negative DS
|
sum2negads
|
Double
|
"
|
Sum square of negative DS
|
numcomplete
|
Integer
|
"
|
Number of completions
|
numoverthresh
|
"
|
"
|
Number of over threshold
|
numframeLossSD
|
"
|
"
|
Number of frame loss SD
|
numframeLossDS
|
"
|
"
|
Number of frame loss DS
|
minSuccframeLoss
|
"
|
"
|
Minimum of successful frame loss
|
maxSuccframeLoss
|
"
|
"
|
Maximum of successful frame loss
|
IAJitterOut
|
"
|
Null
|
IA jitter out
|
IAJitterIn
|
"
|
Null
|
IA jitter In
|
numerror
|
"
|
not Null
|
Number of errors
|
numbusy
|
"
|
"
|
Number of busies
|
numframeoutOfSeq
|
Double
|
"
|
Number of frame out of sequence
|
numframeSkips
|
Integer
|
"
|
Number of frame skips
|
numframeUnpro
|
"
|
"
|
Number of frames un processed
|
numframelate
|
"
|
"
|
Number of late frames
|
numframemia
|
"
|
"
|
Number of frame MIA
|
AvgRtt
|
Numeric(30,6)
|
"
|
Average of RTT
|
Error_Percent
|
"
|
"
|
Error percentage
|
NumTries
|
Integer
|
"
|
Number of tires
|
AvgPosSD
|
Numeric(30,6)
|
"
|
Average of positive SD
|
StdDevPosSD
|
"
|
"
|
Standard deviation of positive SD
|
AvgNegSD
|
"
|
"
|
Average of negative SD
|
StdDevNegSD
|
"
|
"
|
Standard deviation of negative SD
|
AvgPosDS
|
"
|
`
|
Avergae of positve DS
|
StdDevPosDS
|
"
|
"
|
Standared deviation of positive DS
|
AvgNegDS
|
"
|
"
|
Average of negative DS
|
StdDevNegDS
|
"
|
"
|
Standard deviation of negative DS
|
PacketErrorPercent
|
"
|
Null
|
Packet error percenatge
|
OverThreshold
Percent
|
"
|
"
|
Over thershold percentage
|
StdDevRTT
|
"
|
"
|
Standard devaition of RTT
|
TotalPackets
|
Integer
|
"
|
Total packets
|
HTTP Minute Statistics Table
Table B-42 HTTP Minute Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
rowID
|
Numeric(10)
|
IDENTITY,
primary key
|
Unique Identifier
|
CollectorID
|
Bigint
|
IDENTITY,
Primary Key
|
Collector (Running Instance) ID
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time
|
RTT
|
Integer
|
"
|
See MIB object:
rttMonLatestHTTP
OperRTT
MIB type: Gauge (32 bit)
|
DNSRTT
|
"
|
"
|
See MIB object:
rttMonLatestHTTPOper
DNSRTT
MIB type: Gauge (32 bit)
|
TCPConnectRTT
|
"
|
"
|
See MIB object:
rttMonLatestHTTPOper
CPConnectRTT
MIB type: Gauge (32 bit)
|
TransactionRTT
|
"
|
"
|
See MIB object:
rttMonLatestHTTPOper
TransactionRTT
MIB type: Gauge (32 bit)
|
MessageBodyOctets
|
"
|
"
|
See MIB object:
rttMonLatestHTTPOper
MessageBodyOctets
MIB type: Gauge (32 bit)
|
HTTP Hourly Statistics Table
Table B-43 HTTP Hourly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
rowID
|
Numeric(10)
|
IDENTITY,
primary key
|
Unique identifier
|
CollectorID
|
Bigint
|
IDENTITY,
Primary Key
|
Collector (Running Instance) ID
Reference to collector(ID)
|
starttime
|
Timestamp
|
Not Null
|
Start time of the hourly bucket
|
MinRTT
|
Integer
|
"
|
See MIB object:
rttMonHTTPStats
RTTMin
MIB type: Gauge (32 bit)
|
MaxRTT
|
"
|
"
|
See MIB object:
rttMonHTTPStatsRTT
Max
MIB type: Gauge (32 bit)
|
SumRTT
|
"
|
"
|
See MIB object:
rttMonHTTPStatsRTTSum
MIB type: Counter (32 bit)
|
SumOfSquaredRTT
|
Double
|
"
|
Sum square of all RTT.
See MIB object:
rttMonHTTPStatsRTT
Sum2Low, rttMonHTTPStatsRTT
Sum2High
|
DNSRTTSum
|
Integer
|
"
|
See MIB object:
rttMonHTTPStatsDNSRTTSum
MIB type: Counter (32 bit)
|
TCPConnectRTTSum
|
"
|
"
|
See MIB object:
rttMonHTTPStatsTCPConnectRTTSum
MIB type: Counter (32 bit)
|
TransactionRTTSum
|
"
|
"
|
See MIB object:
rttMonHTTPStats
TransactionRTTSum
MIB type: Counter (32 bit)
|
MessageBodyOctetsSum
|
"
|
"
|
See MIB object:
rttMonHTTPStats
MessageBodyOctets
Sum
MIB type: Counter (32 bit)
|
DNSServerTimeouts
|
"
|
"
|
See MIB object:
rttMonHTTPStatsDNS
ServerTimeout
MIB type: Counter (32 bit)
|
TCPConnectTimeouts
|
"
|
"
|
See MIB object:
rttMonHTTPStatsTCP
ConnectTimeout
MIB type: Counter (32 bit)
|
TransactionTimeouts
|
"
|
"
|
See MIB object:
rttMonHTTPStats
TransactionTimeout
MIB type: Counter (32 bit)
|
DNSQueryErrors
|
"
|
"
|
See MIB object:
rttMonHTTPStatsDNS
QueryError
MIB type: Counter (32 bit)
|
HttpErrors
|
"
|
"
|
See MIB object:
rttMonHTTPStatsHTTPError
MIB type: Counter (32 bit)
|
InternalErrors
|
"
|
"
|
See MIB object:
rttMonHTTPStatsError
MIB type: Counter (32 bit)
|
NumBusies
|
"
|
"
|
Number of busies.
See MIB object:
rttMonHTTPStatsBusies
MIB type: Counter (32 bit)
|
NumCompletions
|
"
|
"
|
Number of completions.
See MIB object:
rttMonHTTPStats
Completions
MIB type: Counter (32 bit)
|
NumOverThresholds
|
"
|
"
|
Number of over thresholds.
See MIB object:
rttMonHTTPStatsOver
Thresholds
MIB type: Counter (32 bit)
|
AvgRtt
|
Numeric(30)
|
"
|
Average of RTT
|
StdDevRTT
|
"
|
Null
|
Standard deviation of RTT
|
NumTries
|
Integer
|
Not Null
|
Number of tries
|
OverThresholdPercent
|
Numeric(30)
|
Null
|
Over threshold percentage
|
Error_Percent
|
"
|
Not Null
|
Error percentage
|
AvgDNSRTT
|
"
|
"
|
Average DNS RTT
|
AvgTCPConnectRTT
|
"
|
"
|
Average of TCP connect RTT
|
AvgTransactionRTT
|
"
|
"
|
Average of transaction RTT
|
AvgMessageBodyOctets
|
"
|
"
|
Average of messagebodyoctets
|
HTTP Daily Statistics Table
All the column values other than the Collector ID and Start Time are average values from the hourly table.
Table B-44 HTTP Daily Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
IDENTITY, Primary Key
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
Start Time
|
Timestamp
|
Not Null
|
Start time of the day
|
MinRTT
|
Integer
|
"
|
Average of all MinRTT.
|
MaxRTT
|
"
|
"
|
Average of all MaxRTT.
|
SumRTT
|
"
|
"
|
Sum of all RTT
|
SumOfSquaredRTT
|
Double
|
"
|
Sum square of all RTT
|
DNSRTTSum
|
Integer
|
"
|
Sum of DNSRTT
|
TCPConnectRTTSum
|
"
|
"
|
Sum of TCPConnectRTT
|
TransactionRTTSum
|
"
|
"
|
Sum of TransactionRTT
|
MessageBodyOctetsSum
|
"
|
"
|
Sum of MessageBodyOctets
|
DNSServerTimeouts
|
"
|
"
|
DNSServer Timeouts
|
TCPConnectTimeouts
|
"
|
"
|
TCPConnect Timeouts
|
TransactionTimeouts
|
"
|
"
|
Transaction Timeouts
|
DNSQueryErrors
|
"
|
"
|
DNSQuery Errors
|
HttpErrors
|
"
|
"
|
Http Errors
|
InternalErrors
|
"
|
"
|
Internal Errors
|
NumBusies
|
"
|
"
|
Number of busies
|
NumCompletions
|
"
|
"
|
Number of completions.
|
NumOverThresholds
|
"
|
"
|
Number of over thresholds.
|
AvgRtt
|
Numeric(30)
|
"
|
Average of RTT
|
StdDevRTT
|
"
|
Null
|
Standard deviation of RTT
|
NumTries
|
Integer
|
Not Null
|
Number of tries
|
OverThresholdPercent
|
Numeric(30)
|
Null
|
Over threshold percentage
|
Error_Percent
|
"
|
Not Null
|
Error percentage
|
AvgDNSRTT
|
"
|
"
|
Average DNS RTT
|
AvgTCPConnectRTT
|
"
|
"
|
Average of TCP connect RTT
|
AvgTransactionRTT
|
"
|
"
|
Average of transaction RTT
|
AvgMessageBodyOctets
|
"
|
"
|
Average of messagebodyoctets
|
HTTP Weekly Statistics Table
All the column values other than the collector ID and Start Time are average values from Daily table.
Table B-45 HTTP Weekly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
IDENTITY,
Primary Key
|
Collector (Running Instance) ID.
Reference to collector(ID)
|
Start Time
|
Timestamp
|
Not Null
|
Start time of the week
|
MinRTT
|
Integer
|
"
|
Average of all MinRTT
|
MaxRTT
|
"
|
"
|
Average of all MaxRTT
|
SumRTT
|
"
|
"
|
Sum of all RTT
|
SumOfSquaredRTT
|
Double
|
"
|
Sum square of all RTT
|
DNSRTTSum
|
Integer
|
"
|
Sum of DNSRTT
|
TCPConnectRTTSum
|
"
|
"
|
Sum of TCPConnectRTT
|
TransactionRTTSum
|
"
|
"
|
Sum of TransactionRTT
|
MessageBodyOctetsSum
|
"
|
"
|
Sum of MessageBodyOctets
|
DNSServerTimeouts
|
"
|
"
|
DNSServer Timeouts
|
TCPConnectTimeouts
|
"
|
"
|
TCPConnect Timeouts
|
TransactionTimeouts
|
"
|
"
|
Transaction Timeouts
|
DNSQueryErrors
|
"
|
"
|
DNSQuery Errors
|
HttpErrors
|
"
|
"
|
Http Errors
|
InternalErrors
|
"
|
"
|
Internal Errors
|
NumBusies
|
"
|
"
|
Number of busies
|
NumCompletions
|
"
|
"
|
Number of completions.
|
NumOverThresholds
|
"
|
"
|
Number of over thresholds.
|
AvgRtt
|
Numeric(30)
|
"
|
Average of RTT
|
StdDevRTT
|
"
|
Null
|
Standard deviation of RTT
|
NumTries
|
Integer
|
Not Null
|
Number of tries
|
OverThresholdPercent
|
Numeric(30)
|
Null
|
Over threshold percentage
|
Error_Percent
|
"
|
Not Null
|
Error percentage
|
AvgDNSRTT
|
"
|
"
|
Average DNS RTT
|
AvgTCPConnectRTT
|
"
|
"
|
Average of TCP connect RTT
|
AvgTransactionRTT
|
"
|
"
|
Average of transaction RTT
|
AvgMessageBodyOctets
|
"
|
"
|
Average of messagebodyoctets
|
HTTP Monthly Statistics Table
All the column values other than the collector ID and Start Time are average values from the weekly table
Table B-46 HTTP Monthly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID
Reference to collector(ID)
|
Start Time
|
Timestamp
|
Not Null
|
Start time of the month
|
RTTMin
|
Integer
|
"
|
Average of all MinRTT.
|
RTTMax
|
"
|
"
|
Average of all MinRTT.
|
RTTSum
|
"
|
"
|
Sum of all RTT
|
SumOfSquaredRTT
|
Double
|
"
|
Sum square of all RTT
|
DNSRTTSum
|
Integer
|
"
|
Sum of DNSRTT
|
TCPConnectRTTSum
|
"
|
"
|
Sum of TCPConnectRTT
|
TransactionRTT
Sum
|
"
|
"
|
Sum of TransactionRTT
|
MessageBodyOctetsSum
|
"
|
"
|
Sum of MessageBodyOctets
|
DNSServerTimeouts
|
"
|
"
|
DNSServer Timeouts
|
TCPConnectTimeouts
|
"
|
"
|
TCPConnect Timeouts
|
TransactionTimeouts
|
"
|
"
|
Transaction Timeouts
|
DNSQueryErrors
|
"
|
"
|
DNSQuery Errors
|
HttpErrors
|
"
|
"
|
Http Errors
|
InternalErrors
|
"
|
"
|
Internal Errors
|
NumBusies
|
"
|
"
|
Number of busies.
|
NumCompletions
|
"
|
"
|
Number of completions.
|
NumOverThresholds
|
"
|
"
|
Number of over thresholds.
|
AvgRtt
|
Numeric(30)
|
"
|
Average of RTT
|
StdDevRTT
|
"
|
Null
|
Standard deviation of RTT
|
NumTries
|
Integer
|
Not Null
|
Number of tries
|
OverThreshold
Percent
|
Numeric(30)
|
Null
|
Over threshold percentage
|
Error_Percent
|
"
|
Not Null
|
Error percentage
|
AvgDNSRTT
|
"
|
"
|
Average DNS RTT
|
AvgTCPConnectRTT
|
"
|
"
|
Average of TCP connect RTT
|
AvgTransactionRTT
|
"
|
"
|
Average of transaction RTT
|
AvgMessageBodyOctets
|
"
|
"
|
Average of messagebodyoctets
|
Patheco Hourly Statistics Table
Table B-47 Pathecho Hourly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
RowID
|
Bigint
|
IDENTITY,
primary key
|
Unique Identifier
|
CollectorID
|
"
|
Not Null
|
Collector (Running Instance) ID
Reference to collector(ID)
|
PathID
|
Integer
|
Null
|
Path ID.
Reference to
pathinfo(path ID)
|
HopID
|
"
|
"
|
Hop ID
|
HopAddress
|
Varchar(255)
|
"
|
Hop address
See MIB object:
rttMonStatsCollectAddress
|
StartTime
|
Timestamp
|
Not Null
|
Start time fo the hourly bucket
|
MinRTT
|
Integer
|
"
|
Minimum of RTT
See MIB object:
rttMonStatsCaptureCompletionTimeMin
|
MaxRTT
|
"
|
"
|
Maximum of RTT
See MIB object:
rttMonStatsCaptureCompletionTimeMax
|
SumRTT
|
"
|
"
|
Sum of all RTT
See MIB object:
rttMonStatsCaptureSum
CompletionTime
|
SumSqrdRTT
|
"
|
"
|
Sum square of all RTT
See MIB object:
rttMonStatsCaptureSum
CompletionTime2Low, rttMonStatsCaptureSum
CompletionTime2High
|
NumCompletions
|
"
|
"
|
Number of completions.
See MIB object:
rttMonStatsCapture
Completions
|
NumOverThresholds
|
"
|
"
|
Number of over thresholds.
See MIB object:
rttMonHTTPStatsOver
Thresholds
MIB type: Counter (32 bit)
|
NumDisconnects
|
"
|
"
|
Number of disconnects.
See MIB object:
rttMonStatsCollectNum
Disconnects
|
NumTimeouts
|
"
|
"
|
Number of Timeouts
See MIB object:
rttMonStatsCollectTimeout
MIB type:
Integer32(0..2147483647)
|
NumBusies
|
"
|
"
|
Number of busies
See MIB object: rttMonStatsCollectBusies
|
NumNoConnections
|
"
|
"
|
Number of no connections
See MIB object:
rttMonStatsCollectNoConnections.
|
NumDrops
|
"
|
"
|
Number of drops.
See MIB object:
rttMonStatsCollectDrops
|
NumSeqErrors
|
"
|
"
|
Number of sequence errors.
See MIB object:
rttMonStatsCollectSequence
Errors
|
NumVerifyErrors
|
"
|
"
|
Number of verify errors
See MIB object:
rttMonStatsCollectVerify
Errors
|
NumTries
|
"
|
"
|
Number of tries
|
AvgRTT
|
Numeric(30)
|
"
|
Average of all RTT
|
Standard
Deviation
|
"
|
"
|
Standard deviation
|
OverThres_
Percent
|
"
|
"
|
Over threshold percentage
|
Error_Percent
|
"
|
"
|
Error percentage
|
Availability_ Percent
|
"
|
"
|
AvailabilityPercent
|
Pathecho Daily Statistics Table
All the column values other than the Collector ID and Start Time are average values from the hourly table.
Table B-48 Pathecho Daily Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
"
|
Not Null
|
Collector (Running Instance) ID
Reference to collector(ID)
|
PathID
|
Integer
|
|
Path ID.
See Pathinfo (path ID)
|
HopID
|
"
|
|
Hop ID
|
HopAddress
|
Varchar(255)
|
|
Hop address
|
StartTime
|
Timestamp
|
|
Start time of the day
|
MinRTT
|
Integer
|
|
Average of all MinRTT
|
MaxRTT
|
"
|
|
Average of all MaxRTT
|
SumRTT
|
"
|
|
Sum of all RTT
|
SumSqrdRTT
|
"
|
|
Sum square of all RTT
|
NumCompletions
|
"
|
|
Number of completions.
|
NumOverThresholds
|
"
|
|
Number of over thresholds.
|
NumDisconnects
|
"
|
|
Number of disconnects.
|
NumTimeouts
|
"
|
|
Number of Timeouts
|
NumBusies
|
"
|
|
Number of busies.
|
NumNoConnections
|
"
|
|
Number of no connections.
|
NumDrops
|
"
|
|
Number of drops.
|
NumSeqErrors
|
"
|
|
Number of sequence errors
|
NumVerifyErrors
|
"
|
|
Number of verify errors
|
NumTries
|
"
|
|
Number of tries
|
AvgRTT
|
Numeric(30)
|
|
Average of all RTT
|
StandardDeviation
|
"
|
|
Standard deviation
|
OverThres_Percent
|
"
|
|
Over threshold percentage
|
Error_Percent
|
"
|
|
Error percentage
|
Availability_Percent
|
"
|
|
AvailabilityPercent
|
Pathecho Weekly Statistics Table
All the column values other than the collector ID and Start Time are average values from Daily table.
Table B-49 Pathecho Weekly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
"
|
Not Null
|
Collector (Running Instance) ID
See collector(ID)
|
PathID
|
Integer
|
|
Path ID.
See pathinfo(pathID)
|
HopID
|
"
|
|
Hop ID
|
HopAddress
|
Varchar(255)
|
|
Hop address
See MIBobject:
rttMonStatsCollectAddress
|
StartTime
|
Timestamp
|
|
Start time fo the week
|
MinRTT
|
Integer
|
|
Average of all MinRTT.
|
MaxRTT
|
"
|
|
Average of all MaxRTT.
|
SumRTT
|
"
|
|
Sum of all RTT
|
SumSqrdRTT
|
"
|
|
Sum square of all RTT
|
NumCompletions
|
"
|
|
Number of completions.
|
NumOverThresholds
|
"
|
|
Number of over thresholds.
|
NumDisconnects
|
"
|
|
Number of disconnects.
|
NumTimeouts
|
"
|
|
Number of Timeouts
|
NumBusies
|
"
|
|
Number of busies
|
NumNoConnections
|
"
|
|
Number of no connections.
|
NumDrops
|
"
|
|
Number of drops
|
NumSeqErrors
|
"
|
|
Number of sequence errors.
|
NumVerifyErrors
|
"
|
|
Number of verify errors.
|
NumTries
|
"
|
|
Number of tries
|
AvgRTT
|
Numeric(30)
|
|
Average of all RTT
|
StandardDeviation
|
"
|
|
Standard deviation
|
OverThres_Percent
|
"
|
|
Over threshold percentage
|
Error_Percent
|
"
|
|
Error percentage
|
Availability_Percent
|
"
|
|
AvailabilityPercent
|
Pathecho Monthly Statistics Table
All the column values other than the collector ID and Start Time are average values from the weekly table
Table B-50 Pathecho Monthly Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
CollectorID
|
"
|
Not Null
|
Collector (Running Instance) ID
See collector(ID)
|
PathID
|
Integer
|
|
Path ID.
See pathinfo(path ID)
|
HopID
|
"
|
|
Hop ID
|
HopAddress
|
Varchar(255)
|
|
Hop address
|
StartTime
|
Timestamp
|
|
Start time of the month
|
MinRTT
|
Integer
|
|
Average of all MinRTT.
|
MaxRTT
|
"
|
|
Average of all MaxRTT.
|
SumRTT
|
"
|
|
Sum of all RTT
|
SumSqrdRTT
|
"
|
|
Sum square of all RTT
|
NumCompletions
|
"
|
|
Number of completions.
|
NumOverThresholds
|
"
|
|
Number of over thresholds.
|
NumDisconnects
|
"
|
|
Number of disconnects
|
NumTimeouts
|
"
|
|
Number of Timeouts
|
NumBusies
|
"
|
|
Number of busies
|
NumNoConnections
|
"
|
|
Number of no connections.
|
NumDrops
|
"
|
|
Number of drops.
|
NumSeqErrors
|
"
|
|
Number of sequence errors.
|
NumVerifyErrors
|
"
|
|
Number of verify errors.
|
NumTries
|
"
|
|
Number of tries
|
AvgRTT
|
Numeric(30)
|
|
Average of all RTT
|
StandardDeviation
|
"
|
|
Standard deviation
|
OverThres_Percent
|
"
|
|
Over threshold percentage
|
Error_Percent
|
"
|
|
Error percentage
|
Availability_Percent
|
"
|
|
AvailabilityPercent
|
RTP Minute Statistics Table
Table B-51 RTP Minute Statistics Table
Column Name
|
Type
|
Constraints
|
Description
|
rowID
|
Bigint
|
Not Null
|
Unique identifier
|
CollectorID
|
bigint
|
"
|
Collector (Running Instance) ID.
See collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time
|
RTT
|
Integer
|
Null
|
See MIB object:
rttMonLatestRtpOperRTT
MIB type: Gauge (32 bit)
|
IAJitterDS
|
"
|
"
|
See MIB object:
rttMonLatestRtpOperIAJitterDS
MIB type: Gauge (32 bit)
|
IAJitterSD
|
"
|
"
|
See MIB object:
rttMonLatestRtpOperPacketLossSD
MIB type: Gauge (32 bit)
|
packetLossDS
|
"
|
"
|
See MIB object:
rttMonLatestRtpOperPacketLossDS
MIB type: Gauge (32 bit)
|
packetLossSD
|
"
|
"
|
See MIB object:
rttMonLatestRtpOperPacketLossSD
MIB type: Gauge (32 bit)
|
RFactorDS
|
"
|
"
|
See MIB object:
rttMonLatestRtpOperRFactorDS
MIB type: Gauge (32 bit)
|
RFactorSD
|
"
|
"
|
See MIB object:
rttMonLatestRtpOperRFactorSD
MIB type: Gauge (32 bit)
|
MOSCQDS
|
Numeric(30)
|
"
|
See MIB object:
rttMonLatestRtpOperMOSCQDS
MIB type: Gauge (32 bit)
|
MOSCQSD
|
"
|
"
|
See MIB object:
rttMonLatestRtpOperMOSCQSD
MIB type: Gauge (32 bit)
|
frameLossDS
|
Integer
|
"
|
See MIB object:
rttMonLatestRtpOperFrameLossDS
MIB type: Gauge (32 bit)
|
MOSLQDS
|
Numeric(30)
|
"
|
See MIB object:
rttMonLatestRtpOperMOSLQDS
MIB type: Gauge (32 bit)
|
MIA
|
Integer
|
"
|
See MIB object:
rttMonLatestRtpOperPacketsMIA
MIB type: Gauge (32 bit)
|
totalPacketsDS
|
"
|
"
|
See MIB object:
rttMonLatestRtpOperTotalPaksDS
MIB type: Gauge (32 bit)
|
totalPacketsSD
|
"
|
"
|
See MIB object:
rttMonLatestRtpOperTotalPaksSD
MIB type: Gauge (32 bit)
|
outOfSequenceDS
|
"
|
"
|
Out of sequence of DS
See MIB object:
rttMonLatestRtpOperPacketOOSDS
|
earlyPacketsDS
|
"
|
"
|
Early packets of DS
See MIB object:
rttMonLatestRtpOperPacketEarlyDS
|
latePacketsDS
|
"
|
"
|
See MIB object:
rttMonLatestRtpOperPacketLateDS
MIB type: Gauge (32 bit)
|
RTP Hourly Statistics Table
Table B-52 RTP Hourly Statistics Table
Column Name
|
Type
|
Contraints
|
Description
|
rowID
|
Bigint
|
Not Null
|
Unique identifier
|
CollectorID
|
binint
|
"
|
Collector (Running Instance) ID.
See to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the hourly bucket.
|
MinRTT
|
Integer
|
Null
|
Minimum of RTT.
See MIB object:
rttMonStatsCaptureCompletionTimeMin
MIB type: Gauge (32bit)
|
MaxRTT
|
"
|
"
|
Maximum of RTT.
See MIB object: rttMonRtpStatsRTTMax
MIB type: Gauge (32 bit)
|
AvgRTT
|
Numeric(30,6)
|
"
|
See MIB object: rttMonRtpStatsRTTAvg
MIB type: Gauge (32 bit)
|
IAJitterDSMin
|
Integer
|
|
See MIB object:
rttMonRtpStatsIAJitterDSMin
MIB type: Gauge (32 bit)
|
IAJitterDSMax
|
"
|
|
See MIB object
rttMonRtpStatsIAJitterDSMax
MIB type: Gauge (32 bit)
|
IAJitterDSAvg
|
Numeric(30,6)
|
"
|
See MIB object:
rttMonRtpStatsIAJitterDSAvg
MIB type: Gauge (32 bit)
|
IAJitterSDMin
|
Integer
|
"
|
See MIB object:
rttMonRtpStatsIAJitterSDMin
MIB type: Gauge (32 bit)
|
IAJitterSDMax
|
"
|
"
|
See MIB object:
rttMonRtpStatsIAJitterSDMax
MIB type: Gauge (32 bit)
|
IAJitterSDAvg
|
Numeric(30,6)
|
|
See MIB object:
rttMonRtpStatsIAJitterSDAvg
MIB type: Gauge (32 bit)
|
packetLossDSMin
|
Integer
|
|
See MIB object:
rttMonRtpStatsPacketLossDSMin
MIB type: Gauge (32 bit)
|
packetLossDSMax
|
"
|
"
|
See MIB object:
rttMonRtpStatsPacketLossDSMax
MIB type: Gauge (32 bit)
|
packetLossDSAvg
|
Numeric(30,6)
|
"
|
See MIB object:
rttMonRtpStatsPacketLossDSAvg
MIB type: Gauge (32 bit)
|
packetLossSDMin
|
Integer
|
"
|
See MIB object:
rttMonRtpStatsPacketLossSDMin
MIB type: Gauge (32 bit)
|
packetLossSDMax
|
"
|
"
|
See MIB object:
rttMonRtpStatsPacketLossSDMax
MIB type: Gauge (32 bit)
|
packetLossSDAvg
|
Numeric(30,6)
|
"
|
See MIB object:
rttMonRtpStatsPacketLossSDAvg
MIB type: Gauge (32 bit)
|
RFactorDSMin
|
Integer
|
"
|
See MIB object:
rttMonRtpStatsRFactorDSMin
MIB type: Gauge (32 bit)
|
RFactorDSMax
|
"
|
"
|
See MIB object:
rttMonRtpStatsRFactorDSMax
MIB type: Gauge (32 bit)
|
RFactorDSAvg
|
Numeric(30,6)
|
"
|
See MIB object:
rttMonRtpStatsRFactorDSAvg
MIB type: Gauge (32 bit)
|
RFactorSDMin
|
Integer
|
"
|
See MIB object: rttMonRtpStatsRFactorSDMin
MIB type: Gauge (32 bit)
|
RFactorSDMax
|
"
|
"
|
See MIB object:
rttMonRtpStatsRFactorSDMax
MIB type: Gauge (32 bit)
|
RFactorSDAvg
|
Numeric(30,6)
|
"
|
See MIB object:
rttMonRtpStatsRFactorSDAvg
MIB type: Gauge (32 bit)
|
MOSCQDSMin
|
Integer
|
"
|
See MIB object:
rttMonRtpStatsMOSCQDSMin
MIB type: Gauge (32 bit)
|
MOSCQDSMax
|
"
|
"
|
See MIB object:
rttMonRtpStatsMOSCQDSMax
MIB type: Gauge (32 bit)
|
MOSCQDSAvg
|
Numeric(30,6)
|
"
|
See MIB object:
rttMonRtpStatsMOSCQDSAvg
MIB type: Gauge (32 bit)
|
MOSCQSDMin
|
Integer
|
"
|
See MIB object:
rttMonRtpStatsMOSCQSDMin
MIB type: Gauge (32 bit)
|
MOSCQSDMax
|
"
|
"
|
See MIB object:
rttMonRtpStatsMOSCQSDMax
MIB type: Gauge (32 bit)
|
MOSCQSDAvg
|
Numeric(30,6)
|
"
|
See MIB object:
rttMonRtpStatsMOSCQSDAvg
MIB type: Gauge (32 bit)
|
frameLossDSMin
|
Integer
|
"
|
See MIB object:
rttMonRtpStatsFrameLossDSMin
MIB type: Gauge (32 bit)
|
frameLossDSMax
|
"
|
"
|
See MIB object:
rttMonRtpStatsFrameLossDSMax
MIB type: Gauge (32 bit)
|
frameLossDSAvg
|
Numeric(30,6)
|
"
|
See MIB object:
rttMonRtpStatsFrameLossDSAvg
MIB type: Gauge (32 bit)
|
MOSLQDSMin
|
"
|
"
|
See MIB object:
rttMonRtpStatsMOSLQDSMin
MIB type: Gauge (32 bit)
|
MOSLQDSMax
|
"
|
"
|
See MIB object:
rttMonRtpStatsMOSLQDSMax
MIB type: Gauge (32 bit)
|
MOSLQDSAvg
|
"
|
"
|
See MIB object:
rttMonRtpStatsMOSLQDSAvg
MIB type: Gauge (32 bit)
|
miaAvg
|
"
|
"
|
See MIB object:
rttMonRtpStatsPacketsMIAAvg
MIB type: Gauge (32 bit)
|
totalPacketsDSMin
|
Integer
|
"
|
See MIB object:
rttMonRtpStatsTotalPacketsDSMin
MIB type: Gauge (32 bit)
|
totalPacketsDSMax
|
"
|
"
|
See MIB object:
rttMonRtpStatsTotalPacketsDSMax
MIB type: Gauge (32 bit)
|
totalPacketsDSAvg
|
Numeric(30,6)
|
"
|
See MIB object:
rttMonRtpStatsTotalPacketsDSAvg
MIB type: Gauge (32 bit)
|
totalPacketsSDMin
|
Integer
|
"
|
See MIB object:
rttMonRtpStatsTotalPacketsSDMin
MIB type: Gauge (32 bit)
|
totalPacketsSDMax
|
"
|
"
|
See MIB object:
rttMonRtpStatsTotalPacketsSDMax
MIB type: Gauge (32 bit)
|
totalPacketsSDAvg
|
Numeric(30,6)
|
"
|
See MIB object:
rttMonRtpStatsTotalPacketsSDAvg
MIB type: Gauge (32 bit)
|
outOfSequenceDSAvg
|
"
|
"
|
See MIB object:
rttMonRtpStatsPacketOOSDSAvg
MIB type: Gauge (32 bit)
|
earlyPacketsDSAvg
|
"
|
"
|
See MIB object:
rttMonRtpStatsPacketEarlyDSAvg
MIB type: Gauge (32 bit)
|
latePacketsDSAvg
|
"
|
"
|
See MIB object:
rttMonRtpStatsPacketLateDSAvg
MIB type: Gauge (32 bit)
|
RTP Daily Statistics Table
All the column values other than the Collector ID and Start Time are average values from the hourly table.
Table B-53 RTP Daily Statistics Table
Column Name
|
Type
|
Contraints
|
Description
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID.
See collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the day
|
MinRTT
|
|
|
Average of all MinRTT.
|
MaxRTT
|
|
|
Average of all MaxRTT.
|
AvgRTT
|
|
|
Average of RTT
|
IAJitterDSMin
|
|
|
Minimum of IAJitterDS
|
IAJitterDSMax
|
|
|
Maximum of IAJitterDS
|
IAJitterDSAvg
|
|
|
Average of IAJitterDS
|
IAJitterSDMin
|
|
|
Minimum of IAJitterSD
|
IAJitterSDMax
|
|
|
Maximum of IAJitterSD
|
IAJitterSDAvg
|
|
|
Average of IAJitterSD
|
packetLossDSMin
|
|
|
Minimum of packetLossDS
|
packetLossDSMax
|
|
|
Maximum of packetLossDS
|
packetLossDSAvg
|
|
|
Average of packetLossDS
|
packetLossSDMin
|
|
|
Minimum of packetLossSD
|
packetLossSDMax
|
|
|
Maximum of packetLossSD
|
packetLossSDAvg
|
|
|
Average of packetLossSD
|
RFactorDSMin
|
|
|
Minimum of RFactorDS
|
RFactorDSMax
|
|
|
Maximum of RfactorDS
|
RFactorDSAvg
|
|
|
Average of RfactorDS
|
RFactorSDMin
|
|
|
Minimum of RFactorSD
|
RFactorSDMax
|
|
|
Maximum of RfactorSD
|
RFactorSDAvg
|
|
|
Average of RfactorSD
|
MOSCQDSMin
|
|
|
Minimum of MOSCQDS
|
MOSCQDSMax
|
|
|
Maximum of MOSCQDS
|
MOSCQDSAvg
|
|
|
Average of MOSCQDS
|
MOSCQSDMin
|
|
|
Minimum of MOSCQSD
|
MOSCQSDMax
|
|
|
Maximum of MOSCQSD
|
MOSCQSDAvg
|
|
|
Average of MOSCQSD
|
frameLossDSMin
|
|
|
Minimum of frameLossDS
|
frameLossDSMax
|
|
|
Maximum of frameLossDS
|
frameLossDSAvg
|
|
|
Average of frameLossDS
|
MOSLQDSMin
|
|
|
Minimum of MOSLQDS
|
MOSLQDSMax
|
|
|
Maximum of MOSLQDS
|
MOSLQDSAvg
|
|
|
Average of MOSLQDS
|
miaAvg
|
|
|
Average of MIA
|
totalPacketsDSMin
|
|
|
Minimum of totalPacketsDS
|
totalPacketsDSMax
|
|
|
Maximum of totalPacketsDS
|
totalPacketsDSAvg
|
|
|
Average of totalPacketsDS
|
totalPacketsSDMin
|
|
|
Minimum of totalPacketsSD
|
totalPacketsSDMax
|
|
|
Maximum of totalPacketsSD
|
totalPacketsSDAvg
|
|
|
Average of totalPacketsSD
|
outOfSequenceDSAvg
|
|
|
Average of outOfSequenceDS
|
earlyPacketsDSAvg
|
|
|
Average of earlyPacketsDS
|
latePacketsDSAvg
|
|
|
Average of latePacketsDS
|
RTP Weekly Statistics Table
All the column values other than the collector ID and Start Time are average values from Daily table.
Table B-54 RTP Weekly Statistics Table
Column Name
|
Type
|
Contraints
|
Description
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID
Reference to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the week
|
MinRTT
|
|
|
Average of all MinRTT.
|
MaxRTT
|
|
|
Average of all MaxRTT.
|
AvgRTT
|
|
|
Average of RTT
|
IAJitterDSMin
|
|
|
Minimum of IAJitterDS
|
IAJitterDSMax
|
|
|
Maximum of IAJitterDS
|
IAJitterDSAvg
|
|
|
Average of IAJitterDS
|
IAJitterSDMin
|
|
|
Minimum of IAJitterSD
|
IAJitterSDMax
|
|
|
Maximum of IAJitterSD
|
IAJitterSDAvg
|
|
|
Average of IAJitterSD
|
packetLossDSMin
|
|
|
Minimum of packetLossDS
|
packetLossDSMax
|
|
|
Maximum of packetLossDS
|
packetLossDSAvg
|
|
|
Average of packetLossDS
|
packetLossSDMin
|
|
|
Minimum of packetLossSD
|
packetLossSDMax
|
|
|
Maximum of packetLossSD
|
packetLossSDAvg
|
|
|
Average of packetLossSD
|
RFactorDSMin
|
|
|
Minimum of RFactorDS
|
RFactorDSMax
|
|
|
Maximum of RfactorDS
|
RFactorDSAvg
|
|
|
Average of RfactorDS
|
RFactorSDMin
|
|
|
Minimum of RFactorSD
|
RFactorSDMax
|
|
|
Maximum of RfactorSD
|
RFactorSDAvg
|
|
|
Average of RfactorSD
|
MOSCQDSMin
|
|
|
Minimum of MOSCQDS
|
MOSCQDSMax
|
|
|
Maximum of MOSCQDS
|
MOSCQDSAvg
|
|
|
Average of MOSCQDS
|
MOSCQSDMin
|
|
|
Minimum of MOSCQSD
|
MOSCQSDMax
|
|
|
Maximum of MOSCQSD
|
MOSCQSDAvg
|
|
|
Average of MOSCQSD
|
frameLossDSMin
|
|
|
Minimum of frameLossDS
|
frameLossDSMax
|
|
|
Maximum of frameLossDS
|
frameLossDSAvg
|
|
|
Average of frameLossDS
|
MOSLQDSMin
|
|
|
Minimum of MOSLQDS
|
MOSLQDSMax
|
|
|
Maximum of MOSLQDS
|
MOSLQDSAvg
|
|
|
Average of MOSLQDS
|
miaAvg
|
|
|
Average of MIA
|
totalPacketsDSMin
|
|
|
Minimum of totalPacketsDS
|
totalPacketsDSMax
|
|
|
Maximum of totalPacketsDS
|
totalPacketsDSAvg
|
|
|
Average of totalPacketsDS
|
totalPacketsSDMin
|
|
|
Minimum of totalPacketsSD
|
totalPacketsSDMax
|
|
|
Maximum of totalPacketsSD
|
totalPacketsSDAvg
|
|
|
Average of totalPacketsSD
|
outOfSequenceDSAvg
|
|
|
Average of outOfSequenceDS
|
earlyPacketsDSAvg
|
|
|
Average of earlyPacketsDS
|
latePacketsDSAvg
|
|
|
Average of latePacketsDS
|
RTP Monthly Statistics Table
All the column values other than the collector ID and Start Time are average values from the weekly table.
Table B-55 RTP Monthly Statistics Table
Column Name
|
Type
|
Contraints
|
Description
|
CollectorID
|
Bigint
|
Not Null
|
Collector (Running Instance) ID
See to collector(ID)
|
starttime
|
Timestamp
|
"
|
Start time of the month
|
MinRTT
|
|
|
Average of all MinRTT.
|
MaxRTT
|
|
|
Average of all MaxRTT.
|
AvgRTT
|
|
|
Average of RTT
|
IAJitterDSMin
|
|
|
Minimum of IAJitterDS
|
IAJitterDSMax
|
|
|
Maximum of IAJitterDS
|
IAJitterDSAvg
|
|
|
Average of IAJitterDS
|
IAJitterSDMin
|
|
|
Minimum of IAJitterSD
|
IAJitterSDMax
|
|
|
Maximum of IAJitterSD
|
IAJitterSDAvg
|
|
|
Average of IAJitterSD
|
packetLossDSMin
|
|
|
Minimum of packetLossDS
|
packetLossDSMax
|
|
|
Maximum of packetLossDS
|
packetLossDSAvg
|
|
|
Average of packetLossDS
|
packetLossSDMin
|
|
|
Minimum of packetLossSD
|
packetLossSDMax
|
|
|
Maximum of packetLossSD
|
packetLossSDAvg
|
|
|
Average of packetLossSD
|
RFactorDSMin
|
|
|
Minimum of RFactorDS
|
RFactorDSMax
|
|
|
Maximum of RfactorDS
|
RFactorDSAvg
|
|
|
Average of RfactorDS
|
RFactorSDMin
|
|
|
Minimum of RFactorSD
|
RFactorSDMax
|
|
|
Maximum of RfactorSD
|
RFactorSDAvg
|
|
|
Average of RfactorSD
|
MOSCQDSMin
|
|
|
Minimum of MOSCQDS
|
MOSCQDSMax
|
|
|
Maximum of MOSCQDS
|
MOSCQDSAvg
|
|
|
Average of MOSCQDS
|
MOSCQSDMin
|
|
|
Minimum of MOSCQSD
|
MOSCQSDMax
|
|
|
Maximum of MOSCQSD
|
MOSCQSDAvg
|
|
|
Average of MOSCQSD
|
frameLossDSMin
|
|
|
Minimum of frameLossDS
|
frameLossDSMax
|
|
|
Maximum of frameLossDS
|
frameLossDSAvg
|
|
|
Average of frameLossDS
|
MOSLQDSMin
|
|
|
Minimum of MOSLQDS
|
MOSLQDSMax
|
|
|
Maximum of MOSLQDS
|
MOSLQDSAvg
|
|
|
Average of MOSLQDS
|
miaAvg
|
|
|
Average of MIA
|
totalPacketsDSMin
|
|
|
Minimum of totalPacketsDS
|
totalPacketsDSMax
|
|
|
Maximum of totalPacketsDS
|
totalPacketsDSAvg
|
|
|
Average of totalPacketsDS
|
totalPacketsSDMin
|
|
|
Minimum of totalPacketsSD
|
totalPacketsSDMax
|
|
|
Maximum of totalPacketsSD
|
totalPacketsSDAvg
|
|
|
Average of totalPacketsSD
|
outOfSequenceDSAvg
|
|
|
Average of outOfSequenceDS
|
earlyPacketsDSAvg
|
|
|
Average of earlyPacketsDS
|
latePacketsDSAvg
|
|
|
Average of latePacketsDS
|
s
