Guest

CiscoWorks LAN Management Solution 3.2 and earlier

Open Database Schema Support in CiscoWorks LAN Management Solution 3.2

  • Viewing Options

  • PDF (1.7 MB)
  • Feedback
Open Database Schema Support in CiscoWorks LAN Management Solution 3.2

Table Of Contents

Open Database Schema Support in CiscoWorks LAN Management Solution 3.2

Contents

Enabling Access to Database

Accessing Database Views

Accessing Database From a Local Server

Accessing Database Using Jconnect JDBC Access Method

Accessing Database Using iAnyWhere JDBC Access Method

Accessing Database Using ODBC Access Method

Accessing the Database From a Remote Server

Prerequisites for Accessing Database Views on Windows Systems

Prerequisites for Accessing Database Views on Solaris Systems

Sample Code to Access Database From a Remote Server

Importing data into Microsoft Office Excel using dbviews

Changing the Database Password

Exposed Database Views and Tables

Schema of Exposed Database Views

Network_Devices View Details

Job_Details View Details

End_Hosts View Details

Device_Inventory View Details

Module_Inventory View Details

Port_Inventory View Details

Processor_Inventory View Details

Memory_Inventory View Details

Device_Credential_Status View Details

Device_Inventory_Collection_Status View Details

Device_Config_Archive_Status View Details

Change_Audit_History View Details

Syslog_Today or Syslog_Lastday View Details

Fault_Alert_History View Details

Fault_Event_History View Details

Fault_Event_Details View Details

IPM Database Schema

Connecting to IPM Database

Schema of IPM Database Tables

Source Table

Target Table

IPMDevice Table

Operation Table

IPEchoOper Table

UDPEchoOper Table

PathEchoOper Table

jitter_oper Table

ICMPJitterOper Table

RTPOper Table

ethernet_oper Table

http_oper Table

dns_oper Table

ftp_oper Table

dhcp_oper Table

DLSwOper Table

PostDialDelayOper Table

tcpconnect_oper Table

React Table

Collector Table

VrfList Table

outage_details Table

completed_outages Table

Collector _Schedule Table

Latency_Minute_Stats Table

Availability_Latency_Hourly_Stats Table

Availability_Latency_Daily_Stats Table

Availability_Latency_Weekly_Stats Table

Availability_Latency_Monthly_Stats Table

Jitter_Minute_Stats Table

Jitter_Hourly_Stats Table

Jitter_Daily_Stats Table

Jitter_Weekly_Stats Table

Jitter_Monthly_Stats Table

ICMP_Jitter_Minute_Stats Table

ICMP_Jitter_Hourly_Stats Table

ICMP_Jitter_Daily_Stats Table

ICMP_Jitter_Weekly_Stats Table

ICMP_Jitter_Monthly_Stats Table

Ethernet_Jitter_Minute_Stats Table

Ethernet_Jitter_Hourly_Stats Table

Ethernet_Jitter_Daily_Stats Table

Ethernet_Jitter_Weekly_Stats Table

Ethernet_Jitter_Monthly_Stats Table

Http_Minute_Stats Table

Http_Hourly_Stats Table

Http_Daily_Stats Table

Http_Weekly_Stats Table

Http_Monthly_Stats Table

PATHECHO_Hourly_Stats Table

PATHECHO_Daily_Stats Table

PATHECHO_Weekly_Stats Table

PATHECHO_Monthly_Stats Table

RTP_Minute_Stats Table

RTP_Hourly_Stats Table

RTP_Daily_Stats Table

RTP_Weekly _Stats Table

RTP_Monthly_Stats Table


Open Database Schema Support in CiscoWorks LAN Management Solution 3.2


Contents

This document explains about the open database schema support in CiscoWorks LMS 3.2. This document contains the following sections:

Enabling Access to Database

Accessing Database Views

Exposed Database Views and Tables

Schema of Exposed Database Views

IPM Database Schema

Enabling Access to Database

To enable the access to applications database, you must run the dbaccess.pl utility from the command line.

You must run:

NMSROOT/bin/perl NMSROOT/bin/dbaccess.pl {install|clean} [debug] on Solaris systems

NMSROOT\bin\perl NMSROOT\bin\dbaccess.pl {install|clean} [debug] — on Windows systems

where,

NMSROOT — Default CiscoWorks installation directory

install Command line parameter that cleans the existing views, creates new views and provides access to databases

clean Command line parameter that cleans the existing views

debug Prints the debug and warning messages on the screen

The default database view user name is lmsdatafeed. The CLI utility prompts you to enter the database view password.

You can enter password of length between 5 to 30 characters.

A few warning messages appear while running the utility with the debug option. These messages appear when the view definitions are not in the database.

For example, you may get the following warning messages while the utility enables access to Common Services database:

WARN: User ID 'lmsdatafeed' does not exist (DBD: execute failed).
WARN: Table 'Network_Devices' not found (DBD: execute failed).
WARN: Table 'Job_Details' not found (DBD: execute failed).

You can ignore these warning messages.

See Connecting to IPM Database for details on connecting to the IPM database.

Accessing Database Views

You can access the created views using database access methods such as JDBC and ODBC.

You should use select * from View_Name to access the database views:

You can access the created views either from:

The local CiscoWorks Server.

Or

A remote server with or without CiscoWorks installed.

This section contains:

Accessing Database From a Local Server

Accessing the Database From a Remote Server

Accessing Database From a Local Server

This section contains the sample code for:

Accessing Database Using Jconnect JDBC Access Method

Accessing Database Using iAnyWhere JDBC Access Method

Accessing Database Using ODBC Access Method

Accessing Database Using Jconnect JDBC Access Method

The following is the sample code to connect to the database, using the Jconnect JDBC access method:

import java.util.Date;
import java.sql.*;
public class JdbcAccess {
	private static Connection conn;
	private static Statement stmt;
	private static ResultSet rs;
	/**
	 * @param args
	 */
	public static void main(String[] args) throws SQLException, ClassNotFoundException {
		Class.forName("com.sybase.jdbc2.jdbc.SybDriver");

		// The following information such as port, and service names are to be 	
		// changed based on the application database that you want to connect. 
		// For example, conn = DriverManager.getConnection("jdbc:sybase:Tds:localhost:
		// <ServerPort>?SERVICENAME=<DBName>","<View username>","<View password>");
		conn = DriverManager.getConnection("jdbc:sybase:Tds:localhost:43441? 
SERVICENAME=cmfDb","lmsdatafeed","dbpasswd"); 

		System.out.println("[" + new Date() + "] INFO: Connection successful...");

		//Create Statement now
		stmt = conn.createStatement();
		String query = "SELECT Device_Id, Device_Display_Name, Management_IPAddress FROM 
Network_Devices";
		rs = stmt.executeQuery(query);
		while (rs.next()) {
			System.out.println("Device_Id: " + rs.getString("Device_Id"));
			System.out.println("Device_Display_Name: " + 
rs.getString("Device_Display_Name"));
			System.out.println("Management_IPAddress" + 
rs.getString("Management_IPAddress"));
						
System.out.println("-----------------------------------------------------------");
		}
	}
}

Note This sample code uses the Jconnect JDBC driver. You must include the Jconnect Jar file (NMSROOT/lib/classpath/jconn2.jar) in the CLASSPATH before you connect to the database.


In the code snippet below, you must change the information such as port, service name, dsn names based on the application database that you want to connect to:

conn = DriverManager.getConnection("jdbc:sybase:Tds:localhost:43441?SERVICENAME=cmfDb", 
"lmsdatafeed","dbpasswd"); 

where,

localhost —Local CiscoWorks Server.

43441 — Port number to connect to the database. In this sample, it refers to the port number used to connect to the Common Services database. See Application Database Names and Port Number Details for details on other port numbers to use.

cmfDb — Name of the database service. In this sample, it refers to the Common Services database. See Application Database Names and Port Number Details for details on other port numbers to use.

lmsdatafeed — Default database view username

dbpasswd — Database view password

Application Database Names and Port Number Details

The application database names are given in the table below:

Application
Database Name
Port Number to Connect to Database

Common Services

cmfDb

43441

Campus Manager

aniDb

43443

Resource Manager Essentials

rmengdb

43455

Device Fault Manager
(DFM Fault History)

dfmFhDb

43445


The port number mentioned in the table could vary. You can get the appropriate port numbers from the odbc.tmpl file of respective databases.

Accessing Database Using iAnyWhere JDBC Access Method

The following is the sample code to connect to the database using the iAnyWhere JDBC access method:

The following is the sample code to connect to the database using the iAnyWhere JDBC access method:

import java.util.Date;
import java.sql.*;
public class JdbcAccess {
	private static Connection conn;
	private static Statement stmt;
	private static ResultSet rs;
	/**
	 * @param args
	 */
	public static void main(String[] args) throws SQLException, ClassNotFoundException {
		Class.forName("ianywhere.ml.jdbcodbc.IDriver");

		// DSN names should be changed based on the application database that you want
		// to connect. 

		conn = 
DriverManager.getConnection("jdbc:ianywhere:DSN=cmf","lmsdatafeed","dbpasswd");
		System.out.println("[" + new Date() + "] INFO: Connection successfull...");

		//Create Statement now
		stmt = conn.createStatement();
		String query = "SELECT Device_Id, Device_Display_Name, Management_IPAddress FROM 
Network_Devices";
		rs = stmt.executeQuery(query);
		while (rs.next()) {
			System.out.println("Device_Id: " + rs.getString("Device_Id"));
			System.out.println("Device_Display_Name: " + 
rs.getString("Device_Display_Name"));
			System.out.println("Management_IPAddress" + 
rs.getString("Management_IPAddress"));
						
System.out.println("-----------------------------------------------------------");
		}
	}
}

Note This sample code uses the iAnywhere driver. You must include the jodbc.jar file (NMSROOT/lib/classpath/jodbc.jar) in the CLASSPATH before you connect to the database.


In the code snippet below, you must change the dsn names based on the application database that you want to connect:

conn = DriverManager.getConnection("jdbc:ianywhere:DSN=cmf","lmsdatafeed","dbpasswd"); 

where,

dsn=cmf —Name of the data source. In this sample, the data source name refers to cmf. See Application Data Source Names for details on dsn names to connect to the database.

lmsdatafeed — Default database view username

dbpasswd — Database view password

Application Data Source Names

The following table lists the data source names of CiscoWorks LMS applications whose database views are exposed:

Application
Data Source Name (dsn)

Common Services

cmf

Campus Manager

ani

Resource Manager Essentials

rmeng

Device Fault Manager (DFM Fault History)

dfmFh


Accessing Database Using ODBC Access Method

The following is the sample code to connect to the database using the ODBC access method:

use DBI;
my ($dbh, $cur, $sqlstr);
my $connString = "dsn=cmf;uid=lmsdatafeed";
$dbh = DBI->connect('DBI:ASAny:', $connString, 'dbpasswd', {PrintError => 1});
if ($dbh) {
   my $sqlstr = "SELECT Device_Id, Device_Display_Name, Management_IPAddress FROM 
Network_Devices";
   my $cur = $dbh->prepare($sqlstr);
   $cur->execute if ($cur);
   while (my $rs = $cur->fetchrow_arrayref) {
      my ($devId, $dispName, $ip,) = @$rs;
      print "Device_Id: $devId\n";
      print "Device_Display_Name: $dispName\n";
      print "Management_IPAddress: $ip\n";
      print "--------------------------------------------\n";
   }
   $cur->finish;
   $dbh->disconnect();
}

To run this perl code on CiscoWorks Server:


Step 1 Create a perl file, for example, sample.pl and store it on your CiscoWorks Server.

Step 2 Update the perl file with the sample perl code given above to connect to the database.

Step 3 Save the changes to the perl file.

Step 4 Run the perl script using the following commands:

NMSROOT/bin/perl Perl_file_name (on Solaris systems)

NMSROOT\bin\perl Perl_file_name (on Windows systems)

where,

NMSROOT — CiscoWorks Installation directory.

Perl_file_name —Absolute file name of the perl script with the code to connect to the database.

For example, if you have stored the perl file sample.pl under C:\ in a Windows systems, and if the CiscoWorks installation directory is under D:\CSCOpx you must enter the following to run the perl script:

D:\CSCOpx\bin\perl C:\sample.pl


In the code snippet below, you must change the dsn names based on the application database that you want to connect:

my $connString = "dsn=cmf;uid=lmsdatafeed"; 
$dbh = DBI->connect('DBI:ASAny:', $connString, 'dbpasswd', {PrintError => 1});

where,

dsn=cmf —Name of the data source. In this sample, the data source name refers to cmf. See Application Data Source Names for details on dsn names to connect to the database.

lmsdatafeed — Default database view username

dbpasswd — Database view password

Accessing the Database From a Remote Server

This section explains how to access the database in a CiscoWorks Server from a remote server. It contains:

Prerequisites for Accessing Database Views on Windows Systems

Prerequisites for Accessing Database Views on Solaris Systems

Sample Code to Access Database From a Remote Server

Prerequisites for Accessing Database Views on Windows Systems

Before you access the database views in the CiscoWorks Server, from a remote Windows server, you must:

Copy the CiscoWorks files to the remote Windows server

Create DSNs in the remote Windows server

This section explains:

Copying CiscoWorks files to a Remote Windows Server

Creating DSNs on Windows Systems

Copying CiscoWorks files to a Remote Windows Server

Before you access the database views from a remote Windows server, you must copy the following CiscoWorks files to a directory on the remote server:

NMSROOT\lib\classpath\jconn2.jar

NMSROOT\lib\classpath\jodbc.jar

NMSROOT\objects\db\win32\dbodbc10.dll

NMSROOT\objects\db\win32\dblgen10.dll

NMSROOT\objects\db\win32\dbcon10.dll

If you use Perl on the remote server to access the CiscoWorks database, ensure that you have installed the required Sybase-related perl modules such as DBI and DBD::ASAny.

You can search for the Perl modules DBI and DBD::ASAny in the URL http://www.cpan.org and download them to your remote server.

Creating DSNs on Windows Systems

To create DSNs and configure ODBC on Windows system:


Step 1 Launch the Registry Editor on remote Windows server.

Step 2 Navigate to My Computer\HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI in the registry tree on the left.

Step 3 Click Edit > New > Key to create a new registry key.

Step 4 Rename the newly created registry key as CiscoWorks Embedded Database.

Step 5 Click Edit > New > Expandable String value to create a expandable string value for CiscoWorks Embedded Database key.

Step 6 Enter the name of the expandable string value that you have created as Driver and value data as Location_Name\dbodbc10.dll.

Location_Name denotes the folder name where you have stored the CiscoWorks files.

For example, if you have stored the CiscoWorks files at C:\dbaccess, the value data is C:\dbaccess\dbodbc10.dll.

Step 7 Click Edit > New > Expandable String value to create another expandable string value for CiscoWorks Embedded Database key.

Step 8 Enter the name of the expandable string value that you have created as Setup and value data as Location_Name\dbodbc10.dll.

Location_Name denotes the folder name where you have stored the CiscoWorks files.

For example, if you have stored the CiscoWorks files at C:\dbaccess, the value data is C:\dbaccess\dbodbc10.dll.

Step 9 Navigate to My Computer\HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\ODBC Drivers in the registry tree on the left.

Step 10 Click Edit > New > String value to create a string value for ODBC Drivers key.

Step 11 Enter the value name as CiscoWorks Embedded Database and value data as Installed.

Step 12 Click File > Exit to quit the Registry Editor.

Step 13 Click Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC) on Windows system.

The ODBC Data Source Administrator dialog box appears.

Step 14 Click the System DSN tab.

Step 15 Click the Add... button.

The Create Data Source dialog box appears with the list of drivers for which you want to set up data sources.

Step 16 Select CiscoWorks Embedded Database and click Finish.

The ODBC Configuration for SQL Anywhere 10 dialog box appears.

Step 17 Enter the name of the data source to which you want to connect, to in the Data source name field.

For example, if you want to connect to the Common Services database, you must enter the data source name as cmf. See Application Data Source Names for details on dsn names to connect to the database.

Step 18 Enter a brief description of the data source in the Description field.

Step 19 Click the Login tab in the ODBC Configuration for SQL Anywhere 10 dialog box.

Step 20 Enter the username to connect to the database view in the User ID field.

The default database view user name is lmsdatafeed.

Step 21 Enter the password to connect to the database view in the Password field.

Step 22 Click the Database tab of the ODBC Configuration for SQL Anywhere 10 dialog box.

Step 23 Enter the name of the application database engine in the Server Name field.

See Application Database Engine Name Details for details on the application engine names to enter.

Step 24 Select the Stop database after last disconnect checkbox if you need to stop the database after the connections are removed.

Step 25 Click the Network tab.

Step 26 Enter HOST=Host_name;DOBROADCAST=NO;ServerPort=App_DB_Port in the TCP/IP field.

where,

Host_name — Denotes the hostname or IP Address of the remote CiscoWorks Server which you want to connect to.

App_DB_Port— Denotes the port number that is used to connect to the application database. See Application Database Names and Port Number Details for details on other port numbers to use.

For example, to connect to Common Services application in the CiscoWorks Server whose IP Address is 10.77.213.130, you must enter the following in the TCP/IP field.

HOST=10.77.213.130;DOBROADCAST=NO;ServerPort=43441

Step 27 Click OK to go back to Create DataSource Dialog box.

Step 28 Click OK to apply the changes.


Application Database Engine Name Details

The following table lists the data engine names of CiscoWorks LMS applications whose database views are exposed:

Application
Database Engine Name

Common Services

cmfEng

Campus Manager

aniEng

Resource Manager Essentials

rmengEng

Device Fault Manager (DFM Fault History)

dfmFhEng


Prerequisites for Accessing Database Views on Solaris Systems

Before you access the database views on the CiscoWorks Server, from a remote Windows server, you must:

Copy the CiscoWorks files to a remote Solaris server

Create DSNs on a remote Solaris server

This section explains:

Copying CiscoWorks files to a Remote Solaris Server

Creating DSNs on Solaris Systems

Copying CiscoWorks files to a Remote Solaris Server

Before you access the database views from a remote Solaris server, you must copy the following CiscoWorks files to a directory on the remote server:

NMSROOT/lib/classpath/jconn2.jar

NMSROOT/lib/classpath/jodbc.jar

NMSROOT/objects/db/lib32/libdbodbc10.so.1

NMSROOT/objects/db/lib32/libdblib10.so.1

If you use Perl on the remote server to access the CiscoWorks database, ensure that you have installed the required Sybase-related perl modules such as DBI and DBD::ASAny.

You can search for the Perl modules DBI and DBD::ASAny in the URL http://www.cpan.org and download them to your remote server.

Creating DSNs on Solaris Systems

To create DSNs on Solaris systems:


Step 1 Create a configuration file .odbc.ini under the directory /opt.

Step 2 Add the following content to the .odbc.ini configuration file:

[Application Name]

EngineName=Name_of _the _Application_Engine

PWD=Password

CommLinks=tcpip{HOST=CiscoWorks_Server_Name;DOBROADCAST=NO;ServerPort=Application_Port_Number}

Driver=NMSRoot/objects/db/lib32/libdbodbc10.so.1

UID=Default_Database_View_User_Name

Description=CiscoWorks Embedded Database

where,

CiscoWorks_Server_Name— Default CiscoWorks installation directory.

Application Name — Name of the application database which you want to connect to.

Name_of _the _Application_Engine — Name of the application engine. See Application Database Engine Name Details for details on the application engine names to enter.

Password — Password used to connect to the database

CiscoWorks_Server_NameHostname or IP Address of the remote CiscoWorks Server which you want to connect to

Application_Port_NumberPort number that is used to connect to the application database. See Application Database Names and Port Number Details for details on other port numbers to use.

Database_View_User_NameDatabase view user name. The default username is lmsdatafeed.

For example, to add the DSN for Common Services application in the CiscoWorks server whose IP Address is 10.77.213.130, you must add the following lines to /opt/.odbc.ini configuration file.

[cmf]

EngineName=cmfEng

PWD=cisco

CommLinks=tcpip{HOST=10.77.213.130;DOBROADCAST=NO;ServerPort=43441}

Driver=/opt/CSCOpx/objects/db/lib32/libdbodbc10.so.1

UID=lmsdatafeed

Description=CiscoWorks Embedded Database

You can add multiple DSNs for other CiscoWorks application in the /opt/.odbc.ini file.

Step 3 Set the environmental variable ODBCINI to point to the /opt/.odbc.ini file by running the following command:

setenv ODBCINI /opt/.odbc.ini


Sample Code to Access Database From a Remote Server

After you have copied the required files from CiscoWorks Server to remote server and created DSNs, you can access the CiscoWorks database from a remote server.

See the following sections for the sample code to access the CiscoWorks database:

Accessing Database Using Jconnect JDBC Access Method

Accessing Database Using iAnyWhere JDBC Access Method

Accessing Database Using ODBC Access Method

Importing data into Microsoft Office Excel using dbviews

To import data into Microsoft Office Excel using DbViews


Step 1 Open a new worksheet in Microsoft Excel.

Step 2 Choose Data > Import External Data > New Database Query

Step 3 Select the required DSN name

Step 4 Select Views from Table Options

Click OK

Step 5 Select the table from the list of tables annmsd columns and the columns required.

Click Next

Step 6 Filter the data to specify which rows to include in your query if required

Click Next

Step 7 Specify how the data should be sorted if required.

Click Next

Step 8 Select Return to Microsoft Office Excel.

Click Finish

Step 9 Select the appropriate range in the Excel worksheet to import the data

Click Ok


For importing data into Microsoft Excel from a remote server


Step 1 Copy the following CiscoWorks files to a directory on the local directory:

NMSROOT/objects/db/charsets

NMSROOT/objects/db/java

NMSROOT/objects/db/java/objects/db/scripts

NMSROOT/objects/db/win32

Step 2 Create a new DSN for exporting data to Microsot Office Excel. See Creating DSNs on Windows Systems

Step 3 Click the Login tab in the ODBC Configuration for SQL Anywhere 10 dialog box.

Step 4 Enter the username to connect to the database view in the User ID field.

The default database view user name is lmsdatafeed.

Step 5 Enter the password to connect to the database view in the Password field.

Step 6 Click the Database tab of the ODBC Configuration for SQL Anywhere 10 dialog box.

Step 7 Go to Step 3 of the previous section and continue till Step 9


Changing the Database Password

While installing CiscoWorks, the installer prompts you to enter the database password. If you do not enter the password, CiscoWorks generates the password at random.

However, we recommend that you change the password periodically to ensure system security.

You must use the dbpasswd.pl utility to change the database password.

See the following URL for detailed explanation on changing the database passwords on Windows Systems, changing the database passwords on Solaris systems, and the formats available for changing the database passwords:

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_common_services_software/3.3/user/guide/admin.html#wp602532

Exposed Database Views and Tables

Table 1 lists the database views or tables that are exposed in CiscoWorks applications.

Table 1 Exposed Database Views and Tables

CiscoWorks Application
Name of Views or Tables

Common Services (CS) Views

Network_Devices

Job_Details

Campus Manager (CM) Views

End_Hosts

Device Fault Manager (DFM) Views

Fault_Alert_History

Fault_Event_History

Fault_Event_Details

Resource Manager Essentials (RME) Views

Device_Inventory

Module_Inventory

Port_Inventory

Processor_Inventory

Memory_Inventory

Device_Credential_Status

Device_Inventory_Collection_Status

Device_Config_Archive_Status

Change_Audit_History

Syslog_Today

Syslog_Lastday

Internetwork Performance Monitor (Tables)

Source (Source Table)

Target (Target Table)

IPMDevice (IPM Device Table )

IPEchoOper (IPEcho Sub-Operation Table)

UDPEchoOper (UDP Echo Sub-Operation Table)

PathEchoOper (PathEcho Sub-Operation Table)

jitter_oper (Jitter Sub-Operation Table)

ICMPJitterOper (ICMP Jitter Sub-Operation Table)

RTPOper (RTP Sub-Operation Table)

ethernet_oper (Ethernet Sub-Operation Table)

http_oper (HTTP Operation Table)

dns_oper (DNS Operation Table)

ftp_oper (FTP Operation Table)

dhcp_oper (DHCP Operation Table)

DLSwOper (DLSw Operation Table)

PostDialDelayOper (Post Dial Delay Operation Table)

tcpconnect_oper (TcpConnect Operation Table)

ReactTable (React Table)

Collector (Collector Table)

VrfList (VRF List Table)

outage_details (Outage Details Table)

completed_outages (Completed Outage Table)

Collector_Schedule (Collector Schedule Table)

Latency_Minute_Stats (Latency Minute Statistics Table)

Availability_Latency_Hourly_Stats (Availability Latency Hourly Statistics Table)

Internetwork Performance Monitor (Tables)

(continued)

Availability_Latency_Daily_Stats (Availability Latency Daily Statistics Table)

Availability_Latency_Weekly_Stats (Availability Latency Weekly Statistics Table0

Availability_Latency_Monthly_Stats (Availability Latency Monthly Statistics Table)

Jitter_Minute_Stats (Jitter Minute Statistics Table)

Jitter_Hourly_Stats (Jitter Hourly Statistics Table )

Jitter_Daily_Stats (Jitter Daily Statistics Table)

Jitter_Weekly_Stats (Jitter Weekly Statistics Table)

Jitter_Monthly_Stats (Jitter Monthly Statistics Table)

ICMP_Jitter_Minute_Stats (ICMP Jitter Minute Statistics Table)

ICMP_Jitter_Hourly_Stats (ICMP Jitter Hourly Statistics Table)

ICMP_Jitter_Daily_Stats (ICMP Jitter Daily Statistics Table)

ICMP_Jitter_Weekly_Stats (ICMP Jitter Weekly Statistics Table)

ICMP_Jitter_Monthly_Stats (ICMP Jitter Monthly Statistics Table)

Ethernet_Jitter_Minute_Stats (Ethernet Jitter Minute Statistics Table)

Ethernet_Jitter_Hourly_Stats (Ethernet Jitter Hourly Statistics Table)

Ethernet_Jitter_Daily_Stats (Ethernet Jitter Daily Statistics Table)

Ethernet_Jitter_Weekly_Stats (Ethernet Jitter Weekly Statistics Table)

Ethernet_Jitter_Monthly_Stats (Ethernet Jitter Monthly Statistics Table)

Http_Minute_Stats (HTTP Minute Statistics Table)

Http_Hourly_Stats (HTTP Hourly Statistics Table)

Http_Daily_Stats (HTTP Daily Statistics Table)

Http_Weekly_Stats (HTTP Weekly Statistics Table)

Http_Monthly_Stats (HTTP Monthly Statistics Table)

PATHECHO_Hourly_Stats (Pathecho Hourly Statistics Table)

PATHECHO_Daily_Stats (Pathecho Daily Statistics Table)

PATHECHO_Weekly_Stats (Pathecho Weekly Statistics Table)

Internetwork Performance Monitor (Tables)

(continued)

PATHECHO_Monthly_Stats (Pathecho Monthly Statistics Table)

RTP_Minute_Stats (RTP Minute Statistics Table)

RTP_Hourly_Stats (RTP Hourly Statistics Table)

RTP_Daily_Stats (RTP Daily Statistics Table)

RTP_Weekly_Stats (RTP Weekly Statistics Table )

RTP_Monthly_Stats (RTP Monthly Statistics Table)


Schema of Exposed Database Views

This section explains the exposed tables, the fields in each table, the type of fields and a brief description.


Note The column names in the exposed database views are case insensitive.


It contains the details of the following views:

Network_Devices View Details

Job_Details View Details

End_Hosts View Details

Device_Inventory View Details

Module_Inventory View Details

Port_Inventory View Details

Processor_Inventory View Details

Memory_Inventory View Details

Device_Credential_Status View Details

Device_Inventory_Collection_Status View Details

Device_Config_Archive_Status View Details

Change_Audit_History View Details

Syslog_Today or Syslog_Lastday View Details

Fault_Alert_History View Details

Fault_Event_History View Details

Fault_Event_Details View Details

Network_Devices View Details

Network_Devices view displays the network devices information, as explained in Table 2.

Table 2 Network_Devices Schema Details

Column Name
Column Type
Constraints
Column Description

Device_Id

integer

PRIMARY

DCR Device ID. Unique Identifier to the device

Device_Display_Name

varchar(128)

Not Null

Device Display Name

Management_Ip_Address

varchar(128)

Null

Management IP Address of the device

Host_Name

varchar(128)

Null

Hostname of the device

Domain_Name

varchar(128)

Null

Domain Name of the device

sysObjectID

varchar(128)

Null

SysObjectId of the device

Device_Category

varchar(512)

Null

Device category

Device_Series

varchar(512)

Null

Device Series name

Device_Model

varchar(512)

Null

Device Model name

UDF0-15

varchar(128)

Null

A maximum of 16 user-defined fields are allowed.

The first field name isUDF$FieldNumber

For example, UDF0.


Job_Details View Details

Job_Details view displays the Job details information, as explained in Table 3.

.

Table 3 Job_Details Schema Details 

Column Name
Column Type
Constraints
Column Description

Job_Id

integer

PRIMARY

Job_Id, and Job_Instance_Id columns form a Primary key.

Job ID

Job_Instance_Id

integer

PRIMARY

Job_Id, and Job_Instance_Id columns form a Primary key.

Job Instance ID

Job_Type

varchar(256)

Not null

Type of job

Job_Description

varchar(1024)

Null

Job description entered by user or application

Job_Sch_Type

integer

Not null

Frequency of the job.

Options include:

Run immediately

Run once

Run on a calendar basis (periodic)

Run on a time-start basis

Run on a time-stop basis

The integer values are:

0 — Never Ran

1 — Immediate

2 — Run Once

257 — Day of Every Month

258 — Day of Every Week

259 — Every N-th Day

260 — Last week day (Sunday, Monday, or so on) of every N-th month

261 — Same week day (Sunday, Monday, or so on) of every N-th month

262 — last day of month every N-th month

263 — Weekdays (Sun,Mon,..Sat)

513 — Every N-Seconds (Start time based)

514 — Every N-Min (Start time based)

515 — Every N-hour (Start time based)

769 — Every N-Seconds (End time based)

770 — Every N-Min (End time based)

771— Every N-hour (End time based)

Job_Run_State

integer

Not null

Describes the current state or the result of the last run of the job.

The integer values are:

0 — Scheduled (Never Ran), Missed start, Suspended, Rejected

1 — Running

2 — Succeeded

3 — Succeeded with info

4 —Failed

5 — Crashed

6 — Failed at Start

7 — Cancelled

8 — Cancelled (for Instances)

9 — Cancelling (Job cancellation in progress)

Job_Sch_State

integer

Not null

Determines whether the job can be scheduled to run. This is based on whether it is enabled, requires approval, or has already been approved.

The integer values are:

0 — Waiting

1 — Requires Approval

2 — Enabled

4 — Approved

8 — Rejected

Job_Start_Time

timestamp

Null

Job Start Time

Job_End_Time

timestamp

Null

Job End Time

Job_Owner

varchar(32)

Null

Owner of the Job

Job_Approver

varchar(32)

Null

User who approved the job.

Value is blank if there is no approver.

Job_Progress

varchar(1024)

Null

Job Progress String.


End_Hosts View Details

The End_Hosts view displays the end host details from Campus Manager application, as explained in Table 4.

Table 4 End_Hosts Schema Details 

Column Name
Column Type
Constraints
Column Description

HostName

varchar(64)

Null

Name of the end host

UserName

varchar(64)

Null

Logged In User name

IPAddress

varchar(15)

Null

IP Address of the end host

SubnetMask

varchar(15)

Null

Subnet mask of the device to which end host is connected

MACAddress

varchar(17)

Null

MAC Address of the end host

DeviceName

varchar(64)

Null

Device Name (Host Name) to which the end host is connected

Device

varchar(15)

Null

Device IP Address to which the end host is connected

LastSeen

varchar(32)

Null

Time at which end host is last seen

Port

varchar(32)

Null

Name of the port where the end host is connected

VLAN

varchar(32)

Null

VLAN name.

Example: VLAN100

Subnet

varchar(15)

Null

Subnet of the device to which end host is connected

Notes

varchar(255)

Null

Notes entered by the user

PrefixLength

integer

Null

Subnet prefix length

PortDuplex

varchar(32)

Null

Mode of the port to where end host is connected

VTPDomain

varchar(32)

Null

VTP Domain Name of the device where the end host is connected.

VlanId

integer

Null

VLAN ID

Example: 100

PortName

varchar(255)

Null

Port Description entered by the user

IPv6Address

varchar(150)

Null

IPV6 address, if configured

dot1xEnabled

varchar(15)

Null

dot1x enabled status.

The value could be True or False.

associatedRouters

varchar(250)

Null

Comma separated list of routers in the subnet


Device_Inventory View Details

This view displays the device inventory information from RME, as explained in Table 5.

Table 5 Device Inventory Schema Details  

Column Name
Column Type
Constraints
Column Description

Device_Id

integer

Not null

DCR Device ID

Device_Display_Name

varchar(128)

Not null

Device Display Name

Device_Description

varchar(255)

Null

Description of the device

Device_Location

varchar(255)

Null

Sys Location

Device_Contact

varchar(255)

Null

Sys Contact

Device_SW_Version

varchar(64)

Null

Device Software Version

User_Defined_Serial_Number

varchar(255)

Null

User-defined serial number


Module_Inventory View Details

This view displays the module inventory information from RME, as explained in Table 6.

Table 6 Module_Inventory Schema Details

Column Name
Column Type
Constraints
Column Description

Device_Id

integer

Not null

DCR Device ID

Device_Display_Name

varchar(128)

Not null

Device Display Name

Module_Name

varchar(255)

Null

Module

Vendor_Type

varchar(255)

Null

Module Vendor Type

SW_Version

varchar(255)

Null

Software version of the module

FW_Version

varchar(255)

Null

Firmware version of the module

Slot_Number

integer

Null

Slot Number of this module

Oper_Status

smallint

Null

Operation Status

Admin_Status

smallint

Null

Administrative status


Port_Inventory View Details

This view displays the physical port inventory information from RME, as explained in Table 7.

Table 7 Port_Inventory Schema Details  

Column Name
Column Type
Constraints
Column Description

Device_Id

integer

Not null

DCR Device ID

Device_Display_Name

varchar(128)

Not null

Device Display Name

Port_Name

varchar(255)

Null

Name of Port from ifName

Port_Desc

varchar(1024)

Null

Port description from ifDescr

Port_Type

smallint

Null

Port type.

Enumeration from IANAifType MIB

Port_Admin_Status

smallint

Null

Port Administrative status

Port_Oper_Status

smallint

Null

Port Operation status

Port_Speed

float

Null

Port Speed in bits per second

Port_Duplex_Mode

varchar(15)

Null

Port Duplex Mode

Is_Link_Port

smallint

Null

0 — Configured as Link port

1— Not configured as Link port.

Is_Access_Port

smallint

Null

0 — Configured as Access port

1— Not configured as Access port.

Is_Trunk_Port

smallint

Null

0 — Configured as Trunk port

1— Not configured as Trunk port.

Is_Port_Channel

smallint

Null

0 - If etherchannels is configured and 1 otherwise

Vlan_Name

varchar(36)

Null

VLAN Name.

Example: VLAN100

VlanId

integer

Null

VLAN ID.

Example: 100d

VTPDomain

varchar(64)

Null

VTP Domain configured

Neighbour_Type

varchar(36)

Null

Neighbour Type.

Examples: Device, EndHost, Phone


Processor_Inventory View Details

This view displays the processor inventory information from RME, as explained in Table 8.

Table 8 Processor_Inventory Schema Details

Column Name
Column Type
Constraints
Column Description

Device_Id

Integer

Not null

DCR Device ID

Device_Display_Name

varchar(128)

Not null

Device Display Name

Processor_model_name

varchar(255)

Null

Processor Model Name, if available

Processor_module_description

varchar(255)

Null

Module description

Processor_vendor_type

varchar(255)

Null

Vendor equipment type of processor

Processor_manufacturer

varchar(255)

Null

Manufacturer, if available

serialnumber

varchar(255)

Null

Serial Number, if available


Memory_Inventory View Details

The Memory_Inventory view displays the processor memory information., as explained in Table 9

Table 9 Memory_Inventory Schema Details

Column Name
Column Type
Constraints
Column Description

Device_Id

Integer

Not null

DCR Device ID

Device_Display_Name

varchar(128)

Not null

Device Display Name

Processor_Memory

numeric(29,9)

Null

Processor memory.

This is in Mega Bytes (MB).


.

Device_Credential_Status View Details

The Device_Credential_Status view displays the end host details, as explained in Table 10.

This is used to store the RME device credential check information. This information is available only if the CDA reports have been run.

Table 10 Device_Credential_Status Schema Details 

Column Name
Column Type
Constraints
Column Description

Device_Id

integer

PRIMARY

DCR Device ID

Device_Display_Name

varchar(128)

Not null

Device Display Name

Credential_Type

smallint

Not null

Credential Type.

The types could be:

SNMP Read Write community

SNMP Read Only

SNMPv3

Telnet

Telnet Enable mode

SSH

SSH Enable mode

Credential_Type_Description

varchar(64)

Not null

Description of the credentials mentioned in the Credential_Type column description.

Credential_Status

smallint

Not null

Credential Check Status.

The integer values could be:

1 — OK

12 — Cannot test RW without RO

11 — OK (Primary Failed, Secondary Successful)

10 — OK (Primary Successful)

9 — Not implemented yet

8 — Failed (Because of wrong credentials)

7 — Not supported

6 — No Value to Test

5 — Did Not Try

4 — No Data Yet

3— Incorrect (unable to test the credentials because of connection failure)

2— No authentication configured

Cred_Status_Description

varchar(64)

Not null

Description of the credential check status.

Cred_Status_Reason

varchar(1024)

Null

Reason for sucess or failure.

Status_Update_Time

varchar(60)

Null

Time (in milliseconds) at which the credentials are verified and updated.


Device_Inventory_Collection_Status View Details

The Device_Inventory_Collection_Status view displays the RME Inventory collection status details, as explained in Table 11.

Table 11 Device_Inventory_Collection_Status Schema Details

Column Name
Column Type
Constraints
Column Description

Device_Id

integer

PRIMARY

DCR Device ID

Device_Display_Name

varchar(128)

Not null

Device Display Name

Inventory_Collection_Status

integer

Null

Inventory Collection Status

1— Success

2— Failed

Failure_Reason

varchar(255)

Null

Reason for inventory connection failure.

Value is blank if the connection did not fail.

Inventory_Updated_At

timestamp

Null

Time when the inventory is last updated


Device_Config_Archive_Status View Details

The Device_Config_Archive_Status view displays the RME Config Archive status details, as explained in Table 12.

Table 12 Device_Config_Archive_Status Schema Details

Column Name
Column Type
Constraints
Column Description

Device_Id

integer

Not Null

Device_Id, Config_ Type and Config_File_Type columns form a Primary key.

DCR Device ID

Device_Display_Name

varchar(128)

Not null

Device Display Name

Config_Type

integer

Not Null

Device_Id, Config_ Type and Config_File_Type columns form a Primary key.

The integer values could be:

1 — Primary

2 — VLAN

3 — Secondary

Config_File_Type

integer

Not Null

Device_Id, Config_ Type and Config_File_Type columns form a Primary key.

The integer values could be:

1 - STARTUP

2 - RUNNING

Archive_Status

integer

Null

Status of the Configuration archive.

The integer values could be:

1 — Success

2 — Failure

3 — Partially Successful

Archive_Updated_At

timestamp

Null

Time when the Config is last updated


Change_Audit_History View Details

The Change_Audit_History view displays the RME Change Audit History details, as explained in Table 13.

Table 13 Change_Audit_History Schema Details

Column Name
Column Type
Constraints
Column Description

Device_Id

integer

Not null

DCR Device ID

Device_Display_Name

varchar(128)

Not null

Device Display Name

Created_At

timestamp

Null

Date and time when the application communicated the network change or when Change Audit module received the change record.

User_Name

varchar(64)

Null

User who made the configuration change or discovered that there is a configuration change

App_Name

varchar(64)

Null

Application that discovered the configuration change.

Archive Mgmt, ConfigEditor, CwConfig, ICServer, NetConfig, Software Management are the possible values for application names.

Host_Name

varchar(64)

Null

Host name of the machine from which the user accessed the device or the host name of the RME server.

The host name can containthe IP Address if the address does not resolve to a name.

The ICServer application enters the host name and the Config Archive application enters the IP Address of the server

Conn_Mode

varchar(255)

Null

Connection mode through which the change was made.

SNMP, TFTP, TELNET, and CONSOLE are the possible values for connection modes

Description

varchar(1024)

Null

Change Audit description that explains which process has changed the configuration.

Category

varchar(64)

Null

Type of change.

The values for this column could be:

CONFIG_CHANGE

INVENTORY_CHANGE

SOFTWARE_CHANGE


Syslog_Today or Syslog_Lastday View Details

The Syslog_Today or Syslog_Lastdayview displays the RME Syslog details , as explained in Table 14.

These view are created everyday to reflect the current day and the previous days Syslog details.

Table 14 Syslog Schema Details

Column Name
Column Type
Constraints
Column Description

Device_Display_Name

varchar(128)

Not null

Device Display Name

Syslog_Message_Id

bigint

PRIMARY

Primary key

Syslog_Device_Id

bigint

Null

DCR device ID

Syslog_Device_Name

varchar(255)

Not null

The IP Address of the interface through which the syslog was sent.

Syslog_TimeStamp

timestamp

Null

Date and time the message was logged. This timestamp is provided by the device.

Syslog Analyzer provides a timestamp if the device does not provide one.

Syslog_Facility

char(48)

Null

Facility can be a hardware device, a protocol, or a module of the system software.

For example, SYS.

See the System Error Messages section in the Cisco IOS reference manual for a predefined list of facility codes.

Syslog_SubFacility

char(48)

Null

SubFacility is the subfacility in the device that generated the Syslog message.

In most cases, this is blank.

For example, SYS-5-CONFIG I.

Syslog_Severity

char(1)

Null

Message severity level.

The level varies from informational (6) to emergency (0).

Syslog_Mnemonic

char(48)

Null

Code that uniquely identifies the error message.

Older Catalyst messages do not display a mnemonic.

An example of a mnemonic for an IOS message is CONFIG I.

Syslog_Description

varchar(512)

Null

Syslog message description

Syslog_Category

char(1)

Null

Syslog category


Fault_Alert_History View Details

The Fault_Alert_History view exposes the DFM fault alert history details, as explained in Table 15.

Table 15 Fault_Alert_History Schema Details

Column Name
Column Type
Constraints
Column Description

Device_Name

varchar(255)

Null

Device name or IP address.

Alert_Id

bigint

Not null

Alert identifier number

Alert_Category

varchar(255)

Null

Alert category.

Possible values for this field could be:

Application

Connectivity

Environment

Interface

Other

Reachability

System Hardware

Utilization

Status

varchar(16)

Null

Alert status, based on last polling. The status could be:

Active — Alert is alive

Cleared — Alert is no longer live. Also, when a device is suspended, all alerts are cleared.

Acknowledged — Alert was manually recognized by a user

Severity

varchar(16)

Null

Alert severity. The severity can be Critical, or Informational.

Alert_Update_Time

bigint

Null

Date and time when the alert was generated.

The time is the number of seconds elapsed from Jan 1 1970


Fault_Event_History View Details

The Fault_Event_History view displays the DFM fault event history details , as explained in Table 16.

Event List from DFM Contains the list of events for an alert.

Table 16 Fault_Event_History Schema Details

Column Name
Column Type
Constraints
Column Description

Device_Name

varchar(255)

Null

Device name or IP address.

Event_Id

bigint

Not null

Event identifier number.

Alert_Id

bigint

Not null

Alert identifier number

Event_Name

varchar(255)

Null

DFM event name.

See the DFM Online help for the list of events processed by DFM.

Event_Status

varchar(16)

Null

Event status, based on last polling.

The status could be:

Active — Event is live.

Cleared — Event is no longer live.

Events on suspended devices are moved to Cleared, but the alert remains active.

Suspended — Device is suspended.

Resumed — Device is being resumed.

Deleted — Device has been deleted

Component_Name

varchar(255)

Null

Device element on which the event occurred.

Event_Update_Time

bigint

Null

Time at which the event occurred.

The time is the number of seconds elapsed from Jan 1 1970


Fault_Event_Details View Details

The Fault_Event_History view displays the DFM fault event details , as explained in Table 17.

Event Details from DFM contains the properties and details of the event. Each event may have multiple property and the number of property is dependent on event type. So each property is represented as one row.

For example, if the event has five properties, there will be five rows for that event.

Table 17 Fault_Event_History Schema Details

Column Name
Column Type
Constraints
Column Description

Event_Id

bigint

Not null

Event identifier number

Event_Property_Name

varchar(32)

Null

Name of the property

Event_Property_Value

varchar(255)

Null

Property value


IPM Database Schema

The IPM database schema defines the tables, fields in each table and the relationships between fields and tables.

The IPM database schema details are updated after installing the application and launching the same. You do not need to run the dbaccess.pl utility to see the schema details.

Connecting to IPM Database

To connect to the IPM database, you may have to enter the following information:

Username — DBA

Database password — You must enter the database password that you have provided while installing CiscoWorks

To change the database password, see the Changing the Database Password section.

Database name — ipm

Database source name — ipm

Database engine name — ipmEng

Port number to connect to IPM database —The default port number is:

43280 in IPM 4.2 (with LMS 3.2) release

49157 in IPM 4.0.x and IPM 4.1.x releases

Schema of IPM Database Tables

This chapter contains the following tables:

Source Table

Target Table

IPMDevice Table

IPEchoOper Table

UDPEchoOper Table

PathEchoOper Table

jitter_oper Table

ICMPJitterOper Table

RTPOper Table

ethernet_oper Table

http_oper Table

dns_oper Table

ftp_oper Table

dhcp_oper Table

DLSwOper Table

PostDialDelayOper Table

tcpconnect_oper Table

React Table

Collector Table

VrfList Table

outage_details Table

completed_outages Table

Collector _Schedule Table

Latency_Minute_Stats Table

Availability_Latency_Hourly_Stats Table

Availability_Latency_Daily_Stats Table

Availability_Latency_Weekly_Stats Table

Availability_Latency_Monthly_Stats Table

Jitter_Minute_Stats Table

Jitter_Hourly_Stats Table

Jitter_Daily_Stats Table

Jitter_Weekly_Stats Table

Jitter_Monthly_Stats Table

ICMP_Jitter_Minute_Stats Table

ICMP_Jitter_Hourly_Stats Table

ICMP_Jitter_Daily_Stats Table

ICMP_Jitter_Weekly_Stats Table

ICMP_Jitter_Monthly_Stats Table

Ethernet_Jitter_Minute_Stats Table

Ethernet_Jitter_Hourly_Stats Table

Ethernet_Jitter_Daily_Stats Table

Ethernet_Jitter_Weekly_Stats Table

Ethernet_Jitter_Monthly_Stats Table

Http_Minute_Stats Table

Http_Hourly_Stats Table

Http_Daily_Stats Table

Http_Weekly_Stats Table

Http_Monthly_Stats Table

PATHECHO_Hourly_Stats Table

PATHECHO_Daily_Stats Table

PATHECHO_Weekly_Stats Table

PATHECHO_Monthly_Stats Table

RTP_Minute_Stats Table

RTP_Hourly_Stats Table

RTP_Daily_Stats Table

RTP_Weekly _Stats Table

RTP_Monthly_Stats Table

Source Table

The Source table is given in Table 18.

Table 18 Source Table  

Column Name
Type
Constraints
Description

DeviceID

Bigint

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 occurred 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

LastRebootTime

timestamp

Not null

Last reboot time of the source device



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

The Target table is given in Table 19.

Table 19 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


Target Table (table name Target) contains all 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.

IPMDevice Table

The IPM Device Table is given in Table 20.

Table 20 IPMDevice 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

Operation Table (table name `Operation') contains general parameters for an operation, such as frequency, rtt type, threshold type,and so on.

For parameters associated with a 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.

IPEchoOper Table

The IPEchoOper table details is explained in Table 21

Table 21 IPEchoOper 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


UDPEchoOper Table

The UDPEchoOper table is given in Table 22.

Table 22 UDPEchoOper 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.


PathEchoOper Table

The PathEchoOper table is given in Table 23.

Table 23 PathEchoOper 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_oper Table

The jitter_oper table is given in Table 24.

Table 24 jitter_oper Table  

Column Name
Type
Constraints
Description

OperationID

Bigint

Not Null

Reference to operation(ID)

sampleinterval

Bigint

Not Null

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


ICMPJitterOper Table

The ICMPJitterOper table is given in Table 25.

Table 25 ICMPJitterOper 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


RTPOper Table

The RTP Sub Operation table is given in Table 26.

Table 26 RTPOper 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_oper Table

The Ethernet Sub Operation table is given in Table 27.

Table 27 ethernet_oper 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_oper Table

The HTTP Operation table is given in Table 28.

Table 28 http_oper 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, 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_oper Table

The DNS Operation table is given in Table 29.

Table 29 dns_oper 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_oper Table

The FTP Operation table is given in Table 30.

Table 30 ftp_oper 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_oper Table

The DHCP Operation table is given in Table 31

Table 31 dhcp_oper 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


DLSwOper Table

The DLSw Operation Table is given in Table 32

Table 32 DLSwOper 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


PostDialDelayOper Table

The Post Dial Delay Operation table is given in Table 33.

Table 33 PostDialDelayOper 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_oper Table

The TcpConnect Operation table is given in Table 34

Table 34 tcpconnect_oper 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

The React table is given in Table 35.

Table 35 ReactTable

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 threshold 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

The Collector table is given in Table 36.

Table 36 Collector Table

Column Name
Type
Constraints
Description

ID

Bigint

IDENTITY,

Primary key

Unique identifier for collector

Name

Varchar(255)

Null

Collector Name

descr

Varchar(255)

Null

Description

SourceID

Varchar(50)

Null

Source.

Reference to source(ID)

SourceIntAddr

Varchar(50)

Null

Source interface address

TargetID

Varchar(50)

Null

Target.

Reference to target(ID)

OperationID

Varchar(50)

Null

Operation.

Reference to operation (ID)

ScheduleID

bigint

Null

ScheduleID of the collector

Reference to the Collector Schedule (ID).

Owner

Varchar(255)

Null

Owner

Status

Integer

Null

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

Integer

Null

Previous Statistics of the collector

StatusInfo

Varchar(255)

Null

Statistics information of the collector

AdminIndex

Integer

Null

Entry number assigned for this collector in the SAA agent

Tag

Varchar(255)

Null

Name of the collector to be sent to device (15 char limit)

OpType

Integer

Null

Operation type for this collector.

This information is duplicated in the Type column in the Operation table.

CollectorType

Integer

Null

Collector type:

2 = Monitored.

1 = Statistical. Historical statistical data will be collected and saved into database.

PollInterval

bigint

Null

Polling interval

OpName

Varchar(255)

Null

Operation name

SourceAddress

Varchar(50)

Null

IP Address or HostName of source device from DCR_device_detail of CMF table.

TargetAddress

Varchar(50)

Null

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.

VrfName

varchar(255)

Not null

Vrf Name for the collector

LastModified

timestamp

Not null

Last modified time of the collector


VrfList Table

The VRF List table is given in Table 37.

Table 37 VrfList Table  

Column Name
Type
Constraints
Description

deviceid

bigint

Composite primary key.

Notnull

Source device ID

vrfName

Varchar(255)

Composite primary key .

Not null

VRF name of the source device


outage_details Table

The Outage Details table is given

Table 38 outage_details Table

Column Name
Type
Contraints
Description

outage_id

integer

Not null

Outage ID

start_date

biginit

Not null

Start date of the outage

start_time

timestamp

Not null

The time when the outage is scheduled to begin

end_date

biginit

Not null

End date of the outage

end_time

timestamp

Not null

The time when the outage is schedule to end

rec_type

varchar(32)

Not null

The type of recurrence such as once, weekly, monthly

rec_on

smallinit

Not null

The day when the outage re-occurs.

For example, if you want the outage to occur again for all days of a week, select all the days in a week.

outage_name

varchar (255)

Not null

Name of the outage

description

varchar (255)

Not null

The details of the outage


Table 38.

completed_outages Table

The Completed Outages table is given in Table 39

Table 39 completed_outages Table

Column
Type
Constraints
Description

Outage Id

Integer

Not null

Outage Id

Collector Id

biginit

Not null

Collector id of the outage

Start Date Time

timestamp

Not null

Start date and time for the outage period

EndDate Time

timestamp

Not null

End date and time for the outage period


Collector _Schedule Table

The Collector Schedule table is given in Table 40

Table 40 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

Null

Start date of the collector.

The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM

startTime

Timestamp

Null

Start time of the collector

endDate

bigint

Null

End date

The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM

endTime

Timestamp

Null

End time

daysOfWeek

Integer

Null

Days of week for polling

suspendedTimestamp

bigint

Null

Suspended time period

The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM

resumeTimestamp

bigint

Null

Resume time period

The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM


Latency_Minute_Stats Table

The Latency Minute Statistics table in given in Table 41.

Table 41 Latency_Minute_Stats 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_Stats Table

The Availability Latency Hourly Statistics table is given in Table 42.

Table 42 Availability_Latency_Hourly_Stats 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:

rttMonStatsCaptureCompletion-

TimeMin

MIB type:

Gauge32

Minimum RTT

MaxRTT

Integer

Not Null

Maximum of RTT.

See MIB object:

rttMonStatsCaptureCompletion

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

NumNo

Connections

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

NumSeq

Errors

Integer

Not Null

See MIB object:

rttMonStatscollectSequence
Errors

MIB type:

Integer32(0..2147483647)

Number of Sequence Errors

NumVerify

Errors

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)

Not Nul

Over threshold percentage

Error_Percent

Numeric(30)

Not Nul

Error percentage

Availability_
Percent

Numeric(30)

Not Nul

Availability Percent


Availability_Latency_Daily_Stats Table

All the column values other than the Collector ID and Start Time are average values from the hourly table. See Table 43.

Table 43 Availability_Latency_Daily_Stats Table  

Column Name
Type
Constraints
Description

CollectorID

Bigint

IDENTITY,

Primary key

Collector (Running Instance) ID.

Reference to collector(ID)

Start Time

date

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_Stats Table

All the column values other than the collector ID and Start Time are average values from Daily table. See Table 44.

Table 44 Availability_Latency_Weekly_Stats Table  

Column Name
Type
Constraints
Description

CollectorID

Bigint

IDENTITY,

Primary key

Collector (Running Instance) ID.

Reference to collector(ID)

starttime

date

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.

NumOver

Thresholds

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.

NumNo

Connections

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_Stats Table

All the column values other than the collector ID and Start Time are average values from the weekly table.

Table 45 Availability_Latency_Monthly_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

IDENTITY,

Primary key

Collector (Running Instance) ID.

Reference to collector(ID)

starttime

date

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.

NumOver

Thresholds

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.

NumNo

Connections

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


See Table 45.

Jitter_Minute_Stats Table

The Jitter Minute Statistics table is given in Table 46.

Table 46 Jitter_Minute_Stats 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

Bigint

Not Null

Start time.

The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM

MinRTT

Integer

Not Null

See MIB object:

rttMonLatestJitterOperRTTMin

MIB type: Gauge (32 bit)

MaxRTT

Integer

Not Null

See MIB object:

rttMonLatestJitterOperRTTMax

MIB type: Gauge (32 bit)

NumRTT

Integer

Not Null

See MIB object:

rttMonLatestJitterOperNumOfRTT

MIB type: Gauge (32 bit)

SumRTT

Integer

Not Null

See MIB object:

rttMonLatestJitterOperRTTSum

MIB type: Gauge (32 bit)

SumRTT2

Double

Not Null

See MIB object:

rttMonLatestJitterOperRTTSum2

MIB type: Gauge (32 bit)

minofposisd

Integer

Not Null

See MIB object:

rttMonLatestJitterOperMin

Of PositivesSD

MIB type: Gauge (32 bit)

maxofposisd

Integer

Not Null

See MIB object:

rttMonLatestJitterOperMax
OfPositivesDS

MIB type: Gauge (32 bit)

numofposisd

Integer

Not Null

See MIB object:

rttMonLatestJitterOperNumOf
PositivesSD

MIB type: Gauge (32 bit)

sumofposisd

Integer

Not Null

See MIB object:

rttMonLatestJitterOperSumOf
PositivesSD

MIB type: Gauge (32 bit)

sum2posisd

Double

Not Null

See MIB object:

rttMonLatestJitterOperSum2
PositivesSD

MIB type: Gauge (32 bit)

minofnegasd

Integer

Not Null

See MIB object:

rttMonLatestJitterOperMinOf
NegativesSD

MIB type: Gauge (32 bit)

maxofnegasd

Integer

Not Null

See MIB object:

rttMonLatestJitterOperMaxOf
NegativesSD

MIB type: Gauge (32 bit)

numofnegasd

Integer

Not Null

See MIB object:

rttMonLatestJitterOperNumOf
NegativesSD

MIB type: Gauge (32 bit)

sumofnegasd

Integer

Not Null

See MIB object:

rttMonLatestJitterOperSumOf
NegativesSD

MIB type: Gauge (32 bit)

sum2negasd

Double

Not Null

See MIB object:

rttMonLatestJitterOperSum2
NegativesSD

MIB type: Gauge (32 bit)

minofposids

Integer

Not Null

See MIB object:

rttMonLatestJitterOperMinOf
PositivesDS

MIB type: : Gauge (32 bit)

maxofposids

Integer

Not Null

See MIB object:

rttMonLatestJitterOperMaxOf
PositivesDS

MIB type: : Gauge (32 bit)

numofposids

Integer

Not Null

See MIB object:

rttMonLatestJitterOperNumOf
PositivesDS

MIB type: : Gauge (32 bit)

sumofposids

Integer

Not Null

See MIB object:

rttMonLatestJitterOperSumOf
PositivesDS

MIB type: : Gauge (32 bit)

sum2posids

Double

Not Null

See MIB object:

rttMonLatestJitterOperSum2
PositivesDS

MIB type: : Gauge (32 bit)

minofnegads

Integer

Not Null

See MIB object:

rttMonLatestJitterOperMinOf
NegativesDS

MIB type: : Gauge (32 bit)

maxofnegads

Integer

Not Null

See MIB object:

rttMonLatestJitterOperMaxOf
NegativesDS

MIB type: : Gauge (32 bit)

numofnegads

Integer

Not Null

See MIB object: rttMonLatestJitterOperNumOf
NegativesDS

MIB type: : Gauge (32 bit)

sumofnegads

Integer

Not Null

See MIB object: rttMonLatestJitterOperSumOf
NegativesDS

MIB type: : Gauge (32 bit)

sum2negads

Double

Not Null

See MIB object: rttMonLatestJitterOperSum2
NegativesDS

MIB type: : Gauge (32 bit)

numpacketlosssd

Integer

Not Null

See MIB object: rttMonLatestJitterOperPacket
LossSD

MIB type: : Gauge (32 bit)

numpacketlossds

Integer

Not Null

See MIB object: rttMonLatestJitterOperPacket
LossDS

MIB type: : Gauge (32 bit)

numpacketseqerr

Integer

Not Null

See MIB object: rttMonLatestJitterOperPacketOut
OfSequence

MIB type: : Gauge (32 bit)

numpacketmia

Integer

Not Null

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)

Null

Average of positive from Source to Destination (SD)

StdDevPosSD

Numeric(30)

Null

Standard deviation of positive SD

AvgNegSD

Numeric(30)

Null

Average of negative SD

StdDevNegSD

Numeric(30)

Null

Standard deviation of negative SD

AvgPosDS

Numeric(30)

Null

Average of positive DS

StdDevPosDS

Numeric(30)

Null

Standard deviation of positive DS

AvgNegDS

Numeric(30)

Null

Average of negative DS

StdDevNegDS

 

Null

Standard deviation of negative DS

StdDevRTT

Numeric(30)

Null

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_Stats Table

The Jitter Hourly Statistics table is given in Table 47.

Table 47 Jitter_Hourly_Stats 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 for this hourly bucket

MinRTT

Integer

Not Null

See MIB object: rttMonJitterStatsRTTMin

MIB type: Gauge (32 bit)

MaxRTT

Integer

Not Null

See MIB object: rttMonJitterStatsRTTMax

MIB type: Gauge (32 bit)

NumRTT

Integer

Not Null

See MIB object: rttMonJitterStatsNumOfRTT

MIB type: Gauge (32 bit)

SumRTT

Integer

Not Null

See MIB object: rttMonJitterStatsRTTSum

MIB type: Gauge (32 bit)

SumRTT2

Double

Not Null

See MIB object:

rttMonJitterStatsRTTSum2Low

and MIB object:

rttMonJitterStatsRTTSum2High

Accumulated RTT Squares

minofposids

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsMinOfPositivesSD

MIB type:

Gauge32

The minimum of absolute values

of all positive jitter values from

packets sent from destination to source.

maxofposisd

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsMaxOfPositivesSD

MIB type:

Gauge32

The maximum of absolute values

of all positive jitter values

from packets sent from destination to

source.

numofposisd

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsNumOfPositivesSD

MIB type:

Gauge32

The sum of number of all positive

jitter values from packets

sent from destination to source.

sumofposisd

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsSumOfPositivesSD

MIB type:

Counter32

The sum of all positive jitter values

from packets sent from

destination to source.

sum2posisd

Double

Not Null

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 destination to source.

minofnegasd

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsMinOfNegativesSD

MIB type:

Gauge32

The minimum of absolute values

of all negative jitter values from

packets sent from destination to source.

maxofnegasd

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsMaxOfNegativesSD

MIB type:

Gauge32

The maximum of absolute values

of all negative jitter values

from packets sent from from destination to source.

numofnegasd

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsNumOfNegativesSD

MIB type:

Gauge32

The sum of number of all negative

jitter values from packets

sent from destination to source.

sumofnegasd

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsSumOfNegativesSD

MIB type:

Counter32

The sum of all negative jitter

values from packets sent from

source to destination

sum2negasd

Double

Not Null

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 destination to source.

minofposids

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsMinOfPositivesDS

MIB type:

Gauge32

The minimum of absolutevalues of all positive jitter values from packets sent from destination to source.

maxofposids

Integer

Not Null

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

Not Null

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

Not Null

Refer to MIB object:

rttMonJitterStatsSumOfPositivesDS

MIB type:

Counter32

The sum of all positive jitter values from packets sent from destination to source.

sum2posids

Double

Not Null

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

Not Null

Refer to MIB object:

rttMonJitterStatsMinOfNegativesDS

MIB type:

Gauge32

The minimum of absolute values of all negative jitter values from packets sent from source to destination

maxofnegads

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsMaxOfNegativesDS

MIB type:

Gauge32

The maximum of absolute values of all negative jitter values from packets sent from source to destination

numofnegads

Integer

Not Null

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

Not Null

Refer to MIB object:

rttMonJitterStatsSumOfNegativesDS

MIB type:

Counter32

The sum of all negative jitter

values from packets sent from

destination to source

sum2negads

Double

Not Null

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

Not Null

Refer to MIB object:

rttMonJitterStatsCompletions

MIB type:

Counter32

Number of RTTs completed

numoverthresh

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsOverThresholds

MIB type:

Counter32

Number of OverThresholds

numpacketlossds

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsPacketLossSD

MIB type:

Counter32

The number of packets lost when

sent from destination to source.

numpacketlossds

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsPacketLossDS

MIB type:

Counter32

The number of packets lost when

sent from destination to source.

numpacketseqerr

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsPacketOutOf-

Sequence

MIB type:

Counter32

The number of packets arrived

out of sequence

numpacketmia

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsPacketMIA

MIB type:

Counter32

The number of packets that are

lost for which we cannot determine

the direction

numpacketlate

Integer

Not Null

Refer to MIB object:

rttMonJitterStatsPacketLateArrival

MIB type:

Counter32

The number of packets that

arrived after the timeout

NumJitterStatsErrors

Integer

Not Null

Refer mib object : rttMonJitterStatsError

Mib type : Counter (32 bit)

numerror

Integer

Not Null

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

Not Null

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)

Not Null

Average of RTT

Error_Percent

Numeric(30)

Not Null

Error percent

NumTries

Integer

Not Null

Number of tries

AvgPosSD

Numeric(30)

Not Null

Average of positive SD

StdDevPosSD

Numeric(30)

Not Null

Standard deviation of positive SD

AvgNegSD

Numeric(30)

Not Null

Average of negative SD

StdDevNegSD

Numeric(30)

Not Null

Standard deviation negative SD

AvgPosDS

Numeric(30)

Not Null

Average of positive DS

StdDevPosDS

Numeric(30)

Not Null

Standard deviation of positive DS

AvgNegDS

Numeric(30)

Not Null

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

Not Null

Max of MOS

minicpif

Integer

Not Null

Min of icpif

maxicpif

Integer

Not Null

Max of icpif


Jitter_Daily_Stats Table

All the column values other than the Collector ID and Start Time are average values from the hourly table. See Table 48.

Table 48 Jitter_Daily_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID.

Reference to collector(ID)

starttime

date

Not Null

Start time of the day

MinRTT

Integer

Not Null

Average of all Min RTT

MaxRTT

Integer

Not Null

Average of all Max RTT

NumRTT

Integer

Not Null

Number of RTT's that are successfully

measured

SumRTT

Integer

Not Null

Accumulated RTTs

SumRTT2

Double

Not Null

Accumulated RTT Squares

minofposisd

Integer

Not Null

Minimum of positive SD

maxofposisd

Integer

Not Null

Maximum of positive SD

numofposisd

Integer

Not Null

Number of positve SD

sumofposisd

Integer

Not Null

Sum of positive SD

sum2posisd

Double

Not Null

Sum squared of positive SD

minofnegasd

Integer

Not Null

Minimum of negative SD

maxofnegasd

Integer

Not Null

Maximum of negative SD

numofnegasd

Integer

Not Null

Number of negative SD

sumofnegasd

Integer

Not Null

Sum of negative SD

sum2negasd

Double

Not Null

Sum squared of negative SD

minofposids

Integer

Not Null

Minimum of positive DS

maxofposids

Integer

Not Null

Maximum of positive DS

numofposids

Integer

Not Null

Number of positive DS

sumofposids

Integer

Not Null

Sum of positive DS

sum2posids

Double

Not Null

Sum squared of positive DS

minofnegads

Integer

Not Null

Minimum of nagative DS

maxofnegads

Integer

Not Null

Maximum of negative DS

numofnegads

Integer

Not Null

Number of negative DS

sumofnegads

Integer

Not Null

Sum of negative DS

sum2negads

Double

Not Null

Sum squared of negative DS

numcomplete

Integer

Not Null

Number of completions

numoverthresh

Integer

Not Null

Number of overthreshold

numpacketlosssd

Integer

Not Null

Number of packet loss SD

numpacketlossds

Integer

Not Null

Number of packet loss DS

numpacketseqerr

Integer

Not Null

Number of error packets

numpacketmia

Integer

Not Null

Number of packet MIA

numpacketlate

Integer

Not Null

Number of late packets

NumJitterStatsErrors

Integer

Not Null

Number of JitterStatsErrors

numerror

Integer

Not Null

Numerror

numbusy

Integer

Not Null

Numbusy

AvgRtt

Numeric(30)

Not Null

Average RTT

Error_Percent

Numeric(30)

Not Null

Error percentage

NumTries

Integer

Not Null

Number of tries

AvgPosSD

Numeric(30)

Not Null

Average of positive SD

StdDevPosSD

Numeric(30)

Not Null

Standared deviation of positive SD

AvgNegSD

Numeric(30)

Not Null

Average of negative SD

StdDevNegSD

Numeric(30)

Not Null

Standared deviation of negative SD

AvgPosDS

Numeric(30)

Not Null

Average of positive DS

StdDevPosDS

Numeric(30)

Not Null

Standared deviation of positive DS

AvgNegDS

Numeric(30)

Not Null

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

Not Null

Max MOS

minicpif

Integer

Not Null

Min ICPIF

maxicpif

Integer

Not Null

Max ICPIF


Jitter_Weekly_Stats Table

All the column values other than the collector ID and Start Time are average values from Daily table. See Table 49.

.

Table 49 Jitter_Weekly_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID.

Reference to collector(ID)

starttime

date

Not Null

Start time of the week

MinRTT

Integer

Not Null

Average of all Min RTT

MaxRTT

Integer

Not Null

Average of all Max RTT

NumRTT

Integer

Not Null

Number of RTT's that are successfully

measured

SumRTT

Integer

Not Null

Accumulated RTTs

SumRTT2

Double

Not Null

Accumulated RTT Squares

minofposisd

Integer

Not Null

Minimum of positive SD

maxofposisd

Integer

Not Null

Maximum of positive SD

numofposisd

Integer

Not Null

Number of positve SD

sumofposisd

Integer

Not Null

Sum of positive SD

sum2posisd

Double

Not Null

Sum squared of positive SD

minofnegasd

Integer

Not Null

Minimum of negative SD

maxofnegasd

Integer

Not Null

Maximum of negative SD

numofnegasd

Integer

Not Null

Number of negative SD

sumofnegasd

Integer

Not Null

Sum of negative SD

sum2negasd

Double

Not Null

Sum squared of negative SD

minofposids

Integer

Not Null

Minimum of positive DS

maxofposids

Integer

Not Null

Maximum of positive DS

numofposids

Integer

Not Null

Number of positive DS

sumofposids

Integer

Not Null

Sum of positive DS

sum2posids

Double

Not Null

Sum squared of positive DS

minofnegads

Integer

Not Null

Minimum of nagative DS

maxofnegads

Integer

Not Null

Maximum of negative DS

numofnegads

Integer

Not Null

Number of negative DS

sumofnegads

Integer

Not Null

Sum of negative DS

sum2negads

Double

Not Null

Sum squared of negative DS

numcomplete

Integer

Not Null

Number of completions

numoverthresh

Integer

Not Null

Number of overthreshold

numpacketlosssd

Integer

Not Null

Number of packet loss SD

numpacketlossds

Integer

Not Null

Number of packet loss DS

numpacketseqerr

Integer

Not Null

Number of error packets

numpacketmia

Integer

Not Null

Number of packet MIA

numpacketlate

Integer

Not Null

Number of late packets

NumJitterStatsErrors

Integer

Not Null

Number of JitterStatsErrors

numerror

Integer

Not Null

Numerror

numbusy

Integer

Not Null

Numbusy

AvgRtt

Numeric(30)

Not Null

Average RTT

Error_Percent

Numeric(30)

Not Null

Error percentage

NumTries

Integer

Not Null

Number of tries

AvgPosSD

Numeric(30)

Not Null

Average of positive SD

StdDevPosSD

Numeric(30)

Not Null

Standared deviation of positive SD

AvgNegSD

Numeric(30)

Not Null

Average of negative SD

StdDevNegSD

Numeric(30)

Not Null

Standared deviation of negative SD

AvgPosDS

Numeric(30)

Not Null

Average of positive DS

StdDevPosDS

Numeric(30)

Not Null

Standared deviation of positive DS

AvgNegDS

Numeric(30)

Not Null

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

Not Null

Max MOS

minicpif

Integer

Not Null

Min ICPIF

maxicpif

Integer

Not Null

Max ICPIF


Jitter_Monthly_Stats Table

All the column values other than the collector ID and Start Time are average values from the weekly table. See Table 50.

Table 50 Jitter_Monthly_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID.

Reference to collector(ID)

starttime

date

Not Null

Start time of the monthly

MinRTT

Integer

Not Null

Average of all Min RTT

MaxRTT

Integer

Not Null

Average of all Max RTT

NumRTT

Integer

Not Null

Number of RTT's that are successfully

measured

SumRTT

Integer

Not Null

Delay in the polling interval of collectors.

SumRTT2

Double

Not Null

Accumulated RTT Squares

minofposisd

Integer

Not Null

Minimum of positive SD

maxofposisd

Integer

Not Null

Maximum of positive SD

numofposisd

Integer

Not Null

Number of positve SD

sumofposisd

Integer

Not Null

Sum of positive SD

sum2posisd

Double

Not Null

Sum squared of positive SD

minofnegasd

Integer

Not Null

Minimum of negative SD

maxofnegasd

Integer

Not Null

Maximum of negative SD

numofnegasd

Integer

Not Null

Number of negative SD

sumofnegasd

Integer

Not Null

Sum of negative SD

sum2negasd

Double

Not Null

Sum squared of negative SD

minofposids

Integer

Not Null

Minimum of positive DS

maxofposids

Integer

Not Null

Maximum of positive DS

numofposids

Integer

Not Null

Number of positive DS

sumofposids

Integer

Not Null

Sum of positive DS

sum2posids

Double

Not Null

Sum squared of positive DS

minofnegads

Integer

Not Null

Minimum of nagative DS

maxofnegads

Integer

Not Null

Maximum of negative DS

numofnegads

Integer

Not Null

Number of negative DS

sumofnegads

Integer

Not Null

Sum of negative DS

sum2negads

Double

Not Null

Sum squared of negative DS

numcomplete

Integer

Not Null

Number of completions

numoverthresh

Integer

Not Null

Number of overthreshold

numpacketlosssd

Integer

Not Null

Number of packet loss SD

numpacketlossds

Integer

Not Null

Number of packet loss DS

numpacketseqerr

Integer

Not Null

Number of error packets

numpacketmia

Integer

Not Null

Number of packet MIA

numpacketlate

Integer

Not Null

Number of late packets

NumJitterStatsErrors

Integer

Not Null

Number of JitterStatsErrors

numerror

Integer

Not Null

Numerror

numbusy

Integer

Not Null

Numbusy

AvgRtt

Numeric(30)

Not Null

Average RTT

Error_Percent

Numeric(30)

Not Null

Error percentage

NumTries

Integer

Not Null

Number of tries

AvgPosSD

Numeric(30)

Not Null

Average of positive SD

StdDevPosSD

Numeric(30)

Not Null

Standared deviation of positive SD

AvgNegSD

Numeric(30)

Not Null

Average of negative SD

StdDevNegSD

Numeric(30)

Not Null

Standared deviation of negative SD

AvgPosDS

Numeric(30)

Not Null

Average of positive DS

StdDevPosDS

Numeric(30)

Not Null

Standared deviation of positive DS

AvgNegDS

Numeric(30)

Not Null

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

Not Null

Max MOS

minicpif

Integer

Not Null

Min ICPIF

maxicpif

Integer

Not Null

Max ICPIF


ICMP_Jitter_Minute_Stats Table

The ICMP Jitter Minute Statistics table is given in Table 51.

Table 51 ICMP_Jitter_Minute_Stats 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

Starttime

MinRTT

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterRTTMin

MIB type: Gauge (32 bit)

MaxRTT

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterRTTMax

MIB type: Gauge (32 bit)

NumRTT

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterNumRTT

MIB type: Gauge (32 bit)

SumRTT

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterRTTSum

MIB type: Gauge (32 bit)

SumRTT2

Double

Not Null

See MIB object:

rttMonLatestIcmpJitterRTTSum2

MIB type: Gauge (32 bit)

minofposisd

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterMinPosSD

MIB type: Gauge (32 bit)

maxofposisd

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterMaxPosSD

MIB type: Gauge (32 bit)

numofposisd

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterNumPosSD

MIB type: Gauge (32 bit)

sumofposisd

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterSumPosSD

MIB type: Gauge (32 bit)

sum2posisd

Double

Not Null

See MIB object:

rttMonLatestIcmpJitterSum2PosSD

MIB type: Gauge (32 bit)

minofnegasd

Not Null

Not Null

See MIB object:

rttMonLatestIcmpJitterMinNegSD

MIB type: Gauge (32 bit)

maxofnegasd

Not Null

Not Null

See MIB object:

rttMonLatestIcmpJitterMaxNegSD

MIB type: Gauge (32 bit)

numofnegasd

Not Null

Not Null

See MIB object:

rttMonLatestIcmpJitterNumNegSD

MIB type: Gauge (32 bit)

sumofnegasd

Not Null

Not Null

See MIB object:

rttMonLatestIcmpJitterSumNegSD

MIB type: Gauge (32 bit)

sum2negasd

Double

Not Null

See MIB object:

rttMonLatestIcmpJitterSum2NegSD

MIB type: Gauge (32 bit)

minofposids

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterMinPosDS

MIB type: Gauge (32 bit)

maxofposids

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterMaxPosDS

MIB type: Gauge (32 bit)

numofposids

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterNumPosDS

MIB type: Gauge (32 bit)

sumofposids

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterSumPosDS

MIB type: Gauge (32 bit)

sum2posids

Double

Not Null

See MIB object:

rttMonLatestIcmpJitterSum2PosDS

MIB type: Gauge (32 bit)

minofnegads

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterMinNegDS

MIB type: Gauge (32 bit)

maxofnegads

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterMaxNegDS

MIB type: Gauge (32 bit)

numofnegads

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterNumNegDS

MIB type: Gauge (32 bit)

sumofnegads

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterSumNegDS

MIB type: Gauge (32 bit)

sum2negads

Double

Not Null

See MIB object:

rttMonLatestIcmpJitterSum2NegDS

MIB type: Gauge (32 bit)

numPktLoss

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterPktLoss

MIB type: Counter (32 bit)

numPktOutSeqBoth

Integer

Not Null

See MIB object:

rttMonLatestIcmpJPktOutSeqBoth

MIB type: Counter (32 bit)

numPktOutSeqSDes

Integer

Not Null

See MIB object:

rttMonLatestIcmpJPktOutSeqSD

MIB type: Counter (32 bit)

numPktOutSeqDSes

Integer

Not Null

See MIB object:

rttMonLatestIcmpJPktOutSeqDS

MIB type: Counter (32 bit)

numPktSkippeds

Integer

Not Null

unused

numPktLateAs

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterPktLateA

MIB type: Counter (32 bit)

minSuccPktLoss

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterMinSucPktL

MIB type: Gauge (32 bit)

maxSuccPktLoss

Integer

Not Null

See MIB object:

rttMonLatestIcmpJitterMaxSucPktL

MIB type: Gauge (32 bit)

AvgRTT

Numeric(30,6)

Null

Average of RTT

AvgPosSD

Numeric(30,6)

Null

Average of positive SD

StdDevPosSD

Numeric(30,6)

Null

Standard deviation of positive SD

AvgNegSD

Numeric(30,6)

Null

Average of negative SD

StdDevNegSD

Numeric(30,6)

Null

Standard deviation of negative SD

AvgPosDS

Numeric(30,6)

Null

Average of positive DS

StdDevPosDS

Numeric(30,6)

Null

Standard deviation of positive DS

AvgNegDS

Numeric(30,6)

Null

Average of negative DS

StdDevNegDS

Numeric(30,6)

Null

Standard deviation of negative DS

StdDevRTT

Numeric(30,6)

Null

Standard deviation of RTT


ICMP_Jitter_Hourly_Stats Table

The ICMP Jitter Hourly Statistics table is given in Table 52

Table 52 ICMP_Jitter_Hourly_Stats Tabl;e

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 hourly bucket

MinRTT

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsRTTMin

MIB type: Gauge (32 bit)

MaxRTT

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsRTTMax

MIB type: Gauge (32 bit)

NumRTT

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsNumRTTs

MIB type: Gauge (32 bit)

SumRTT

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsRTTSums

MIB type: Gauge (32 bit)

SumRTT2

Double

Not Null

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

Not Null

See MIB object: rttMonIcmpJitterStatsMinPosSD

MIB type: Gauge (32 bit)

maxofposisd

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsMaxPosSD

MIB type: Gauge (32 bit)

numofposisd

Integer

Not Null

See MIB object:

rttMonIcmpJitter
StatsNumPosSDs

MIB type: Gauge (32 bit)

sumofposisd

Integer

Not Null

See MIB object:

rttMonIcmpJitter
StatsSumPosSDs

MIB type: Gauge (32 bit)

sum2posisd

Double

Not Null

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

Not Null

See MIB object:

rttMonIcmpJitterStatsMinNegSD

MIB type: Gauge (32 bit)

maxofnegasd

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsMaxNegSD

MIB type: Gauge (32 bit)

numofnegasd

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsNumNegSDs

MIB type: Gauge (32 bit)

sumofnegasd

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsSumNegSDs

MIB type: Gauge (32 bit)

sum2negasd

Double

Not Null

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

Not Null

See MIB object:

rttMonIcmpJitterStatsMinPosDS

MIB type: Gauge (32 bit)

maxofposids

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsMaxPosDS

MIB type: Gauge (32 bit)

numofposids

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsNumPosDSes

MIB type: Gauge (32 bit)

sumofposids

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsSumPosDSes

MIB type: Gauge (32 bit)

sum2posids

Double

Not Null

See MIB object:

minofnegads

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsMinNegDS

MIB type: Gauge (32 bit)

maxofnegads

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsMaxNegDS

MIB type: Gauge (32 bit)

numofnegads

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsNumNegDSes

MIB type: Gauge (32 bit)

sumofnegads

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsSumNegDSes

MIB type: Gauge (32 bit)

sum2negads

Double

Not Null

 

numcomplete

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsCompletions

MIB type: Counter (32 bit)

numoverthresh

Integer

Not Null

See MIB object:

rttMonIcmpJStatsOverThresholds

MIB type: Counter (32 bit)

numPktLoss

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsPktLosses

MIB type: Counter (32 bit)

numPktOutSeqBoth

Integer

Not Null

See MIB object:

rttMonIcmpJStatsPktOutSeqBoth

MIB type: Counter (32 bit)

numPktOutSeqSDes

Integer

Not Null

See MIB object:

rttMonIcmpJStatsPktOutSeqSDs

MIB type: Counter (32 bit)

numPktOutSeqDSes

Integer

Not Null

See MIB object:

rttMonIcmpJStatsPktOutSeqDSes

MIB type: Counter (32 bit)

numPktSkippeds

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsPktSkippeds

MIB type: Counter (32 bit)

numPktLateAs

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsPktLateAs

MIB type: Counter (32 bit)

minSuccPktLoss

Integer

Not Null

See MIB object:

rttMonIcmpJitterMinSucPktLoss

MIB type:gauge(32)

maxSuccPktLoss

Integer

Not Null

See MIB object:

rttMonIcmpJitterMaxSucPktLoss

MIB type:gauge(32)

numerror

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsErrors

MIB type: Counter (32 bit)

numbusy

Integer

Not Null

See MIB object:

rttMonIcmpJitterStatsBusies

MIB type: Counter (32 bit)

AvgRtt

Numeric(30)

Not Null

Average RTT

Error_Percent

Numeric(30)

Not Null

Error percentage

NumTries

Integer

Not Null

Number of tries

AvgPosSD

Numeric(30)

Not Null

Average positive SD

StdDevPosSD

Numeric(30)

Not Null

Standard deviation positive SD

AvgNegSD

Numeric(30)

Not Null

Average negative SD

StdDevNegSD

Numeric(30)

Not Null

Standard deviation negative SD

AvgPosDS

Numeric(30)

Not Null

Average of positive SD

StdDevPosDS

Numeric(30)

Not Null

Standard deviation positive DS

AvgNegDS

Numeric(30)

Not Null

Average negative DS

StdDevNegDS

Numeric(30)

Not Null

Standard deviation negative DS

PacketErrorPercent

Numeric(30)

Null

Packet error percentage

OverThresholdPercent

Numeric(30)

Null

Over threshold percentage

StdDevRTT

Numeric(30)

Null

Standard deviation RTT

TotalPackets

Integer

Null

Total packets


ICMP_Jitter_Daily_Stats Table

All the column values other than the Collector ID and Start Time are average values from the hourly table. See Table 53.

Table 53 ICMP_Jitter_Daily_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID.

Reference to collector(ID)

starttime

date

Not Null

Start time of the day

MinRTT

Integer

Not Null

Average of all MinRTT

MaxRTT

Integer

Not Null

Average of all MaxRTT.

NumRTT

Integer

Not Null

Number of total RTT

SumRTT

Integer

Not Null

Sum of all RTT

SumRTT2

Double

Not Null

Sum of all RTT squars

minofposisd

Integer

Not Null

Minimum of all positive SD

maxofposisd

Integer

Not Null

Maximum of all positive SD

numofposisd

Integer

Not Null

Number of all positive SD

sumofposisd

Integer

Not Null

Sum of all positive SD

sum2posisd

Double

Not Null

Sum square of all positive SD square

minofnegasd

Integer

Not Null

Minimum of all negative SD

maxofnegasd

Integer

Not Null

Maximum of all negative SD

numofnegasd

Integer

Not Null

Number of all negative SD

sumofnegasd

Integer

Not Null

Sum of all negative SD

sum2negasd

Double

Not Null

Sum square of all negative SD

minofposids

Integer

Not Null

Minimum of all positive DS

maxofposids

Integer

Not Null

Maximum of all positive DS

numofposids

Integer

Not Null

Number of all positive DS

sumofposids

Integer

Not Null

Sum of all positive DS

sum2posids

Double

Not Null

Sum square of all positive DS

minofnegads

Integer

Not Null

Minimum of all negative DS

maxofnegads

Integer

Not Null

Maximum of all negative DS

numofnegads

Integer

Not Null

Number of all negative DS

sumofnegads

Integer

Not Null

Sum of all negative DS

sum2negads

Double

Not Null

Sum square of all negative DS

numcomplete

Integer

Not Null

Number of total RTT completions

numoverthresh

Integer

Not Null

Number of overthreshold

numPktLoss

Integer

Not Null

Number of packet loss

numPktOutSeqBoth

Integer

Not Null

Number of packet out sequence for both DS, SD

numPktOutSeqSDes

Integer

Not Null

Number of packet out sequence for SD

numPktOutSeqDSes

Integer

Not Null

Number of packet out sequence for DS

numPktSkippeds

Integer

Not Null

Number of packets skipped

numPktLateAs

Integer

Not Null

Number of late pakets

minSuccPktLoss

Integer

Not Null

Minimum of successful packet loss

maxSuccPktLoss

Integer

Not Null

Maximum of successful packet loss

numerror

Integer

Not Null

Number of errors

numbusy

Integer

Not Null

Number of busies

AvgRtt

Numeric(30)

Not Null

Average of all RTT

Error_Percent

Numeric(30)

Not Null

Error percentage

NumTries

Integer

Not Null

Number of all tries

AvgPosSD

Numeric(30)

Not Null

Average of positive SD

StdDevPosSD

Numeric(30)

Not Null

Standard deviation of positive SD

AvgNegSD

Numeric(30)

Not Null

Average negative SD

StdDevNegSD

Numeric(30)

Not Null

Standard deviation negative SD

AvgPosDS

Numeric(30)

Not Null

Average of positive DS

StdDevPosDS

Numeric(30)

Not Null

Standard deviation positive DS

AvgNegDS

Numeric(30)

Not Null

Average negative DS

StdDevNegDS

Numeric(30)

Not Null

Standard deviation negative DS

PacketErrorPercent

Numeric(30)

Null

Packet error percentage

OverThreshold
Percent

Numeric(30)

Not Null

Over threshold percentage

StdDevRTT

Numeric(30)

Not Null

Standard deviation RTT

TotalPackets

Integer

Not Null

Total packets


ICMP_Jitter_Weekly_Stats Table

All the column values other than the collector ID and Start Time are average values from Daily table. See Table 54.

Table 54 ICMP_Jitter_Weekly_Stats Table

Column Name
Type
Constraints
Description

CollectorID

BIGINT

Not Null

Collector (Running Instance) ID.

Reference to collector(ID)

starttime

date

Not Null

Start time of the weekly

MinRTT

Integer

Not Null

Average of all MinRTT

MaxRTT

Integer

Not Null

Average of all MaxRTT.

NumRTT

Integer

Not Null

Number of total RTT

SumRTT

Integer

Not Null

Sum of all RTT

SumRTT2

Double

Not Null

Sum of all RTT squars

minofposisd

Integer

Not Null

Minimum of all positive SD

maxofposisd

Integer

Not Null

Maximum of all positive SD

numofposisd

Integer

Not Null

Number of all positive SD

sumofposisd

Integer

Not Null

Sum of all positive SD

sum2posisd

Double

Not Null

Sum square of all positive SD square

minofnegasd

Integer

Not Null

Minimum of all negative SD

maxofnegasd

Integer

Not Null

Maximum of all negative SD

numofnegasd

Integer

Not Null

Number of all negative SD

sumofnegasd

Integer

Not Null

Sum of all negative SD

sum2negasd

Double

Not Null

Sum square of all negative SD

minofposids

Integer

Not Null

Minimum of all positive DS

maxofposids

Integer

Not Null

Maximum of all positive DS

numofposids

Integer

Not Null

Number of all positive DS

sumofposids

Integer

Not Null

Sum of all positive DS

sum2posids

Double

Not Null

Sum square of all positive DS

minofnegads

Integer

Not Null

Minimum of all negative DS

maxofnegads

Integer

Not Null

Maximum of all negative DS

numofnegads

Integer

Not Null

Number of all negative DS

sumofnegads

Integer

Not Null

Sum of all negative DS

sum2negads

Double

Not Null

Sum square of all negative DS

numcomplete

Integer

Not Null

Number of total RTT completions

numoverthresh

Integer

Not Null

Number of overthreshold

numPktLoss

Integer

Not Null

Number of packet loss

numPktOutSeqBoth

Integer

Not Null

Number of packet out sequence for both DS, SD

numPktOutSeqSDes

Integer

Not Null

Number of packet out sequence for SD

numPktOutSeqDSes

Integer

Not Null

Number of packet out sequence for DS

numPktSkippeds

Integer

Not Null

Number of packets skipped

numPktLateAs

Integer

Not Null

Number of late pakets

minSuccPktLoss

Integer

Not Null

Minimum of successful packet loss

maxSuccPktLoss

Integer

Not Null

Maximum of successful packet loss

numerror

Integer

Not Null

Number of errors

numbusy

Integer

Not Null

Number of busies

AvgRtt

Numeric(30)

Not Null

Average of all RTT

Error_Percent

Numeric(30)

Not Null

Error percentage

NumTries

Integer

Not Null

Number of all tries

AvgPosSD

Numeric(30)

Not Null

Average of positive SD

StdDevPosSD

Numeric(30)

Not Null

Standard deviation of positive SD

AvgNegSD

Numeric(30)

Not Null

Average negative SD

StdDevNegSD

Numeric(30)

Not Null

Standard deviation negative SD

AvgPosDS

Numeric(30)

Not Null

Average of positive DS

StdDevPosDS

Numeric(30)

Not Null

Standard deviation of positive DS

AvgNegDS

Numeric(30)

Not Null

Average negative DS

StdDevNegDS

Numeric(30)

Not Null

Standard deviation negative DS

PacketErrorPercent

Numeric(30)

Null

PacketErrorPercent

OverThresholdPercent

Numeric(30)

Null

OverThresholdPercent

StdDevRTT

Numeric(30)

Null

StdDevRTT

TotalPackets

Integer

Null

TotalPackets


ICMP_Jitter_Monthly_Stats Table

All the column values other than the collector ID and Start Time are average values from the weekly table. See Table 55.

Table 55 ICMP_Jitter_Monthly_Stats Table

Column Name
Type
Constraints
Description

CollectorID

BIGINT

Not Null

Collector (Running Instance) ID.

Reference to collector(ID)

starttime

date

Not Null

Start time of the month

MinRTT

Integer

Not Null

Average of all MinRTT

MaxRTT

Integer

Not Null

Average of all MaxRTT.

NumRTT

Integer

Not Null

Number of total RTT

SumRTT

Integer

Not Null

Sum of all RTT

SumRTT2

Double

Not Null

Sum of all RTT squars

minofposisd

Integer

Not Null

Minimum of all positive SD

maxofposisd

Integer

Not Null

Maximum of all positive SD

numofposisd

Integer

Not Null

Number of all positive SD

sumofposisd

Integer

Not Null

Sum of all positive SD

sum2posisd

Double

Not Null

Sum square of all positive SD

minofnegasd

Integer

Not Null

Minimum of all negative SD

maxofnegasd

Integer

Not Null

Maximum of all negative SD

numofnegasd

Integer

Not Null

Number of all negative SD

sumofnegasd

Integer

Not Null

Sum of all negative SD

sum2negasd

Double

Not Null

Sum square of all negative SD

minofposids

Integer

Not Null

Minimum of all positive DS

maxofposids

Integer

Not Null

Maximum of all positive DS

numofposids

Integer

Not Null

Number of all positive DS

sumofposids

Integer

Not Null

Sum of all positive DS

sum2posids

Double

Not Null

Sum square of all positive DS

minofnegads

Integer

Not Null

Minimum of all negative DS

maxofnegads

Integer

Not Null

Maximum of all negative DS

numofnegads

Integer

Not Null

Number of all negative DS

sumofnegads

Integer

Not Null

Sum of all negative DS

sum2negads

Double

Not Null

Sum square of all negative DS

numcomplete

Integer

Not Null

Number of total RTT completions

numoverthresh

Integer

Not Null

Number of overthreshold

numPktLoss

Integer

Not Null

Number of packet loss

numPktOutSeqBoth

Integer

Not Null

Number of packet out sequence for both DS, SD

numPktOutSeqSDes

Integer

Not Null

Number of packet out sequence for SD

numPktOutSeqDSes

Integer

Not Null

Number of packet out sequence for DS

numPktSkippeds

Integer

Not Null

Number of packets skipped

numPktLateAs

Integer

Not Null

Number of late pakets

minSuccPktLoss

Integer

Not Null

Minimum of successful packet loss

maxSuccPktLoss

Integer

Not Null

Maximum of successful packet loss

numerror

Integer

Not Null

Number of errors

numbusy

Integer

Not Null

Number of busies

AvgRtt

Numeric(30)

Not Null

Average of all RTT

Error_Percent

Numeric(30)

Not Null

Error percentage

NumTries

Integer

Not Null

Number of all tries

AvgPosSD

Numeric(30)

Not Null

Average of positive SD

StdDevPosSD

Numeric(30)

Not Null

Standard deviation of positive SD

AvgNegSD

Numeric(30)

Not Null

Average negative SD

StdDevNegSD

Numeric(30)

Not Null

Standard deviation negative SD

AvgPosDS

Numeric(30)

Not Null

Average of positive DS

StdDevPosDS

Numeric(30)

Not Null

Standard deviation of positive DS

AvgNegDS

Numeric(30)

Not Null

Average negative DS

StdDevNegDS

Numeric(30)

Not Null

Standard deviation negative DS

PacketErrorPercent

Numeric(30)

Null

PacketErrorPercent

OverThresholdPercent

Numeric(30)

Null

OverThresholdPercent

StdDevRTT

Numeric(30)

Null

StdDevRTT

TotalPackets

Integer

Null

TotalPackets


Ethernet_Jitter_Minute_Stats Table

The Ethernet_Jitter_Minute_Stats table is given in Table 56.

Table 56 Ethernet Jitter Minute 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

Not null

Start time

MinRTT

Integer

Not null

See MIB object:

ipslaEtherJitterLatestRTTMin

MaxRTT

Integer

Not null

See MIB object:

ipslaEtherJitterLatestRTTMax

NumRTT

Integer

Not null

See MIB object:

ipslaEtherJitterLatestNumRTT

SumRTT

Integer

Not null

See MIB object:

ipslaEtherJitterLatestRTTSum

SumRTT2

Double

Not null

See MIB object:

ipslaEtherJitterLatestRTTSum2

minofposisd

Integer

Not null

See MIB object:

ipslaEtherJitterLatestMinPosSD

maxofposisd

Integer

Not null

See MIB object:

ipslaEtherJitterLatestMaxPosSD

numofposisd

Integer

Not null

See MIB object:

ipslaEtherJitterLatestNumPosSD

sumofposisd

Integer

Not null

See MIB object:

ipslaEtherJitterLatestSumPosSD

sum2posisd

Double

Not null

See MIB object:

ipslaEtherJitterLatestSum2PosSD

minofnegasd

Integer

Not null

See MIB object:

ipslaEtherJitterLatestMinNegSD

maxofnegasd

Integer

Not null

See MIB object:

ipslaEtherJitterLatestMaxNegSD

numofnegasd

Integer

Not null

See MIB object:

ipslaEtherJitterLatestNumNegSD

sumofnegasd

Integer

Not null

See MIB object:

ipslaEtherJitterLatestSumNegSD

sum2negasd

Double

Not null

See MIB object:

ipslaEtherJitterLatestSum2NegSD

minofposids

Integer

Not null

See MIB object:

ipslaEtherJitterLatestMinPosDS

maxofposids

Integer

Not null

See MIB object:

ipslaEtherJitterLatestMaxPosDS

numofposids

Integer

Not null

See MIB object:

ipslaEtherJitterLatestNumPosDS

sumofposids

Integer

Not null

See MIB object:

ipslaEtherJitterLatestSumPosDS

sum2posids

Double

Not null

See MIB object:

ipslaEtherJitterLatestSum2PosDS

minofnegads

Double

Not null

See MIB object:

ipslaEtherJitterLatestMinNegDS

maxofnegads

Double

Not null

See MIB object:

ipslaEtherJitterLatestMaxNegDS

numofnegads

Double

Not null

See MIB object:

ipslaEtherJitterLatestNumNegDS

sumofnegads

Double

Not null

See MIB object:

ipslaEtherJitterLatestSumNegDS

sum2negads

Double

Not null

See MIB object:

ipslaEtherJitterLatestSum2NegDS

numframeLossSD

Integer

Not null

See MIB object:

ipslaEtherJitterLatestFrmLossSD

numframeLossDS

Integer

Not null

See MIB object:

ipslaEtherJitterLatestFrmLossDS

minSuccframeLoss

Integer

Not null

See MIB object:

ipslaEtherJitterLatestMinSucFrmL

maxSuccframeLoss

Integer

Not null

See MIB object:

ipslaEtherJitterLatestMaxSucFrmL

IAJitterOut

Integer

Null

See MIB object:

ipslaEtherJitterLatestIAJOut

IAJitterIn

Integer

Null

See MIB object:

ipslaEtherJitterLatestIAJIn

numframeoutOfSeq

Double

Not Null

See MIB object:

ipslaEtherJitterLatestFrmOutSeq

numframeSkips

Integer

Not Null

See MIB object:

ipslaEtherJitterLatestFrmSkipped

numframeUnpro

Integer

Not Null

See MIB object:

ipslaEtherJLatestFrmUnProcessed

numframelate

Integer

Not Null

See MIB object:

ipslaEtherJitterLatestFrmLateA

numframemia

Integer

Not Null

See MIB object:

ipslaEtherJitterLatestFrmMIA

AvgRTT

Numeric(30,6)

Null

Average of RTT

AvgPosSD

Numeric(30,6)

Null

Average of positive SD

StdDevPosSD

Numeric(30,6)

Null

Standard deviation of positive SD

AvgNegSD

Numeric(30,6)

Null

Average of negative SD

StdDevNegSD

Numeric(30,6)

Null

Standard deviation of negative SD

AvgPosDS

Numeric(30,6)

Null

Average of positive DS

StdDevPosDS

Numeric(30,6)

Null

Standard deviation of positive DS

AvgNegDS

Numeric(30,6)

Null

Average of negative DS

StdDevNegDS

Numeric(30,6)

Null

Standard deviation of negative DS

StdDevRTT

Numeric(30,6)

Null

Standard deviation of RTT


Ethernet_Jitter_Hourly_Stats Table

The Ethernet Jitter Hoursly Statistics table is given in Table 57.

Table 57 Ethernet_Jitter_Hourly_Stats 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

Not Null

Start time of the hourly bucket

MinRTT

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredRTTMin

MaxRTT

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredRTTMax

NumRTT

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredNumRTTs

SumRTT

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredRTTSums

SumRTT2

Double

Not Null

Sum square of RTT

See MIB object:

ipslaEtherJAggMeasuredRTTSum2Ls, ipslaEtherJAggMeasuredRTTSum2Hs.

minofposisd

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredMinPosSD

maxofposisd

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredMaxPosSD

numofposisd

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredNumPosSDs

sumofposisd

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredSumPosSDs

sum2posisd

Double

Not Null

Sum square of positive SD

See MIB object:

ipslaEtherJAggMeasuredSum2PSDLs, ipslaEtherJAggMeasuredSum2PSDHs

minofnegasd

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredMinNegSD

maxofnegasd

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredMaxNegSD

numofnegasd

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredNumNegSDs

sumofnegasd

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredSumNegSDs

sum2negasd

Double

Not Null

Sum square of negative SD

See MIB object:

ipslaEtherJAggMeasuredSum2NSDLs, ipslaEtherJAggMeasuredSum2NSDHs

minofposids

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredMinPosDS

maxofposids

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredMaxPosDS

numofposids

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredNumPosDSes

sumofposids

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredSumPosDSes

sum2posids

Double

Not Null

Sum square of positive DS

See MIB object:

ipslaEtherJAggMeasuredSum2PDSLs, ipslaEtherJAggMeasuredSum2PDSHs

minofnegads

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredMinNegDS

maxofnegads

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredMaxNegDS

numofnegads

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredNumNegDSes

sumofnegads

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredSumNegDSes

sum2negads

Double

Not Null

Sum square of negative DS

See MIB object:

ipslaEtherJAggMeasuredSum2NDSLs, ipslaEtherJAggMeasuredSum2NDSLs

numcomplete

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasured

Cmpletions

numoverthresh

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredOvThrshlds

numframeLossSD

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredFrmLossSDs

numframeLossDS

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredFrmLssDSes

minSuccframeLoss

Integer

Not Null

See MIB object:

ipslaEtherJAggMinSucFrmLoss

maxSuccframeLoss

Integer

Not Null

See MIB object:

pslaEtherJAggMaxSucFrmLoss

IAJitterOut

Integer

Null

See MIB object:

ipslaEtherJAggMeasuredIAJOut

IAJitterIn

Integer

Null

See MIB object:

ipslaEtherJAggMeasuredIAJIn

numerror

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasured
Errors

numbusy

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasured

Busies

numframeoutOfSeq

Double

Not Null

See MIB object:

ipslaEtherJAggMeasuredrm
OutSeqs

numframeSkips

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredFrmSkippds

numframeUnpro

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredFrmUnPrcds

numframelate

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredFrmLateAs

numframemia

Integer

Not Null

See MIB object:

ipslaEtherJAggMeasuredFrmMIAes

AvgRtt

Numeric(30,6)

Not Null

Average of RTT

Error_Percent

Numeric(30,6)

Not Null

Error percentage

NumTries

Integer

Not Null

Number of tries

AvgPosSD

Numeric(30,6)

Not Null

Average of positive SD

StdDevPosSD

Numeric(30,6)

Not Null

Standard deviation of positive SD

AvgNegSD

Numeric(30,6)

Not Null

Average of negative SD

StdDevNegSD

Numeric(30,6)

Not Null

Standard deviation of negative SD

AvgPosDS

Numeric(30,6)

Not Null

Average of positive DS

StdDevPosDS

Numeric(30,6)

Not Null

Standard deviation of positive DS

AvgNegDS

Numeric(30,6)

Not Null

Average of negative DS

StdDevNegDS

Numeric(30,6)

Not Null

Standard deviation of negative DS

PacketErrorPercent

Numeric(30,6)

Null

Packet error percentage

OverThresholdPercent

Numeric(30,6)

Null

Over threshold percentage

StdDevRTT

Numeric(30,6)

Null

Standard deviation of RTT

TotalPackets

Integer

Null

Total packets


Ethernet_Jitter_Daily_Stats Table

All the column values other than the Collector ID and Start Time are average values from the hourly table. Table 58.

Table 58 Ethernet_Jitter_Daily_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID.

Reference to collector(ID)

starttime

Timestamp

Not Null

Start time of the day

rttmin

Integer

Not Null

Average of all MinRTT

rttmax

Integer

Not Null

Average of all MaxRTT

numrtt

Integer

Not Null

Number of RTT

sumrtt

Integer

Not Null

Sum of RTT

sumrtt2

Double

Not Null

Sum square of RTT

minofposisd

Integer

Not Null

Minimum of positive SD

maxofposisd

Integer

Not Null

Maximum of positive SD

numofposisd

Integer

Not Null

Number of positive SD

sumofposisd

Integer

Not Null

Sum of positive SD

sum2posisd

Double

Not Null

Sum square of positive SD

minofnegasd

Integer

Not Null

Minimum of negative SD

maxofnegasd

Integer

Not Null

Maximum of negative SD

numofnegasd

Integer

Not Null

Number of negative SD

sumofnegasd

Integer

Not Null

Sum of negative SD

sum2negasd

Double

Not Null

Sum square of negative SD

minofposids

Integer

Not Null

Minimum of positive DS

maxofposids

Integer

Not Null

Maximum of positive DS

numofposids

Integer

Not Null

Number of positive DS

sumofposids

Integer

Not Null

Sum of positive DS

sum2posids

Double

Not Null

Sum square of positive DS

minofnegads

Integer

Not Null

Minimum of negative DS

maxofnegads

Integer

Not Null

Maximum of negative Ds

numofnegads

Integer

Not Null

Number of negative DS

sumofnegads

Integer

Not Null

Sum of negative DS

sum2negads

Double

Not Null

Sum square of negative DS

numcomplete

Integer

Not Null

Number of completions

numoverthresh

Integer

Not Null

Number of over threshold

numframeLossSD

Integer

Not Null

Number of frame loss SD

numframeLossDS

Integer

Not Null

Number of frame loss DS

minSuccframeLoss

Integer

Not Null

Minimum of successful frame loss

maxSuccframeLoss

Integer

Not Null

Maximum of successful frame loss

IAJitterOut

Integer

Null

IA jitter out

IAJitterIn

Integer

Null

IA jitter In

numerror

Integer

Not Null

Number of errors

numbusy

Integer

Not Null

Number of busies

numframeoutOfSeq

Double

Not Null

Number of frame out of sequence

numframeSkips

Integer

Not Null

Number of frame skips

numframeUnpro

Integer

Not Null

Number of frames un processed

numframelate

Integer

Not Null

Number of late frames

numframemia

Integer

Not Null

Number of frame MIA

AvgRtt

Numeric(30,6)

Not Null

Average of RTT

Error_Percent

Numeric(30,6)

Not Null

Error percentage

NumTries

Integer

Not Null

Number of tires

AvgPosSD

Numeric(30,6)

Not Null

Average of positive SD

StdDevPosSD

Numeric(30,6)

Not Null

Standard deviation of positive SD

AvgNegSD

Numeric(30,6)

Not Null

Average of negative SD

StdDevNegSD

Numeric(30,6)

Not Null

Standard deviation of negative SD

AvgPosDS

Numeric(30,6)

Not Null

Avergae of positve DS

StdDevPosDS

Numeric(30,6)

Not Null

Standared deviation of positive DS

AvgNegDS

Numeric(30,6)

Not Null

Average of negative DS

StdDevNegDS

Numeric(30,6)

Not Null

Standard deviation of negative DS

PacketErrorPercent

Numeric(30,6)

Null

Packet error percenatge

OverThresholdPercent

Numeric(30,6)

Null

Over thershold percentage

StdDevRTT

Numeric(30,6)

Null

Standard devaition of RTT

TotalPackets

Integer

Null

Total packets


Ethernet_Jitter_Weekly_Stats Table

All the column values other than the collector ID and Start Time are average values from Daily table. See Table 59.

Table 59 Ethernet_Jitter_Weekly_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID.

Reference to collector(ID)

starttime

Timestamp

Not Null

Start time of the day

MinRTT

Integer

Not Null

Average of all MinRTT

MaxRTT

Integer

Not Null

Average of all MaxRTT

NumRTT

Integer

Not Null

Number of RTT

SumRTT

Integer

Not Null

Sum of RTT

SumRTT2

Double

Not Null

Sum square of RTT

minofposisd

Integer

Not Null

Minimum of positive SD

maxofposisd

Integer

Not Null

Maximum of positive SD

numofposisd

Integer

Not Null

Number of positive SD

sumofposisd

Integer

Not Null

Sum of positive SD

sum2posisd

Double

Not Null

Sum square of positive SD

minofnegasd

Integer

Not Null

Minimum of negative SD

maxofnegasd

Integer

Not Null

Maximum of negative SD

numofnegasd

Integer

Not Null

Number of negative SD

sumofnegasd

Integer

Not Null

Sum of negative SD

sum2negasd

Double

Not Null

Sum square of negative SD

minofposids

Integer

Not Null

Minimum of positive DS

maxofposids

Integer

Not Null

Maximum of positive DS

numofposids

Integer

Not Null

Number of positive DS

sumofposids

Integer

Not Null

Sum of positive DS

sum2posids

Double

Not Null

Sum square of positive DS

minofnegads

Integer

Not Null

Minimum of negative DS

maxofnegads

Integer

Not Null

Maximum of negative Ds

numofnegads

Integer

Not Null

Number of negative DS

sumofnegads

Integer

Not Null

Sum of negative DS

sum2negads

Double

Not Null

Sum square of negative DS

numcomplete

Integer

Not Null

Number of completions

numoverthresh

Integer

Not Null

Number of over threshold

numframeLossSD

Integer

Not Null

Number of frame loss SD

numframeLossDS

Integer

Not Null

Number of frame loss DS

minSuccframeLoss

Integer

Not Null

Minimum of successful frame loss

maxSuccframeLoss

Integer

Not Null

Maximum of successful frame loss

IAJitterOut

Integer

Null

IA jitter out

IAJitterIn

Integer

Null

IA jitter In

numerror

Integer

Not Null

Number of errors

numbusy

Integer

Not Null

Number of busies

numframeoutOfSeq

Double

Not Null

Number of frame out of sequence

numframeSkips

Integer

Not Null

Number of frame skips

numframeUnpro

Integer

Not Null

Number of frames un processed

numframelate

Integer

Not Null

Number of late frames

numframemia

Integer

Not Null

Number of frame MIA

AvgRtt

Numeric(30,6)

Not Null

Average of RTT

Error_Percent

Numeric(30,6)

Not Null

Error percentage

NumTries

Integer

Not Null

Number of tires

AvgPosSD

Numeric(30,6)

Not Null

Average of positive SD

StdDevPosSD

Numeric(30,6)

Not Null

Standard deviation of positive SD

AvgNegSD

Numeric(30,6)

Not Null

Average of negative SD

StdDevNegSD

Numeric(30,6)

Not Null

Standard deviation of negative SD

AvgPosDS

Numeric(30,6)

Not Null

Avergae of positve DS

StdDevPosDS

Numeric(30,6)

Not Null

Standared deviation of positive DS

AvgNegDS

Numeric(30,6)

Not Null

Average of negative DS

StdDevNegDS

Numeric(30,6)

Not Null

Standard deviation of negative DS

PacketErrorPercent

Numeric(30,6)

Null

Packet error percenatge

OverThresholdPercent

Numeric(30,6)

Null

Over thershold percentage

StdDevRTT

Numeric(30,6)

Null

Standard deviation of RTT

TotalPackets

Integer

Null

Total packets


Ethernet_Jitter_Monthly_Stats Table

All the column values other than the collector ID and Start Time are average values from the weekly table. See Table 60.

Table 60 Ethernet_Jitter_Monthly_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID.

Reference to collector(ID)

starttime

Timestamp

Not Null

Start time of the month

MinRTT

Integer

Not Null

Average of all MinRTT

MaxRTT

Integer

Not Null

Average of all MaxRTT

NumRTT

Integer

Not Null

Number of RTT

SumRTT

Integer

Not Null

Sum of RTT

SumRTT2

Double

Not Null

Sum square of RTT

minofposisd

Integer

Not Null

Minimum of positive SD

maxofposisd

Integer

Not Null

Maximum of positive SD

numofposisd

Integer

Not Null

Number of positive SD

sumofposisd

Integer

Not Null

Sum of positive SD

sum2posisd

Double

Not Null

Sum square of positive SD

minofnegasd

Integer

Not Null

Minimum of negative SD

maxofnegasd

Integer

Not Null

Maximum of negative SD

numofnegasd

Integer

Not Null

Number of negative SD

sumofnegasd

Integer

Not Null

Sum of negative SD

sum2negasd

Double

Not Null

Sum square of negative SD

minofposids

Integer

Not Null

Minimum of positive DS

maxofposids

Integer

Not Null

Maximum of positive DS

numofposids

Integer

Not Null

Number of positive DS

sumofposids

Integer

Not Null

Sum of positive DS

sum2posids

Double

Not Null

Sum square of positive DS

minofnegads

Integer

Not Null

Minimum of negative DS

maxofnegads

Integer

Not Null

Maximum of negative Ds

numofnegads

Integer

Not Null

Number of negative DS

sumofnegads

Integer

Not Null

Sum of negative DS

sum2negads

Double

Not Null

Sum square of negative DS

numcomplete

Integer

Not Null

Number of completions

numoverthresh

Integer

Not Null

Number of over threshold

numframeLossSD

Integer

Not Null

Number of frame loss SD

numframeLossDS

Integer

Not Null

Number of frame loss DS

minSuccframeLoss

Integer

Not Null

Minimum of successful frame loss

maxSuccframeLoss

Integer

Not Null

Maximum of successful frame loss

IAJitterOut

Integer

Null

IA jitter out

IAJitterIn

Integer

Null

IA jitter In

numerror

Integer

Not Null

Number of errors

numbusy

Integer

Not Null

Number of busies

numframeoutOfSeq

Double

Not Null

Number of frame out of sequence

numframeSkips

Integer

Not Null

Number of frame skips

numframeUnpro

Integer

Not Null

Number of frames un processed

numframelate

Integer

Not Null

Number of late frames

numframemia

Integer

Not Null

Number of frame MIA

AvgRtt

Numeric(30,6)

Not Null

Average of RTT

Error_Percent

Numeric(30,6)

Not Null

Error percentage

NumTries

Integer

Not Null

Number of tires

AvgPosSD

Numeric(30,6)

Not Null

Average of positive SD

StdDevPosSD

Numeric(30,6)

Not Null

Standard deviation of positive SD

AvgNegSD

Numeric(30,6)

Not Null

Average of negative SD

StdDevNegSD

Numeric(30,6)

Not Null

Standard deviation of negative SD

AvgPosDS

Numeric(30,6)

Not Null

Avergae of positve DS

StdDevPosDS

Numeric(30,6)

Not Null

Standared deviation of positive DS

AvgNegDS

Numeric(30,6)

Not Null

Average of negative DS

StdDevNegDS

Numeric(30,6)

Not Null

Standard deviation of negative DS

PacketErrorPercent

Numeric(30,6)

Null

Packet error percenatge

OverThreshold
Percent

Numeric(30,6)

Null

Over thershold percentage

StdDevRTT

Numeric(30,6)

Null

Standard devaition of RTT

TotalPackets

Integer

Null

Total packets


Http_Minute_Stats Table

The HTTP Minute Statistics table is given in Table 61.

Table 61 Http_Minute_Stats 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

RTT

Integer

Not null

See MIB object:

rttMonLatestHTTP
OperRTT

MIB type: Gauge (32 bit)

DNSRTT

Integer

Not null

See MIB object:

rttMonLatestHTTPOper
DNSRTT

MIB type: Gauge (32 bit)

TCPConnectRTT

Integer

Not null

See MIB object:

rttMonLatestHTTPOper
CPConnectRTT

MIB type: Gauge (32 bit)

TransactionRTT

Integer

Not null

See MIB object:

rttMonLatestHTTPOper
TransactionRTT

MIB type: Gauge (32 bit)

MessageBodyOctets

Integer

Not null

See MIB object:

rttMonLatestHTTPOper
MessageBodyOctets

MIB type: Gauge (32 bit)


Http_Hourly_Stats Table

The HTTP Hourly Statistics table is given in Table 62.

Table 62 Http_Hourly_Stats 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

Not Null

See MIB object:

rttMonHTTPStats
RTTMin

MIB type: Gauge (32 bit)

MaxRTT

Integer

Not Null

See MIB object:

rttMonHTTPStatsRTT
Max

MIB type: Gauge (32 bit)

SumRTT

Integer

Not Null

See MIB object:

rttMonHTTPStatsRTTSum

MIB type: Counter (32 bit)

SumOfSquaredRTT

Double

Not Null

Sum square of all RTT.

See MIB object:

rttMonHTTPStatsRTT
Sum2Low, rttMonHTTPStatsRTT
Sum2High

DNSRTTSum

Integer

Not Null

See MIB object:

rttMonHTTPStatsDNSRTTSum

MIB type: Counter (32 bit)

TCPConnectRTTSum

Integer

Not Null

See MIB object:

rttMonHTTPStatsTCPConnectRTTSum

MIB type: Counter (32 bit)

TransactionRTTSum

Integer

Not Null

See MIB object:

rttMonHTTPStats
TransactionRTTSum

MIB type: Counter (32 bit)

MessageBodyOctetsSum

Integer

Not Null

See MIB object:

rttMonHTTPStats
MessageBodyOctets
Sum

MIB type: Counter (32 bit)

DNSServerTimeouts

Integer

Not Null

See MIB object:

rttMonHTTPStatsDNS
ServerTimeout

MIB type: Counter (32 bit)

TCPConnectTimeouts

Integer

Not Null

See MIB object:

rttMonHTTPStatsTCP
ConnectTimeout

MIB type: Counter (32 bit)

TransactionTimeouts

Integer

Not Null

See MIB object:

rttMonHTTPStats
TransactionTimeout

MIB type: Counter (32 bit)

DNSQueryErrors

Integer

Not Null

See MIB object:

rttMonHTTPStatsDNS
QueryError

MIB type: Counter (32 bit)

HttpErrors

Integer

Not Null

See MIB object:

rttMonHTTPStatsHTTPError

MIB type: Counter (32 bit)

InternalErrors

Integer

Not Null

See MIB object:

rttMonHTTPStatsError

MIB type: Counter (32 bit)

NumBusies

Integer

Not Null

Number of busies.

See MIB object:

rttMonHTTPStatsBusies

MIB type: Counter (32 bit)

NumCompletions

Integer

Not Null

Number of completions.

See MIB object:

rttMonHTTPStats
Completions

MIB type: Counter (32 bit)

NumOverThresholds

Integer

Not Null

Number of over thresholds.

See MIB object:

rttMonHTTPStatsOver
Thresholds

MIB type: Counter (32 bit)

AvgRtt

Numeric(30)

Not Null

Average of RTT

StdDevRTT

Numeric(30)

Null

Standard deviation of RTT

NumTries

Integer

Not Null

Number of tries

OverThresholdPercent

Numeric(30)

Null

Over threshold percentage

Error_Percent

Numeric(30)

Not Null

Error percentage

AvgDNSRTT

Numeric(30)

Not Null

Average DNS RTT

AvgTCPConnectRTT

Numeric(30)

Not Null

Average of TCP connect RTT

AvgTransactionRTT

Numeric(30)

Not Null

Average of transaction RTT

AvgMessageBodyOctets

Numeric(30)

Not Null

Average of messagebodyoctets


Http_Daily_Stats Table

All the column values other than the Collector ID and Start Time are average values from the hourly table. Table 63.

Table 63 Http_Daily_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

IDENTITY, Primary Key

Collector (Running Instance) ID.

Reference to collector(ID)

Start Time

date

Not Null

Start time of the day

MinRTT

Integer

Not Null

Average of all MinRTT.

MaxRTT

Integer

Not Null

Average of all MaxRTT.

SumRTT

Integer

Not Null

Sum of all RTT

SumOfSquaredRTT

Double

Not Null

Sum square of all RTT

DNSRTTSum

Integer

Not Null

Sum of DNSRTT

TCPConnectRTTSum

Integer

Not Null

Sum of TCPConnectRTT

TransactionRTTSum

Integer

Not Null

Sum of TransactionRTT

MessageBodyOctetsSum

Integer

Not Null

Sum of MessageBodyOctets

DNSServerTimeouts

Integer

Not Null

DNSServer Timeouts

TCPConnectTimeouts

Integer

Not Null

TCPConnect Timeouts

TransactionTimeouts

Integer

Not Null

Transaction Timeouts

DNSQueryErrors

Integer

Not Null

DNSQuery Errors

HttpErrors

Integer

Not Null

Http Errors

InternalErrors

Integer

Not Null

Internal Errors

NumBusies

Integer

Not Null

Number of busies

NumCompletions

Integer

Not Null

Number of completions.

NumOverThresholds

Integer

Not Null

Number of over thresholds.

AvgRtt

Numeric(30)

Not Null

Average of RTT

StdDevRTT

Numeric(30

Null

Standard deviation of RTT

NumTries

Integer

Not Null

Number of tries

OverThresholdPercent

Numeric(30)

Null

Over threshold percentage

Error_Percent

Numeric(30

Not Null

Error percentage

AvgDNSRTT

Numeric(30

Not Null

Average DNS RTT

AvgTCPConnectRTT

Numeric(30

Not Null

Average of TCP connect RTT

AvgTransactionRTT

Numeric(30

Not Null

Average of transaction RTT

AvgMessageBodyOctets

Numeric(30

Not Null

Average of messagebodyoctets


Http_Weekly_Stats Table

All the column values other than the collector ID and Start Time are average values from Daily table. See Table 64.

Table 64 Http_Weekly_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

IDENTITY,

Primary Key

Collector (Running Instance) ID.

Reference to collector(ID)

Start Time

date

Not Null

Start time of the week

MinRTT

Integer

Not Null

Average of all MinRTT

MaxRTT

Integer

Not Null

Average of all MaxRTT

SumRTT

Integer

Not Null

Sum of all RTT

SumOfSquaredRTT

Double

Not Null

Sum square of all RTT

DNSRTTSum

Integer

Not Null

Sum of DNSRTT

TCPConnectRTTSum

Integer

Not Null

Sum of TCPConnectRTT

TransactionRTTSum

Integer

Not Null

Sum of TransactionRTT

MessageBodyOctetsSum

Integer

Not Null

Sum of MessageBodyOctets

DNSServerTimeouts

Integer

Not Null

DNSServer Timeouts

TCPConnectTimeouts

Integer

Not Null

TCPConnect Timeouts

TransactionTimeouts

Integer

Not Null

Transaction Timeouts

DNSQueryErrors

Integer

Not Null

DNSQuery Errors

HttpErrors

Integer

Not Null

Http Errors

InternalErrors

Integer

Not Null

Internal Errors

NumBusies

Integer

Not Null

Number of busies

NumCompletions

Integer

Not Null

Number of completions.

NumOverThresholds

Integer

Not Null

Number of over thresholds.

AvgRtt

Numeric(30)

Not Null

Average of RTT

StdDevRTT

Integer

Null

Standard deviation of RTT

NumTries

Integer

Not Null

Number of tries

OverThresholdPercent

Numeric(30)

Null

Over threshold percentage

Error_Percent

Integer

Not Null

Error percentage

AvgDNSRTT

Integer

Not Null

Average DNS RTT

AvgTCPConnectRTT

Integer

Not Null

Average of TCP connect RTT

AvgTransactionRTT

Integer

Not Null

Average of transaction RTT

AvgMessageBodyOctets

Integer

Not Null

Average of messagebodyoctets


Http_Monthly_Stats Table

All the column values other than the collector ID and Start Time are average values from the weekly table. See Table 65.

Table 65 Http_Monthly_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID

Reference to collector(ID)

Start Time

date

Not Null

Start time of the month

RTTMin

Integer

Not Null

Average of all MinRTT.

RTTMax

Integer

Not Null

Average of all MinRTT.

RTTSum

Integer

Not Null

Sum of all RTT

SumOfSquaredRTT

Double

Not Null

Sum square of all RTT

DNSRTTSum

Integer

Not Null

Sum of DNSRTT

TCPConnectRTTSum

Integer

Not Null

Sum of TCPConnectRTT

TransactionRTT

Sum

Integer

Not Null

Sum of TransactionRTT

MessageBodyOctetsSum

Integer

Not Null

Sum of MessageBodyOctets

DNSServerTimeouts

Integer

Not Null

DNSServer Timeouts

TCPConnectTimeouts

Integer

Not Null

TCPConnect Timeouts

TransactionTimeouts

Integer

Not Null

Transaction Timeouts

DNSQueryErrors

Integer

Not Null

DNSQuery Errors

HttpErrors

Integer

Not Null

Http Errors

InternalErrors

Integer

Not Null

Internal Errors

NumBusies

Integer

Not Null

Number of busies.

NumCompletions

Integer

Not Null

Number of completions.

NumOverThresholds

Integer

Not Null

Number of over thresholds.

AvgRtt

Numeric(30)

Not Null

Average of RTT

StdDevRTT

Numeric(30)

Null

Standard deviation of RTT

NumTries

Integer

Not Null

Number of tries

OverThreshold
Percent

Numeric(30)

Null

Over threshold percentage

Error_Percent

Numeric(30)

Not Null

Error percentage

AvgDNSRTT

Numeric(30)

Not Null

Average DNS RTT

AvgTCPConnectRTT

Numeric(30)

Not Null

Average of TCP connect RTT

AvgTransactionRTT

Numeric(30)

Not Null

Average of transaction RTT

AvgMessageBodyOctets

Numeric(30)

Not Null

Average of messagebodyoctets


PATHECHO_Hourly_Stats Table

The Pathecho Hourly Statistics table is given in Table 66.

Table 66 PATHECHO_Hourly_Stats 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)

PathID

Integer

Null

Path ID.

Reference to

pathinfo(path ID)

HopID

Integer

Null

Hop ID

HopAddress

Varchar(255)

Null

Hop address

See MIB object:

rttMonStatsCollectAddress

StartTime

Timestamp

Not Null

Start time for the hourly bucket

MinRTT

Integer

Not Null

Minimum of RTT

See MIB object:

rttMonStatsCaptureCompletionTimeMin

MaxRTT

Integer

Not Null

Maximum of RTT

See MIB object:

rttMonStatsCaptureCompletionTimeMax

SumRTT

Integer

Not Null

Sum of all RTT

See MIB object:

rttMonStatsCaptureSum
CompletionTime

SumSqrdRTT

Integer

Not Null

Sum square of all RTT

See MIB object:

rttMonStatsCaptureSum
CompletionTime2Low, rttMonStatsCaptureSum
CompletionTime2High

NumCompletions

Integer

Not Null

Number of completions.

See MIB object:

rttMonStatsCapture
Completions

NumOverThresholds

Integer

Not Null

Number of over thresholds.

See MIB object:

rttMonHTTPStatsOver
Thresholds

MIB type: Counter (32 bit)

NumDisconnects

Integer

Not Null

Number of disconnects.

See MIB object:

rttMonStatsCollectNum
Disconnects

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

NumNoConnections

Integer

Not Null

Number of no connections

See MIB object:

rttMonStatsCollectNoConnections.

NumDrops

Integer

Not Null

Number of drops.

See MIB object:

rttMonStatsCollectDrops

NumSeqErrors

Integer

Not Null

Number of sequence errors.

See MIB object:

rttMonStatsCollectSequence
Errors

NumVerifyErrors

Integer

Not Null

Number of verify errors

See MIB object:

rttMonStatsCollectVerify
Errors

NumTries

Integer

Not Null

Number of tries

AvgRTT

Numeric(30)

Not Null

Average of all RTT

Standard
Deviation

Numeric(30)

Not Null

Standard deviation

OverThres_
Percent

Numeric(30)

Not Null

Over threshold percentage

Error_Percent

Numeric(30)

Not Null

Error percentage

Availability_ Percent

Numeric(30)

Not Null

AvailabilityPercent


PATHECHO_Daily_Stats Table

All the column values other than the Collector ID and Start Time are average values from the hourly table. See Table 67.

Table 67 PATHECHO_Daily_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID

Reference to collector(ID)

PathID

Integer

Not Null

Path ID.

See Pathinfo (path ID)

HopID

Integer

Not Null

Hop ID

HopAddress

Varchar(255)

Not Null

Hop address

StartTime

date

Not Null

Start time of the day

MinRTT

Integer

Not Null

Average of all MinRTT

MaxRTT

Integer

Not Null

Average of all MaxRTT

SumRTT

Integer

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 tries

AvgRTT

Numeric(30)

Not Null

Average of all RTT

StandardDeviation

Numeric(30)

Not Null

Standard deviation

OverThres_Percent

Numeric(30)

Not Null

Over threshold percentage

Error_Percent

Numeric(30)

Not Null

Error percentage

Availability_Percent

Numeric(30)

Not Null

AvailabilityPercent


PATHECHO_Weekly_Stats Table

All the column values other than the collector ID and Start Time are average values from Daily table. See Table 68.

Table 68 PATHECHO_Weekly_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID

See collector(ID)

PathID

Integer

Not Null

Path ID.

See pathinfo(pathID)

HopID

Integer

Not Null

Hop ID

HopAddress

Varchar(255)

Not Null

Hop address

See MIBobject:

rttMonStatsCollectAddress

StartTime

date

Not Null

Start time fo the week

MinRTT

Integer

Not Null

Average of all MinRTT.

MaxRTT

Integer

Not Null

Average of all MaxRTT.

SumRTT

Integer

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 tries

AvgRTT

Numeric(30)

Not Null

Average of all RTT

StandardDeviation

Numeric(30)

Not Null

Standard deviation

OverThres_Percent

Numeric(30)

Not Null

Over threshold percentage

Error_Percent

Numeric(30)

Not Null

Error percentage

Availability_Percent

Numeric(30)

Not Null

AvailabilityPercent


PATHECHO_Monthly_Stats Table

All the column values other than the collector ID and Start Time are average values from the weekly table. See Table 69.

Table 69 PATHECHO_Hourly_Stats Table

Column Name
Type
Constraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID

See collector(ID)

PathID

Integer

Not Null

Path ID.

See pathinfo(path ID)

HopID

Integer

Not Null

Hop ID

HopAddress

Varchar(255)

Not Null

Hop address

StartTime

date

Not Null

Start time of the month

MinRTT

Integer

Not Null

Average of all MinRTT.

MaxRTT

Integer

Not Null

Average of all MaxRTT.

SumRTT

Integer

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 tries

AvgRTT

Numeric(30)

Not Null

Average of all RTT

StandardDeviation

Numeric(30)

Not Null

Standard deviation

OverThres_Percent

Numeric(30)

Not Null

Over threshold percentage

Error_Percent

Numeric(30)

Not Null

Error percentage

Availability_Percent

Numeric(30)

Not Null

AvailabilityPercent


RTP_Minute_Stats Table

The RTP Minute Statisics table is given in Table 70.

Table 70 RTP_Minute_Stats Table

Column Name
Type
Constraints
Description

rowID

Bigint

Not Null

Unique identifier

CollectorID

Bigint

Not Null

Collector (Running Instance) ID.

See collector(ID)

starttime

Timestamp

Not Null

Start time

RTT

Integer

Null

See MIB object:

rttMonLatestRtpOperRTT

MIB type: Gauge (32 bit)

IAJitterDS

Integer

Null

See MIB object:

rttMonLatestRtpOperIAJitterDS

MIB type: Gauge (32 bit)

IAJitterSD

Integer

Null

See MIB object:

rttMonLatestRtpOperPacketLossSD

MIB type: Gauge (32 bit)

packetLossDS

Integer

Null

See MIB object:

rttMonLatestRtpOperPacketLossDS

MIB type: Gauge (32 bit)

packetLossSD

Integer

Null

See MIB object:

rttMonLatestRtpOperPacketLossSD

MIB type: Gauge (32 bit)

RFactorDS

Integer

Null

See MIB object:

rttMonLatestRtpOperRFactorDS

MIB type: Gauge (32 bit)

RFactorSD

Integer

Null

See MIB object:

rttMonLatestRtpOperRFactorSD

MIB type: Gauge (32 bit)

MOSCQDS

Numeric(30)

Null

See MIB object:

rttMonLatestRtpOperMOSCQDS

MIB type: Gauge (32 bit)

MOSCQSD

Numeric(30)

Null

See MIB object:

rttMonLatestRtpOperMOSCQSD

MIB type: Gauge (32 bit)

frameLossDS

Integer

Null

See MIB object:

rttMonLatestRtpOperFrameLossDS

MIB type: Gauge (32 bit)

MOSLQDS

Numeric(30)

Null

See MIB object:

rttMonLatestRtpOperMOSLQDS

MIB type: Gauge (32 bit)

MIA

Integer

Null

See MIB object:

rttMonLatestRtpOperPacketsMIA

MIB type: Gauge (32 bit)

totalPacketsDS

Integer

Null

See MIB object:

rttMonLatestRtpOperTotalPaksDS

MIB type: Gauge (32 bit)

totalPacketsSD

Integer

Null

See MIB object:

rttMonLatestRtpOperTotalPaksSD

MIB type: Gauge (32 bit)

outOfSequenceDS

Integer

Null

Out of sequence of DS

See MIB object:

rttMonLatestRtpOperPacketOOSDS

earlyPacketsDS

Integer

Null

Early packets of DS

See MIB object:

rttMonLatestRtpOperPacketEarlyDS

latePacketsDS

Integer

Null

See MIB object:

rttMonLatestRtpOperPacketLateDS

MIB type: Gauge (32 bit)


RTP_Hourly_Stats Table

The RTP Hourly Statistics table is given in Table 71.

Table 71 RTP_Hourly_Stats Table

Column Name
Type
Contraints
Description

rowID

Bigint

Not Null

Unique identifier

CollectorID

binint

Not Null

Collector (Running Instance) ID.

See to collector(ID)

starttime

Timestamp

Not Null

Start time of the hourly bucket.

MinRTT

Integer

Null

Minimum of RTT.

See MIB object:

rttMonStatsCaptureCompletionTimeMin

MIB type: Gauge (32bit)

MaxRTT

Integer

Null

Maximum of RTT.

See MIB object: rttMonRtpStatsRTTMax

MIB type: Gauge (32 bit)

AvgRTT

Numeric(30,6)

Null

See MIB object: rttMonRtpStatsRTTAvg

MIB type: Gauge (32 bit)

IAJitterDSMin

Integer

Null

See MIB object:

rttMonRtpStatsIAJitterDSMin

MIB type: Gauge (32 bit)

IAJitterDSMax

Integer

Null

See MIB object

rttMonRtpStatsIAJitterDSMax

MIB type: Gauge (32 bit)

IAJitterDSAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsIAJitterDSAvg

MIB type: Gauge (32 bit)

IAJitterSDMin

Integer

Null

See MIB object:

rttMonRtpStatsIAJitterSDMin

MIB type: Gauge (32 bit)

IAJitterSDMax

Integer

Null

See MIB object:

rttMonRtpStatsIAJitterSDMax

MIB type: Gauge (32 bit)

IAJitterSDAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsIAJitterSDAvg

MIB type: Gauge (32 bit)

packetLossDSMin

Integer

Null

See MIB object:

rttMonRtpStatsPacketLossDSMin

MIB type: Gauge (32 bit)

packetLossDSMax

Integer

Null

See MIB object:

rttMonRtpStatsPacketLossDSMax

MIB type: Gauge (32 bit)

packetLossDSAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsPacketLossDSAvg

MIB type: Gauge (32 bit)

packetLossSDMin

Integer

Null

See MIB object:

rttMonRtpStatsPacketLossSDMin

MIB type: Gauge (32 bit)

packetLossSDMax

Integer

Null

See MIB object:

rttMonRtpStatsPacketLossSDMax

MIB type: Gauge (32 bit)

packetLossSDAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsPacketLossSDAvg

MIB type: Gauge (32 bit)

RFactorDSMin

Integer

Null

See MIB object:

rttMonRtpStatsRFactorDSMin

MIB type: Gauge (32 bit)

RFactorDSMax

Integer

Null

See MIB object:

rttMonRtpStatsRFactorDSMax

MIB type: Gauge (32 bit)

RFactorDSAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsRFactorDSAvg

MIB type: Gauge (32 bit)

RFactorSDMin

Integer

Null

See MIB object: rttMonRtpStatsRFactorSDMin

MIB type: Gauge (32 bit)

RFactorSDMax

Integer

Null

See MIB object:

rttMonRtpStatsRFactorSDMax

MIB type: Gauge (32 bit)

RFactorSDAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsRFactorSDAvg

MIB type: Gauge (32 bit)

MOSCQDSMin

Integer

Null

See MIB object:

rttMonRtpStatsMOSCQDSMin

MIB type: Gauge (32 bit)

MOSCQDSMax

Integer

Null

See MIB object:

rttMonRtpStatsMOSCQDSMax

MIB type: Gauge (32 bit)

MOSCQDSAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsMOSCQDSAvg

MIB type: Gauge (32 bit)

MOSCQSDMin

Integer

Null

See MIB object:

rttMonRtpStatsMOSCQSDMin

MIB type: Gauge (32 bit)

MOSCQSDMax

Integer

Null

See MIB object:

rttMonRtpStatsMOSCQSDMax

MIB type: Gauge (32 bit)

MOSCQSDAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsMOSCQSDAvg

MIB type: Gauge (32 bit)

frameLossDSMin

Integer

Null

See MIB object:

rttMonRtpStatsFrameLossDSMin

MIB type: Gauge (32 bit)

frameLossDSMax

Integer

Null

See MIB object:

rttMonRtpStatsFrameLossDSMax

MIB type: Gauge (32 bit)

frameLossDSAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsFrameLossDSAvg

MIB type: Gauge (32 bit)

MOSLQDSMin

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsMOSLQDSMin

MIB type: Gauge (32 bit)

MOSLQDSMax

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsMOSLQDSMax

MIB type: Gauge (32 bit)

MOSLQDSAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsMOSLQDSAvg

MIB type: Gauge (32 bit)

miaAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsPacketsMIAAvg

MIB type: Gauge (32 bit)

totalPacketsDSMin

Integer

Null

See MIB object:

rttMonRtpStatsTotalPacketsDSMin

MIB type: Gauge (32 bit)

totalPacketsDSMax

Integer

Null

See MIB object:

rttMonRtpStatsTotalPacketsDSMax

MIB type: Gauge (32 bit)

totalPacketsDSAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsTotalPacketsDSAvg

MIB type: Gauge (32 bit)

totalPacketsSDMin

Integer

Null

See MIB object:

rttMonRtpStatsTotalPacketsSDMin

MIB type: Gauge (32 bit)

totalPacketsSDMax

Integer

Null

See MIB object:

rttMonRtpStatsTotalPacketsSDMax

MIB type: Gauge (32 bit)

totalPacketsSDAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsTotalPacketsSDAvg

MIB type: Gauge (32 bit)

outOfSequenceDSAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsPacketOOSDSAvg

MIB type: Gauge (32 bit)

earlyPacketsDSAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsPacketEarlyDSAvg

MIB type: Gauge (32 bit)

latePacketsDSAvg

Numeric(30,6)

Null

See MIB object:

rttMonRtpStatsPacketLateDSAvg

MIB type: Gauge (32 bit)


RTP_Daily_Stats Table

All the column values other than the Collector ID and Start Time are average values from the hourly table. See Table 72

Table 72 RTP_Daily_Stats Table

Column Name
Type
Contraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID.

See collector(ID)

starttime

Timestamp

Not Null

Start time of the day

MinRTT

integer

Not Null

Average of all MinRTT.

MaxRTT

integer

Not Null

Average of all MaxRTT.

AvgRTT

numeric(30,6)

Not Null

Average of RTT

IAJitterDSMin

integer

Not Null

Minimum of IAJitterDS

IAJitterDSMax

integer

Not Null

Maximum of IAJitterDS

IAJitterDSAvg

numeric(30,6)

Not Null

Average of IAJitterDS

IAJitterSDMin

integer

Not Null

Minimum of IAJitterSD

IAJitterSDMax

integer

Not Null

Maximum of IAJitterSD

IAJitterSDAvg

numeric(30,6)

Not Null

Average of IAJitterSD

packetLossDSMin

integer

Not Null

Minimum of packetLossDS

packetLossDSMax

integer

Not Null

Maximum of packetLossDS

packetLossDSAvg

numeric(30,6)

Not Null

Average of packetLossDS

packetLossSDMin

integer

Not Null

Minimum of packetLossSD

packetLossSDMax

integer

Not Null

Maximum of packetLossSD

packetLossSDAvg

numeric(30,6)

Not Null

Average of packetLossSD

RFactorDSMin

integer

Not Null

Minimum of RFactorDS

RFactorDSMax

integer

Not Null

Maximum of RfactorDS

RFactorDSAvg

numeric(30,6)

Not Null

Average of RfactorDS

RFactorSDMin

integer

Not Null

Minimum of RFactorSD

RFactorSDMax

integer

Not Null

Maximum of RfactorSD

RFactorSDAvg

numeric(30,6)

Not Null

Average of RfactorSD

MOSCQDSMin

numeric(30,6)

Not Null

Minimum of MOSCQDS

MOSCQDSMax

numeric(30,6)

Not Null

Maximum of MOSCQDS

MOSCQDSAvg

numeric(30,6)

Not Null

Average of MOSCQDS

MOSCQSDMin

numeric(30,6)

Not Null

Minimum of MOSCQSD

MOSCQSDMax

numeric(30,6)

Not Null

Maximum of MOSCQSD

MOSCQSDAvg

numeric(30,6)

Not Null

Average of MOSCQSD

frameLossDSMin

integer

Not Null

Minimum of frameLossDS

frameLossDSMax

integer

Not Null

Maximum of frameLossDS

frameLossDSAvg

numeric(30,6)

Not Null

Average of frameLossDS

MOSLQDSMin

numeric(30,6)

Not Null

Minimum of MOSLQDS

MOSLQDSMax

numeric(30,6)

Not Null

Maximum of MOSLQDS

MOSLQDSAvg

numeric(30,6)

Not Null

Average of MOSLQDS

miaAvg

numeric(30,6)

Not Null

Average of MIA

totalPacketsDSMin

integer

Not Null

Minimum of totalPacketsDS

totalPacketsDSMax

integer

Not Null

Maximum of totalPacketsDS

totalPacketsDSAvg

numeric(30,6)

Not Null

Average of totalPacketsDS

totalPacketsSDMin

integer

Not Null

Minimum of totalPacketsSD

totalPacketsSDMax

integer

Not Null

Maximum of totalPacketsSD

totalPacketsSDAvg

numeric(30,6)

Not Null

Average of totalPacketsSD

outOfSequenceDSAvg

numeric(30,6)

Not Null

Average of outOfSequenceDS

earlyPacketsDSAvg

numeric(30,6)

Not Null

Average of earlyPacketsDS

latePacketsDSAvg

numeric(30,6)

Not Null

Average of latePacketsDS


RTP_Weekly _Stats Table

All the column values other than the collector ID and Start Time are average values from Daily table. See Table 73.

Table 73 RTP_Weekly _Stats Table

Column Name
Type
Contraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID

Reference to collector(ID)

starttime

Timestamp

Not Null

Start time of the week

MinRTT

double

Not Null

Average of all MinRTT.

MaxRTT

double

Not Null

Average of all MaxRTT.

AvgRTT

numeric(30,6)

Not Null

Average of RTT

IAJitterDSMin

double

Not Null

Minimum of IAJitterDS

IAJitterDSMax

double

Not Null

Maximum of IAJitterDS

IAJitterDSAvg

numeric(30,6)

Not Null

Average of IAJitterDS

IAJitterSDMin

double

Not Null

Minimum of IAJitterSD

IAJitterSDMax

double

Not Null

Maximum of IAJitterSD

IAJitterSDAvg

numeric(30,6)

Not Null

Average of IAJitterSD

packetLossDSMin

double

Not Null

Minimum of packetLossDS

packetLossDSMax

double

Not Null

Maximum of packetLossDS

packetLossDSAvg

numeric(30,6)

Not Null

Average of packetLossDS

packetLossSDMin

double

Not Null

Minimum of packetLossSD

packetLossSDMax

double

Not Null

Maximum of packetLossSD

packetLossSDAvg

numeric(30,6)

Not Null

Average of packetLossSD

RFactorDSMin

double

Not Null

Minimum of RFactorDS

RFactorDSMax

double

Not Null

Maximum of RfactorDS

RFactorDSAvg

numeric(30,6)

Not Null

Average of RfactorDS

RFactorSDMin

double

Not Null

Minimum of RFactorSD

RFactorSDMax

double

Not Null

Maximum of RfactorSD

RFactorSDAvg

numeric(30,6)

Not Null

Average of RfactorSD

MOSCQDSMin

numeric(30,6)

Not Null

Minimum of MOSCQDS

MOSCQDSMax

numeric(30,6)

Not Null

Maximum of MOSCQDS

MOSCQDSAvg

numeric(30,6)

Not Null

Average of MOSCQDS

MOSCQSDMin

numeric(30,6)

Not Null

Minimum of MOSCQSD

MOSCQSDMax

numeric(30,6)

Not Null

Maximum of MOSCQSD

MOSCQSDAvg

numeric(30,6)

Not Null

Average of MOSCQSD

frameLossDSMin

double

Not Null

Minimum of frameLossDS

frameLossDSMax

double

Not Null

Maximum of frameLossDS

frameLossDSAvg

numeric(30,6)

Not Null

Average of frameLossDS

MOSLQDSMin

numeric(30,6)

Not Null

Minimum of MOSLQDS

MOSLQDSMax

numeric(30,6)

Not Null

Maximum of MOSLQDS

MOSLQDSAvg

numeric(30,6)

Not Null

Average of MOSLQDS

miaAvg

numeric(30,6)

Not Null

Average of MIA

totalPacketsDSMin

double

Not Null

Minimum of totalPacketsDS

totalPacketsDSMax

double

Not Null

Maximum of totalPacketsDS

totalPacketsDSAvg

numeric(30,6)

Not Null

Average of totalPacketsDS

totalPacketsSDMin

double

Not Null

Minimum of totalPacketsSD

totalPacketsSDMax

double

Not Null

Maximum of totalPacketsSD

totalPacketsSDAvg

numeric(30,6)

Not Null

Average of totalPacketsSD

outOfSequenceDSAvg

numeric(30,6)

Not Null

Average of outOfSequenceDS

earlyPacketsDSAvg

numeric(30,6)

Not Null

Average of earlyPacketsDS

latePacketsDSAvg

numeric(30,6)

Not Null

Average of latePacketsDS


RTP_Monthly_Stats Table

The RTP Monthly Statistics table is given in Table 74.

Table 74 RTP_Monthly_Stats Table

Column Name
Type
Contraints
Description

CollectorID

Bigint

Not Null

Collector (Running Instance) ID

See to collector(ID)

starttime

Timestamp

Not Null

Start time of the month

MinRTT

double

Not Null

Average of all MinRTT.

MaxRTT

double

Not Null

Average of all MaxRTT.

AvgRTT

numeric(30,6)

Not Null

Average of RTT

IAJitterDSMin

double

Not Null

Minimum of IAJitterDS

IAJitterDSMax

double

Not Null

Maximum of IAJitterDS

IAJitterDSAvg

numeric(30,6)

Not Null

Average of IAJitterDS

IAJitterSDMin

double

Not Null

Minimum of IAJitterSD

IAJitterSDMax

double

Not Null

Maximum of IAJitterSD

IAJitterSDAvg

numeric(30,6)

Not Null

Average of IAJitterSD

packetLossDSMin

double

Not Null

Minimum of packetLossDS

packetLossDSMax

double

Not Null

Maximum of packetLossDS

packetLossDSAvg

numeric(30,6)

Not Null

Average of packetLossDS

packetLossSDMin

double

Not Null

Minimum of packetLossSD

packetLossSDMax

double

Not Null

Maximum of packetLossSD

packetLossSDAvg

numeric(30,6)

Not Null

Average of packetLossSD

RFactorDSMin

double

Not Null

Minimum of RFactorDS

RFactorDSMax

double

Not Null

Maximum of RfactorDS

RFactorDSAvg

numeric(30,6)

Not Null

Average of RfactorDS

RFactorSDMin

double

Not Null

Minimum of RFactorSD

RFactorSDMax

double

Not Null

Maximum of RfactorSD

RFactorSDAvg

numeric(30,6)

Not Null

Average of RfactorSD

MOSCQDSMin

numeric(30,6)

Not Null

Minimum of MOSCQDS

MOSCQDSMax

numeric(30,6)

Not Null

Maximum of MOSCQDS

MOSCQDSAvg

numeric(30,6)

Not Null

Average of MOSCQDS

MOSCQSDMin

numeric(30,6)

Not Null

Minimum of MOSCQSD

MOSCQSDMax

numeric(30,6)

Not Null

Maximum of MOSCQSD

MOSCQSDAvg

numeric(30,6)

Not Null

Average of MOSCQSD

frameLossDSMin

double

Not Null

Minimum of frameLossDS

frameLossDSMax

double

Not Null

Maximum of frameLossDS

frameLossDSAvg

numeric(30,6)

Not Null

Average of frameLossDS

MOSLQDSMin

numeric(30,6)

Not Null

Minimum of MOSLQDS

MOSLQDSMax

numeric(30,6)

Not Null

Maximum of MOSLQDS

MOSLQDSAvg

numeric(30,6)

Not Null

Average of MOSLQDS

miaAvg

numeric(30,6)

Not Null

Average of MIA

totalPacketsDSMin

double

Not Null

Minimum of totalPacketsDS

totalPacketsDSMax

numeric(30,6)

Not Null

Maximum of totalPacketsDS

totalPacketsDSAvg

numeric(30,6)

Not Null

Average of totalPacketsDS

totalPacketsSDMin

double

Not Null

Minimum of totalPacketsSD

totalPacketsSDMax

double

Not Null

Maximum of totalPacketsSD

totalPacketsSDAvg

numeric(30,6)

Not Null

Average of totalPacketsSD

outOfSequenceDSAvg

numeric(30,6)

Not Null

Average of outOfSequenceDS

earlyPacketsDSAvg

numeric(30,6)

Not Null

Average of earlyPacketsDS

latePacketsDSAvg

numeric(30,6)

Not Null

Average of latePacketsDS