Cisco Prime LAN Management Solution

Table Of Contents

Open Database Schema Support in Cisco Prime LAN Management Solution 4.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 and Soft Appliance Systems

Sample Code to Access Database From a Remote Server

Importing Data into Microsoft Office Excel Using dbviews

Changing the Database Password

Changing Password on Solaris and Soft Appliance

Changing Password on Windows

Formats Available for 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

UT_History View Details

VTPDomainPorts 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

Device_EnergyWise View Details

Port_EnergyWise View Details

EnergyWise_Domain View Details

Fault_Event_History View Details

Fault_Event_Details View Details

IPSLA Database Schema

Connecting to IPSLA Database

Schema of IPSLA 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

User Stopped 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

video_oper Table

Video_Minute_Stats Table

Video_Hourly_Stats Table

Video_Daily_Stats Table

Video_Weekly_Stats Table

Video_Monthly_Stats Table

Notices

OpenSSL/Open SSL Project

License Issues

Open Database Schema Support in Cisco Prime LAN Management Solution 4.2

---

Contents

This document explains the open database schema support in Cisco Prime LAN Management Solution (LMS 4.2). This document contains the following sections:

•Enabling Access to Database

•Accessing Database Views

•Changing the Database Password

•Exposed Database Views and Tables

•Schema of Exposed Database Views

•IPSLA 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 or Soft Appliance systems

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

where,

•NMSROOT — Default LMS 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 username to access the database view as a normal user is lmsdatafeed.

The default username to access the database view as a ssecure user is lmssecuredatafeed.

The CLI utility prompts you to enter the passwords for normal database view user and secure database view user.

As a normal database view user, you will be able to access all views except EnergyWise_Domain view.

You can access EnergyWise_Domain view only when you connect the database as a secure database view user.

The passwords can be between 5 and 30 characters long.

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: User ID 'lmssecuredatafeed' 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 IPSLA Database for details on connecting to the IPSLA database.

You can also access the following databases using the default usernames.

The database names and their default usernames are given in the table below:

Database Name	User Name
cmf	cmfDBA
ipm	DBA
rmeng	DBA
dfmInv	itemInvUser
dfmEpm	itemEpmUser
dfmFh	itemFhUser
upm	dba
ani	cwsiSA

The password to connect to the database is the password you entered or randomly generated during installation of LMS 4.2.

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 LMS Server.

Or

•A remote server with or without LMS 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 | lmssecuredatafeed","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 to which you want to connect:

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

where,

•localhost —Local LMS 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 username to connect as a normal database view user.

•lmssecuredatafeed — Default username to connect as a secure database view user.

•dbpasswd — Database view password. You should enter the password corresponding to the view username you are using to connect to the database.

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
Network Topology, Layer 2 Services and User Tracking	aniDb	43443
Inventory, Config and Image Management	rmengdb	43455
Fault Management (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:

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:odbc:dsn=cmf","lmsdatafeed | 
lmssecuredatafeed","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 to which you want to connect:

conn = DriverManager.getConnection("jdbc:odbc:dsn=cmf","lmsdatafeed | 
lmssecuredatafeed","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 username to connect as a normal database view user

•lmssecuredatafeed — Default username to connect as a secure database view user

•dbpasswd — Database view password. You should enter the password corresponding to the view username you are using to connect to the database.

Application Data Source Names

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

Application	Data Source Name (dsn)
Common Services	cmf
Network Topology, Layer 2 Services and User Tracking	ani
Inventory, Config and Image Management	rmeng
Fault Management (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 | lmssecuredatafeed";

$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 LMS Server:

---

Step 1 Create a perl file, for example, sample.pl and store it on your LMS 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 or Soft Appliance systems)

•NMSROOT\bin\perl Perl_file_name (on Windows systems)

where,

•NMSROOT — LMS 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 LMS 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 to which you want to connect:

my $connString = "dsn=cmf;uid=lmsdatafeed | lmssecuredatafeed"; 
$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 username to connect as a normal database view user.

•lmssecuredatafeed — Default username to connect as a secure database view user.

•dbpasswd — Database view password. You should enter the password corresponding to the view user name you are using to connect to the database.

Accessing the Database From a Remote Server

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

•Prerequisites for Accessing Database Views on Windows Systems

•Prerequisites for Accessing Database Views on Solaris and Soft Appliance 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 LMS Server, from a remote Windows server, you must:

•Copy the LMS files to the remote Windows server

•Create DSNs in the remote Windows server

This section explains:

•Copying LMS files to a Remote Windows Server

•Creating DSNs on Windows Systems

Copying LMS files to a Remote Windows Server

Before you access the database views from a remote Windows server, you must copy the following LMS 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 LMS 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 systems:

---

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 Cisco Prime Embedded Database.

Step 5 Click Edit > New > Expandable String value to create an expandable string value for Cisco Prime 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 LMS files.

For example, if you have stored the LMS files in 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 LMS 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 LMS files.

For example, if you have stored the LMS 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 Cisco Prime 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 Cisco Prime 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 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 normal database view username is lmsdatafeed. The default secure database view username is lmssecuredatafeed.

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 of 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 LMS Server to which you want to connect.

•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 that can be used.

For example, to connect to Common Services application in the LMS 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 LMS applications whose database views are exposed:

Application	Database Engine Name
Common Services	cmfEng
Network Topology, Layer 2 Services and User Tracking	aniEng
Inventory, Config and Image Management	rmengEng
Fault Management (Fault History)	dfmFhEng

Prerequisites for Accessing Database Views on Solaris and Soft Appliance Systems

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

•Copy the LMS files to a remote Solaris and Soft Appliance servers

•Create DSNs on a remote Solaris and Soft Appliance servers

This section explains:

•Copying LMS files to a Remote Solaris and Soft Appliance Servers

•Creating DSNs on Solaris and Soft Appliance Systems

Copying LMS files to a Remote Solaris and Soft Appliance Servers

Before you access the database views from a remote Solaris and Soft Appliance servers, you must copy the following LMS 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 LMS 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 and Soft Appliance Systems

To create DSNs on Solaris and Soft Appliance 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=LMS_Server_Name;DOBROADCAST=NO;ServerPort=Application_Port_Number}

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

UID=Default_Database_View_User_Name

Description=Cisco Prime Embedded Database

where,

•LMS_Server_Name— Default LMS installation directory.

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

•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.

•LMS_Server_Name — Hostname or IP Address of the remote LMS Server to which you want to connect

•Application_Port_Number — Port number that is used to connect to the application database. See Application Database Names and Port Number Details for details of other port numbers to be used.

•Database_View_User_Name — Database view username. To connect as a normal database view user, the default username is lmsdatafeed. To connect as a secure database view user, the default username is lmssecuredatafeed.

For example, to add the DSN for Common Services application in the LMS 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=Cisco Prime Embedded Database

You can add multiple DSNs for other LMS applications 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 LMS Server to remote server and created DSNs, you can access the LMS database from a remote server.

See the following sections for the sample code to access the LMS 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.

Step 5 Click OK.

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

Step 7 Click Next.

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

Step 9 Click Next.

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

Step 11 Click Next.

Step 12 Select Return to Microsoft Office Excel.

Step 13 Click Finish.

Step 14 Select the appropriate range in the Excel worksheet to import the data.

Step 15 Click Ok.

---

For importing data into Microsoft Excel from a remote server:

---

Step 1 Copy the following LMS directories to your local system:

•NMSROOT/objects/db/charsets

•NMSROOT/objects/db/java

•NMSROOT/objects/db/scripts

•NMSROOT/objects/db/win32

Step 2 Create a new DSN for exporting data to Microsoft 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 normal database view username is lmsdatafeed. The default secure database view username is lmssecuredatafeed.

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 LMS, the installer prompts you to enter the database password. If you do not enter the password, LMS 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.

---

Caution You need to shut down LMS, change the password and then restart LMS, for the changes to take effect. Make sure you are not running any critical tasks. Otherwise, you might lose data.

---

This section explains the following:

•Changing Password on Solaris and Soft Appliance

•Changing Password on Windows

•Formats Available for Changing the Database Password

Changing Password on Solaris and Soft Appliance

To change the password on Solaris and Soft Appliance:

---

Step 1 Log in as the superuser, and enter the root password.

Step 2 Stop all processes by entering:

/etc/init.d/dmgtd stop

Step 3 Change to the installation directory by entering:

cd NMSROOT/bin

NMSROOT is your default LMS installation directory.

Step 4 Enter the following command to list the different formats available for changing the database password:

NMSROOT/bin/perl dbpasswd.pl

Step 5 When prompted, enter the new password and verify it by re-entering it.

The password can contain a maximum of 30 characters.

Step 6 Start all processes by entering:

/etc/init.d/dmgtd start

---

Changing Password on Windows

To change the password on Windows:

---

Step 1 At the command line, make sure you have the correct permissions .

Step 2 Stop all processes by entering:

net stop crmdmgtd

Step 3 Change to the Installation Directory by entering:

cd NMSROOT\bin

NMSROOT is your default LMS installation directory.

Step 4 Enter the following command to list the different formats available for changing the database password:

NMSROOT\bin\perl dbpasswd.pl

Step 5 When prompted, enter the new password and verify it by re-entering it.

The password can contain a maximum of 30 characters.

Step 6 Start all processes by entering:

net start crmdmgtd

---

Formats Available for Changing the Database Password

The different formats available and the commands for changing the database passwords on Windows and Solaris and Soft Appliance platform are tabulated below:

Format	Command
Format 1 detects the available datasource names and databases and prompts you to enter and confirm the passwords for each of them. It also allows you to encrypt the password.	On Solaris and Soft Appliance: NMSROOT/bin/perl dbpasswd.pl all On Windows: NMSROOT\bin\perl dbpasswd.pl all
Format 2 allows you to list all the databases and datasource names (DSNs) available in the server.	On Solaris and Soft Appliance: NMSROOT/bin/perl dbpasswd.pl listdsn On Windows: NMSROOT\bin\perl dbpasswd.pl listdsn
Format 3 allows you to change the database password.	On Solaris and Soft Appliance: NMSROOT/bin/perl dbpasswd.pl dsn=odbc_datasource On Windows: NMSROOT\bin\perl dbpasswd.pl dsn=odbc_datasource
Format 4 allows you to change the database password for a specific DSN. It also allows you to enter a new password in the command line using the npwd option.	On Solaris and Soft Appliance: NMSROOT/bin/perl dbpasswd.pl dsn=dsn-name npwd=new-password On Windows: NMSROOT\bin\perl dbpasswd.pl dsn=dsn-name npwd=new-password
Format 5 allows you to encrypt the existing database password.	On Solaris and Soft Appliance: NMSROOT/bin/perl dbpasswd.pl dsn=dsn-name encyption=yes On Windows: NMSROOT\bin\perl dbpasswd.pl dsn=dsn-name encyption=yes
Format 6 allows you to change the database password for a specific DSN. Format 6.0 also: •Allows you to enter a new password in the command line using the npwd option. •Allows you to encrypt the password using the encryption option.	On Solaris and Soft Appliance: NMSROOT/bin/perl dbpasswd.pl dsn=dsn-name npwd=new-password encryption=yes On Windows: NMSROOT\bin\perl dbpasswd.pl dsn=dsn-name npwd=new-password encryption=yes

Exposed Database Views and Tables

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

Table 1 Exposed Database Views and Tables  

LMS Application	Name of Views or Tables
Common Services (CS) Views	Network_Devices
	Job_Details
Network Topology, Layer 2 Services and User Tracking Views	End_Hosts
	UT_History
	VTPDomainPorts
Fault Management Views	Fault_Alert_History
	Fault_Event_History
	Fault_Event_Details
Inventory, Config and Image Management 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
	Device_EnergyWise
	Port_EnergyWise
	EnergyWise_Domain
IPSLA Performance Management (Tables)	Source (Source Table)
	Target (Target Table)
	IPMDevice (IPM Device Table)
	Operation (Operation 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)
	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)
IPSLA Performance Management (Tables) (continued)	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)
	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)
	video_oper (Video Operations Table)
	Video_Minute_Stats (Video Minute Statistics Table)
IPSLA Performance Management (Tables) (continued)	Video_Hourly_Stats (Video Hourly Statistics Table
	Video_Daily_Stats (Video Daily Statistics Table)
	Video_Weekly_Stats (Video Weekly Statistics Table)
	Video_Monthly_Stats (Video 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 about each field.

---

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

---

Schema of Exposed Database Views contains the details of the following views:

•Network_Devices View Details

•Job_Details View Details

•End_Hosts View Details

•UT_History View Details

•VTPDomainPorts 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

•Device_EnergyWise View Details

•Port_EnergyWise View Details

•EnergyWise_Domain 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 for 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 is UDF$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 — the Last day of month every N-th month •263 — Weekdays (Sun,Mon,..Sat) •513 — Every N-Seconds (Start time based) •514 — Every N-Mins (Start time based) •515 — Every N-Hours (Start time based) •769 — Every N-Seconds (End time based) •770 — Every N-Mins (End time based) •771— Every N-Hours (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, 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 username
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 to which the end host is connected
VLAN	varchar(32)	Null	VLAN name. Example: VLAN100
Subnet	varchar(15)	Null	Subnet of the device to which the 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 which end host is connected
VTPDomain	varchar(32)	Null	VTP Domain Name of the device to which 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

UT_History View Details

The UT_History view displays the user tracking history details, as explained in Table 5.

Table 5 UT_History Schema Details 

Column Name	Column Type	Constraints	Column Description
UserName	varchar(30)	Null	Logged in username
MACAddress	bigint	Null	MAC address of the end host
iLogin	varchar(32)	Null	Date and time when the user logged in
iLogout	varchar(32)	Null	Date and time when the user logged out

VTPDomainPorts View Details

The VTPDomainPorts view displays the end host details, as explained in Table 6.

Table 6 VTPDomainPorts Schema Details 

Column Name	Column Type	Constraints	Column Description
isLink	char	Not Null	True - Configured as Link Port False - Not configured as Link Port
PortDescription	varchar(255)	Null	Description of the port. It could be the CDP Name or Interface alias name
PortName	varchar(254)	Null	Name of the port
Device Name	varchar(64)	Null	Name of the device to which the port belongs to
Device IPAddress	varchar(40)	Null	Management IP address of the device
PortStatus	char	Not Null	Up - Port is operationally up and administratively up Down - Port is down either operationally or administratively or both
isTrunk	char	Not Null	True - Configured as Trunk Port False - Not configured as Trunk Port
Vlan	varchar(128)	Null	VLAN name associated with port.
Assosiation Type	char	Not Null	Comma separated list of routers in the subnet. The Association type could be: •Secondary •Auxiliary •Native •Unknown
Port Mode	char	Not Null	The port mode could be: •Non-PVLAN •PVLAN Host •PVLAN Trunk •Promiscuous •Unknown
Domain	varchar(64)	Null	Management Domain name.
dbId	integer	Primary	DCR Device ID. Unique Identifier for the device.

Device_Inventory View Details

This view displays the device inventory information as explained in Table 7.

Table 7 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 as explained in Table 8.

Table 8 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 Configuration, Inventory, and Software Management, as explained in Table 9.

Table 9 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 as explained in Table 10.

Table 10 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 11

Table 11 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 12.

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

Table 12 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 success 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 Inventory collection status details, as explained in Table 13.

Table 13 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 Config Archive status details, as explained in Table 14.

Table 14 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 Change Audit History details, as explained in Table 15.

Table 15 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 LMS server. The host name can contain the 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_Lastday view displays the Syslog details as explained in Table 16.

These views are created everyday to reflect the current day and the previous day's Syslog details.

Table 16 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	Facility 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

Device_EnergyWise View Details

The Device_EnergyWise view details displays the EnergyWise details of a device as explained in Table 17.

Table 17 Device_EnergyWise Schema Details

Column Name	Column Type	Constraints	Column Description
Device_ID	integer	PRIMARY	DCR Device ID. Unique Identifier for the device.
Device_Display_Name	varchar(128)	Not Null	Device Display Name.
DomainName	varchar(255)	Null	Name of the EnergyWise domain consisting EnergyWise-enabled devices and endpoints.
Keyword	varchar(255)	Null	Word that helps you identify a specific device or group of devices.
Role	varchar(255)	Null	Role or function of the device in the EnergyWise domain.
Importance	smallint	Null	Value of EnergyWise Importance of the endpoint. This value differentiates the endpoints in a domain based on their power usage. For example, a desk phone has a lower importance than a business-critical emergency phone. Value can be within the range of 1 to 100.
EnergyWiseState	smallint	Null	EnergyWise status of the device. 0 — Software Incapable 1 — Disabled 2 — Enabled
MinSupportedOS	varchar(50)	Null	Minimum supported software for the device.

Port_EnergyWise View Details

The Port_EnergyWise viewdetails displays the EnergyWise details of a port as explained in Table 18.

Table 18 Port_EnergyWise Schema Details

Column Name	Column Type	Constraints	Column Description
Device_ID	integer	PRIMARY	DCR Device ID. Unique Identifier for the device.
Device_Display_Name	varchar(128)	Not Null	Device Display Name.
Portname	varchar(255)	Null	Port to which the endpoint is connected.
Keyword	varchar(255)	Null	Word that helps you identify a specific device or group of devices.
Role	varchar(255)	Null	Role or function of the device in the EnergyWise domain.
Importance	smallint	Null	Value of EnergyWise Importance of the endpoint. This value differentiates the endpoints in a domain based on their power usage. For example, a desk phone has a lower importance than a business-critical emergency phone. Value can be within the range of 1 to 100.

EnergyWise_Domain View Details

The EnergyWise_Domain view details displays the EnergyWise domain details as explained in Table 19.

---

Note You can access EnergyWise_Domain view only when you connect the database as a secure database view user.

Table 19 EnergyWise_Domain Schema Details  

Column Name	Column Type	Constraints	Column Description
Device_ID	integer	PRIMARY	DCR Device ID. Unique Identifier for the device.
Device_Display_Name	varchar(128)	Not Null	Device Display Name.
Device_IPAddress	varchar(128)	Null	Management IP Address of the device.
Hostname	varchar(128)	Null	Hostname of the device.
Domain	varchar(255)	Null	Name of the EnergyWise domain consisting EnergyWise-enabled devices and endpoints.
Domain_Secret	varchar(255)	Null	Secret used by the EnergyWise protocol to enable communication between devices within the domain.
Management_Secret	varchar(255)	Null	Secret used by the LMS server to collect data from the devices in the domain.
Endpoint_Secret	varchar(255)	Null	Secret used by EnergyWise protocol to communicate with the endpoint devices in the domain.
NTP_Secret	varchar(255)	Null	Secret used by the EnergyWise protocol to enable communication between devices in the domain.
Port	bigint	Null	Port to which the endpoint is connected.

---

Fault_Event_History View Details

The Fault_Event_History view displays the fault event history details as explained in Table 20.

Event List contains the list of events for an alert.

Table 20 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	Event name. See the Online help for the Event Monitor processed by LMS.
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 fault event details as explained in Table 21.

Event Details contains the properties and details of the event. Each event may have multiple properties and the number of properties is dependent on the 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 21 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

IPSLA 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.

This section contains:

•Connecting to IPSLA Database

•Schema of IPSLA Database Tables

Connecting to IPSLA Database

To connect to the IPSLA 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 LMS

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

•Database name — ipm

•Database source name — ipm

•Database engine name — ipmEng

Schema of IPSLA Database Tables

This chapter contains the following 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

•User Stopped 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

•video_oper Table

•Video_Minute_Stats Table

•Video_Hourly_Stats Table

•Video_Daily_Stats Table

•Video_Weekly_Stats Table

•Video_Monthly_Stats Table

Source Table

The Source table is given in Table 22.

Table 22 Source Table  

Column Name	Type	Constraints	Description
DeviceID	Bigint	IDENTITY, primary key	Unique identifier
IOSVersion	Varchar(64)	Null	Version of 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 23.

Table 23 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 24.

Table 24 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 for which a system should wait for a device to respond before the system retries 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

Details of Operation Table is given in Table 25.

Table 25 Operation Table  

Column Name	Type	Constraints	Description
OperationID	Bigint	IDENTITY, primary key	Unique identifier
CreationFlag	Integer	Not Null	Flag 0 - system defined operations Flag 1 - user defined operations
Operation Name	Varchar(127)	Not Null	Unique operation name
Owner	Varchar(64)	Null	See MIB object: rttMonCtrlAdminOwner MIB type: OwnerString Owner of the Operation
Descr	Varchar(255)	Null	Description
RTTType	Integer	Null	See MIB object: rttMonCtrlAdminRttType MIB type: RttMonRttType Default Value: {echo} Specifies the type of RTT operation to be performed: 1 = echo 2 = pathEcho 5 = udpEcho 6 = tcpConnect 7 = http 8 = dns 9 = jitter 10 = dlsw 11 = dhcp 12 = ftp 14 = RTP 16 = icmpjitter 18 = VoipCallSetupPostDialDelay 19 = VoipGKRegDelay 1019-Ethernetping 1020-Ethernetjitter 1119-EthernetPingAutoIPSLA 1120-EthernetPingAutoIPSLA
Frequency	Integer	Null	See MIB object: rttMonCtrlAdminFrequency MIB type: Integer32(0..604800) The frequency values are displayed in seconds. Default Value: { 60 } Duration between initiating RTT requests
timeout	Integer	Null	See MIB object: rttMonCtrlAdminTimeout MIB type: Integer32(0..604800000) Default Value: { 5000 } Duration to wait for an RTT response
adminThreshold	Integer	Not Null	Threshold range in milli seconds
verifydata	smallint	Not Null	See MIB object: rttMonCtrlAdminVerifyData Default Value : false

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

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 26

Table 26 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 27.

Table 27 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 28.

Table 28 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 29.

Table 29 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. 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 30.

Table 30 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 31.

Table 31 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 32.

Table 32 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 33.

Table 33 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.
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 34.

Table 34 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 35.

Table 35 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 36

Table 36 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 37

Table 37 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 38.

Table 38 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 39

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

Table 40 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 MIB 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 41.

Table 41 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 (limited to 15 characters)
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 in the 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 that indicates whether to configure the collector or not.
VrfName	varchar(255)	Not null	Vrf Name for the collector
LastModified	timestamp	Not null	Time at which the collector was last modified

User Stopped Collector Table

The User Stopped Collector table is given in Table 42

Table 42 User Stopped Collector Table

Column Name	Type	Constraints	Description
deviceid	bigint	Null	Source.
CollectorID	Bigint	IDENTITY, Primary key	Unique identifier for collector

VrfList Table

The VRF List table is given in Table 43.

Table 43 VrfList Table  

Column Name	Type	Constraints	Description
deviceid	bigint	Composite primary key. Not null	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 44 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
flag	bit

Table 44.

completed_outages Table

The Completed Outages table is given in Table 45

Table 45 completed_outages Table

Column	Type	Constraints	Description
Outage Id	Integer	Not null	Outage ID
Collector Id	biginit	Not null	Collector IDof 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 46

Table 46 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 47.

Table 47 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 48.

Table 48 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
NumCompletions	Integer	Not Null	See MIB object: rttMonStatsCapture CompletionsMIB type: Integer32(0..2147483647) Number of RTTs completed
NumOverThresholds	Integer	Not Null	Number of overthresholds. See MIB object: rttMonStatsCaptureOver Thresholds MIB type: Integer32(0..2147483647) Number of OverThresholds
NumDisconnects	Integer	Not Null	Number of Disconnects. See MIB object: rttMonStatsCollectNum Disconnects MIB type: Integer32(0..2147483647)
NumTimeouts	Integer	Not Null	Number of Timeouts See MIB object: rttMonStatsCollectTimeout MIB type: Integer32(0..2147483647)
NumBusies	Integer	Not Null	Number of busies See MIB object: rttMonStatsCollectBusies MIB type: Integer32(0..2147483647) Number of Busies
NumNoConnections	Integer	Not Null	See MIB object: rttMonStatsCollectNo Connections MIB type: Integer32(0..2147483647) Number of Connections
NumDrops	Integer	Not Null	Number of drops. See MIB object: rttMonStatsCollectDrops MIB type: Integer32(0..2147483647) Number of RTT Dropped
NumSeqErrors	Integer	Not Null	See MIB object: rttMonStatscollectSequence Errors MIB type: Integer32(0..2147483647) Number of Sequence Errors
NumVerifyErrors	Integer	Not Null	See MIB object: rttMonStatsCollectVerify Errors MIB type: Integer32(0..2147483647) Number of Verify Errors
NumTries	Integer	Not Null	Number of tries
AvgRTT	Numeric(30)	Not Null	Average of RTT
StandardDeviation	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 49.

Table 49 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 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 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 50.

Table 50 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 51 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 51.

Jitter_Minute_Stats Table

The Jitter Minute Statistics table is given in Table 52.

Table 52 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	Numeric(30)	Null	Standard deviation of negative DS
StdDevRTT	Numeric(30)	Null	Standard deviation of RTT
mos	Integer	Not Null	See MIB object: rttMonLatestJitterOperNumOfOW MIB type: Gauge (32 bit)
icpif	Integer	Not Null	See MIB object: rttMonLatestJitterOperICPIF MIB type: : Gauge (32 bit)
NumOfOW	integer	Not Null	See MIB object: rttMonLatestJitterOperNumOfOW MIB type: Gauge (32 bit)
SumOWSD	integer	Not Null	See MIB object: rttMonLatestJitterOperOWSumSD MIB type: Gauge (32 bit)
Sum2OWSD	double	Not Null	See MIB object: rttMonLatestJitterOperOWSum2SD MIB type: Gauge (32 bit)
StddevOWSD	numeric(30,6)	Null	Standard deviation of one way latency SD
AvgOWSD	numeric(30,6	Null	Average of positive one way SD
MinOWSD	integer	Not Null	See MIB object: rttMonLatestJitterOperOWMinSD MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonLatestJitterOperOWMaxSD MIB type: Gauge (32 bit)
SumOWDS	integer	Not Null	See MIB object: rttMonLatestJitterOperOWSumDS MIB type: Gauge (32 bit)
Sum2OWDS	double	Not Null	See MIB object: rttMonLatestJitterOperOWSum2DS MIB type: Gauge (32 bit)

Jitter_Hourly_Stats Table

The Jitter Hourly Statistics table is given in Table 53.

Table 53 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 for 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 of packets sent from destination to source.
numofposisd	Integer	Not Null	Refer to MIB object: rttMonJitterStatsNumOfPositivesSD MIB type: Gauge32 The sum 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 of packets sent 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 of packets sent from source to destination
sum2negasd	Double	Not Null	Refer to MIB object: rttMonJitterStatsSum2Negatives SD2Low and MIB object: rttMonJitterStatsSum2Negatives SD2High The sum of the squares of RTT's of all negative jitter values of packets sent from destination to source.
minofposids	Integer	Not Null	Refer to MIB object: rttMonJitterStatsMinOfPositivesDS MIB type: Gauge32 The minimum of absolute values of all positive jitter values of 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 of 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 RTTs of all positive jitter values for 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 for 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 for packets sent from source to destination
numofnegads	Integer	Not Null	Refer to MIB object: rttMonJitterStatsNumOfNegativesDS MIB type: Gauge32 The sum of all negative jitter values for packets sent of destination to source.
sumofnegads	Integer	Not Null	Refer to MIB object: rttMonJitterStatsSumOfNegativesDS MIB type: Counter32 The sum of all negative jitter values for packets sent from destination to source
sum2negads	Double	Not Null	Refer to MIB object: rttMonJitterStatsSum2Negatives DS2Low and MIB object: rttMonJitterStatsSum2Negatives DS2High The sum of the squares of RTTs of all negative jitter values for 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 thet 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 of 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 54.

Table 54 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 RTTs that are successfullymeasured
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
NumOfOW	integer	Not Null	See MIB object: rttMonJitterStatsNumOfOW MIB type: Gauge (32 bit)
SumOWSD	integer	Not Null	See MIB object: rttMonJitterStatsOWSumSD MIB type: Gauge (32 bit)
Sum2OWSD	double	Not Null	See MIB object: rttMonJitterStatsOWSumSDHigh MIB type: Gauge (32 bit)
StddevOWSD	numeric(30,6)	Null	Standard deviation of one way latency SD
AvgOWSD	numeric(30,6	Null	Average of positive one way SD
MinOWSD	integer	Not Null	See MIB object: rttMonJitterStatsOWMinSDNew MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonJitterStatsOWMaxSDNew MIB type: Gauge (32 bit)
SumOWDS	integer	Not Null	See MIB object: rttMonJitterStatsOWSumDS MIB type: Gauge (32 bit)
Sum2OWDS	double	Not Null	See MIB object: rttMonJitterStatsOWSumDSHigh MIB type: Gauge (32 bit)
StddevOWDS	numeric(30,6)	Null	Standard deviation of one way latency DS
AvgOWDS	numeric(30,6)	Null	Average of positive one way DS
MinOWDS	integer	Not Null	See MIB object: rttMonJitterStatsOWMinDSNew MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonJitterStatsOWMinDSNew MIB type: Gauge (32 bit) See MIB object: rttMonJitterStatsOWMaxDSNew MIB type: Gauge (32 bit)

Jitter_Weekly_Stats Table

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

Table 55 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 RTTs 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 positive 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 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 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	Standard deviation of positive SD
AvgNegSD	Numeric(30)	Not Null	Average of negative SD
StdDevNegSD	Numeric(30)	Not Null	Standard deviation of 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	PacketErrorPercent
OverThresholdPercent	Numeric(30)	Null	OverThresholdPercent
StdDevRTT	Numeric(30)	Null	Standard deviation of RTT
TotalPackets	Integer	Null	Total Packets
minmos	Integer	Not Null	Minimum MOS
maxmos	Integer	Not Null	Maximum MOS
minicpif	Integer	Not Null	Minimum ICPIF
maxicpif	Integer	Not Null	Maximum ICPIF
NumOfOW	integer	Not Null	See MIB object: rttMonJitterStatsNumOfOW MIB type: Gauge (32 bit)
SumOWSD	integer	Not Null	See MIB object: rttMonJitterStatsOWSumSD MIB type: Gauge (32 bit)
Sum2OWSD	double	Not Null	See MIB object: rttMonJitterStatsOWSumSDHigh MIB type: Gauge (32 bit)
StddevOWSD	numeric(30,6)	Null	Standard deviation of one way latency SD
AvgOWSD	numeric(30,6	Null	Average of positive one way SD
MinOWSD	integer	Not Null	See MIB object: rttMonJitterStatsOWMinSDNew MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonJitterStatsOWMaxSDNew MIB type: Gauge (32 bit)
SumOWDS	integer	Not Null	See MIB object: rttMonJitterStatsOWSumDS MIB type: Gauge (32 bit)
Sum2OWDS	double	Not Null	See MIB object: rttMonJitterStatsOWSumDSHigh MIB type: Gauge (32 bit)
StddevOWDS	numeric(30,6)	Null	Standard deviation of one way latency DS
AvgOWDS	numeric(30,6)	Null	Average of positive one way DS
MinOWDS	integer	Not Null	See MIB object: rttMonJitterStatsOWMinDSNew MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonJitterStatsOWMinDSNew MIB type: Gauge (32 bit) See MIB object: rttMonJitterStatsOWMaxDSNew MIB type: Gauge (32 bit)

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 56.

Table 56 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 Min RTT
MaxRTT	Integer	Not Null	Average of all Max RTT
NumRTT	Integer	Not Null	Number of RTTs 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 positive 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 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 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	Standard deviation of positive SD
AvgNegSD	Numeric(30)	Not Null	Average of negative SD
StdDevNegSD	Numeric(30)	Not Null	Standard deviation of 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	PacketErrorPercent
OverThresholdPercent	Numeric(30)	Null	OverThresholdPercent
StdDevRTT	Numeric(30)	Null	Standared deviation of RTT
TotalPackets	Integer	Null	Total Packets
minmos	Integer	Not Null	Min MOS
maxmos	Integer	Not Null	Max MOS
minicpif	Integer	Not Null	Min ICPIF
maxicpif	Integer	Not Null	Max ICPIF
NumOfOW	integer	Not Null	See MIB object: rttMonJitterStatsNumOfOW MIB type: Gauge (32 bit)
SumOWSD	integer	Not Null	See MIB object: rttMonJitterStatsOWSumSD MIB type: Gauge (32 bit)
Sum2OWSD	double	Not Null	See MIB object: rttMonJitterStatsOWSumSDHigh MIB type: Gauge (32 bit)
StddevOWSD	numeric(30,6)	Null	Standard deviation of one way latency SD
AvgOWSD	numeric(30,6	Null	Average of positive one way SD
MinOWSD	integer	Not Null	See MIB object: rttMonJitterStatsOWMinSDNew MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonJitterStatsOWMaxSDNew MIB type: Gauge (32 bit)
SumOWDS	integer	Not Null	See MIB object: rttMonJitterStatsOWSumDS MIB type: Gauge (32 bit)
Sum2OWDS	double	Not Null	See MIB object: rttMonJitterStatsOWSumDSHigh MIB type: Gauge (32 bit)
StddevOWDS	numeric(30,6)	Null	Standard deviation of one way latency DS
AvgOWDS	numeric(30,6)	Null	Average of positive one way DS
MinOWDS	integer	Not Null	See MIB object: rttMonJitterStatsOWMinDSNew MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonJitterStatsOWMinDSNew MIB type: Gauge (32 bit) See MIB object: rttMonJitterStatsOWMaxDSNew MIB type: Gauge (32 bit)

ICMP_Jitter_Minute_Stats Table

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

Table 57 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	Start time
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
NumOfOW	integer	Not Null	See MIB object: rttMonLatestJitterOperNumOfOW MIB type: Gauge (32 bit)
SumOWSD	integer	Not Null	See MIB object: rttMonLatestJitterOperNumOfOW MIB type: Gauge (32 bit) See MIB object: rttMonLatestIcmpJitterOWSumSD MIB type: Gauge (32 bit)
Sum2OWSD	double	Not Null	See MIB object: rttMonLatestIcmpJitterOWSum2SD MIB type: Gauge (32 bit)
StddevOWSD	numeric(30,6)	Null	Standard deviation of one way latency SD
AvgOWSD	numeric(30,6	Null	See MIB object: rttMonLatestIcmpJitterOWAvgSD
MinOWSD	integer	Not Null	See MIB object: rttMonLatestIcmpJitterOWMinSD MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonLatestIcmpJitterOWMaxSD MIB type: Gauge (32 bit)
SumOWDS	integer	Not Null	See MIB object: rttMonLatestIcmpJitterOWSumDS MIB type: Gauge (32 bit)
Sum2OWDS	double	Not Null	See MIB object: rttMonLatestIcmpJitterOWSum2DS MIB type: Gauge (32 bit)
StddevOWDS	numeric(30,6)	Null	Standard deviation of one way latency
AvgOWDS	numeric(30,6)	Null	See MIB object: rttMonLatestIcmpJitterOWAvgDS
MinOWDS	integer	Not Null	See MIB object: rttMonLatestIcmpJitterOWMinDS MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonLatestIcmpJitterOWMaxDS MIB type: Gauge (32 bit)

ICMP_Jitter_Hourly_Stats Table

The ICMP Jitter Hourly Statistics table is given in Table 58

Table 58 ICMP_Jitter_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 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 squares of RTTs of all positive jitter values for 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 squares of RTTs of all negative jitter values for 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	See MIB object: rttMonIcmpJitterStatsSumNegDSes MIB type: Gauge (32 bit)
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
NumOfOW	integer	Not Null	See MIB object: rttMonIcmpJitterStatsNumOWs MIB type: Gauge (32 bit)
SumOWSD	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWSumSDs MIB type: Gauge (32 bit)
Sum2OWSD	double	Not Null	See MIB object: rttMonIcmpJStatsOWSum2SDHighs MIB type: Gauge (32 bit)
StddevOWSD	numeric(30,6)	Null	Standard deviation of one way latency SD
AvgOWSD	numeric(30,6)	Null	Average of positive one way SD
MinOWSD	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMinSD MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMaxSD MIB type: Gauge (32 bit)
SumOWDS	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWSumDSes MIB type: Gauge (32 bit)
Sum2OWDS	double	Not Null	See MIB object: rttMonIcmpJStatsOWSum2DSHighs MIB type: Gauge (32 bit)
StddevOWDS	numeric(30,6)	Null	Standard deviation of one way latency DS
AvgOWDS	numeric(30,6)	Null	Average of positive one way DS
MinOWDS	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMinDS MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMaxDS MIB type: Gauge (32 bit)

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 59.

Table 59 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 squares
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 of the squares 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 of the squares 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 of the squares 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 of the squares 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 packets
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
NumOfOW	integer	Not Null	See MIB object: rttMonIcmpJitterStatsNumOWs MIB type: Gauge (32 bit)
SumOWSD	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWSumSDs MIB type: Gauge (32 bit)
Sum2OWSD	double	Not Null	See MIB object: rttMonIcmpJStatsOWSum2SDHighs MIB type: Gauge (32 bit)
StddevOWSD	numeric(30,6)	Null	Standard deviation of one way latency SD
AvgOWSD	numeric(30,6	Null	Average of positive one way SD
MinOWSD	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMinSD MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMaxSD MIB type: Gauge (32 bit)
SumOWDS	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWSumDSes MIB type: Gauge (32 bit)
Sum2OWDS	double	Not Null	See MIB object: rttMonIcmpJStatsOWSum2DSHighs MIB type: Gauge (32 bit)
StddevOWDS	numeric(30,6)	Null	Standard deviation of one way latency DS
AvgOWDS	numeric(30,6)	Null	Average of positive one way DS
MinOWDS	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMinDS MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMaxDS MIB type: Gauge (32 bit)

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 60.

Table 60 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 week.
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 square
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 packets
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
NumOfOW	integer	Not Null	See MIB object: rttMonIcmpJitterStatsNumOWs MIB type: Gauge (32 bit)
SumOWSD	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWSumSDs MIB type: Gauge (32 bit)
Sum2OWSD	double	Not Null	See MIB object: rttMonIcmpJStatsOWSum2SDHighs MIB type: Gauge (32 bit)
StddevOWSD	numeric(30,6)	Null	Standard deviation of one way latency SD
AvgOWSD	numeric(30,6	Null	Average of positive one way SD
MinOWSD	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMinSD MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMaxSD MIB type: Gauge (32 bit)
SumOWDS	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWSumDSes MIB type: Gauge (32 bit)
Sum2OWDS	double	Not Null	See MIB object: rttMonIcmpJStatsOWSum2DSHighs MIB type: Gauge (32 bit)
StddevOWDS	numeric(30,6)	Null	Standard deviation of one way latency DS
AvgOWDS	numeric(30,6)	Null	Average of positive one way DS
MinOWDS	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMinDS MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMaxDS MIB type: Gauge (32 bit)

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 61.

Table 61 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 square
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 packets
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
NumOfOW	integer	Not Null	See MIB object: rttMonIcmpJitterStatsNumOWs MIB type: Gauge (32 bit)
SumOWSD	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWSumSDs MIB type: Gauge (32 bit)
Sum2OWSD	double	Not Null	See MIB object: rttMonIcmpJStatsOWSum2SDHighs MIB type: Gauge (32 bit)
StddevOWSD	numeric(30,6)	Null	Standard deviation of one way latency SD
AvgOWSD	numeric(30,6	Null	Average of positive one way SD
MinOWSD	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMinSD MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMaxSD MIB type: Gauge (32 bit)
SumOWDS	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWSumDSes MIB type: Gauge (32 bit)
Sum2OWDS	double	Not Null	See MIB object: rttMonIcmpJStatsOWSum2DSHighs MIB type: Gauge (32 bit)
StddevOWDS	numeric(30,6)	Null	Standard deviation of one way latency DS
AvgOWDS	numeric(30,6)	Null	Average of positive one way DS
MinOWDS	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMinDS MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonIcmpJitterStatsOWMaxDS MIB type: Gauge (32 bit)

Ethernet_Jitter_Minute_Stats Table

The Ethernet_Jitter_Minute_Stats table is given in Table 62.

Table 62 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 Hourly Statistics table is given in Table 63.

Table 63 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	Overthreshold 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 64.

Table 64 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 of the squares 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 unprocessed frames
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 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	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	Overthershold 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 65.

Table 65 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 of the 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 of the 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 of the 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 of the square of negative DS
numcomplete	Integer	Not Null	Number of completions
numoverthresh	Integer	Not Null	Number of overthreshold
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 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	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 percentage
OverThresholdPercent	Numeric(30,6)	Null	Overthershold 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 66.

Table 66 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 of the 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 of the 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 of the 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 of the 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 of the 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 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
OverThreshold Percent	Numeric(30,6)	Null	Over threshold percentage
StdDevRTT	Numeric(30,6)	Null	Standard deviation of RTT
TotalPackets	Integer	Null	Total packets

Http_Minute_Stats Table

The HTTP Minute Statistics table is given in Table 67.

Table 67 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 68.

Table 68 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 of the 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 overthresholds. 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 69.

Table 69 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 of the 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	Overthreshold 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 70.

Table 70 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 of the 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 71.

Table 71 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 MaxRTT.
RTTSum	Integer	Not Null	Sum of all RTT
SumOfSquaredRTT	Double	Not Null	Sum of the 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	Overthreshold 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 72.

Table 72 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 of the 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 overthresholds. 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
StandardDeviation	Numeric(30)	Not Null	Standard deviation
OverThres_Percent	Numeric(30)	Not Null	Overthreshold percentage
Error_Percent	Numeric(30)	Not Null	Error percentage
Availability_ Percent	Numeric(30)	Not Null	Availability Percent

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 73.

Table 73 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 of the square of all RTT
NumCompletions	Integer	Not Null	Number of completions.
NumOverThresholds	Integer	Not Null	Number of overthresholds.
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	Overthreshold percentage
Error_Percent	Numeric(30)	Not Null	Error percentage
Availability_Percent	Numeric(30)	Not Null	Availability percentage

PATHECHO_Weekly_Stats Table

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

Table 74 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 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
SumSqrdRTT	Integer	Not Null	Sum square of all RTT
NumCompletions	Integer	Not Null	Number of completions.
NumOverThresholds	Integer	Not Null	Number of overthresholds.
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	Overthreshold percentage
Error_Percent	Numeric(30)	Not Null	Error percentage
Availability_Percent	Numeric(30)	Not Null	Availability percentage

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 75.

Table 75 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 of the 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	Overthreshold percentage
Error_Percent	Numeric(30)	Not Null	Error percentage
Availability_Percent	Numeric(30)	Not Null	Availability Percent

RTP_Minute_Stats Table

The RTP Minute Statisics table is given in Table 76.

Table 76 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)
AvgOWSD	numeric(30,6	Not Null	See MIB object: rttMonLatestRtpOperAvgOWSD MIB type: Gauge (32 bit)
MinOWSD	integer	Not Null	See MIB object: rttMonLatestRtpOperMinOWSD MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonLatestRtpOperMaxOWSD MIB type: Gauge (32 bit)
AvgOWDS	numeric(30,6)	Not Null	See MIB object: rttMonLatestRtpOperAvgOWDS MIB type: Gauge (32 bit)
MinOWDS	integer	Not Null	See MIB object: rttMonLatestRtpOperMinOWDS MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonLatestRtpOperMaxOWDS MIB type: Gauge (32 bit)

RTP_Hourly_Stats Table

The RTP Hourly Statistics table is given in Table 77.

Table 77 RTP_Hourly_Stats Table  

Column Name	Type	Constraints	Description
rowID	bigint	Not Null	Unique identifier
CollectorID	bigint	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)
AvgOWSD	numeric(30,6	Not Null	See MIB object: rttMonRtpStatsOperAvgOWSD MIB type: Gauge (32 bit)
MinOWSD	integer	Not Null	See MIB object: rttMonRtpStatsOperMinOWSD MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonRtpStatsOperMaxOWSD MIB type: Gauge (32 bit)
AvgOWDS	numeric(30,6)	Not Null	See MIB object: rttMonRtpStatsOperAvgOWDS MIB type: Gauge (32 bit)
MinOWDS	integer	Not Null	See MIB object: rttMonRtpStatsOperMinOWDS MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonRtpStatsOperMaxOWDS 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 78

Table 78 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
AvgOWSD	numeric(30,6	Not Null	See MIB object: rttMonRtpStatsOperAvgOWSD MIB type: Gauge (32 bit)
MinOWSD	integer	Not Null	See MIB object: rttMonRtpStatsOperMinOWSD MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonRtpStatsOperMaxOWSD MIB type: Gauge (32 bit)
AvgOWDS	numeric(30,6)	Not Null	See MIB object: rttMonRtpStatsOperAvgOWDS MIB type: Gauge (32 bit)
MinOWDS	integer	Not Null	See MIB object: rttMonRtpStatsOperMinOWDS MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonRtpStatsOperMaxOWDS MIB type: Gauge (32 bit)

RTP_Weekly _Stats Table

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

Table 79 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
AvgOWSD	numeric(30,6	Not Null	See MIB object: rttMonRtpStatsOperAvgOWSD MIB type: Gauge (32 bit)
MinOWSD	integer	Not Null	See MIB object: rttMonRtpStatsOperMinOWSD MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonRtpStatsOperMaxOWSD MIB type: Gauge (32 bit)
AvgOWDS	numeric(30,6)	Not Null	See MIB object: rttMonRtpStatsOperAvgOWDS MIB type: Gauge (32 bit)
MinOWDS	integer	Not Null	See MIB object: rttMonRtpStatsOperMinOWDS MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonRtpStatsOperMaxOWDS MIB type: Gauge (32 bit)

RTP_Monthly_Stats Table

The RTP Monthly Statistics table is given in Table 80.

Table 80 RTP_Monthly_Stats Table  

Column Name	Type	Constraints	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
AvgOWSD	numeric(30,6	Not Null	See MIB object: rttMonRtpStatsOperAvgOWSD MIB type: Gauge (32 bit)
MinOWSD	integer	Not Null	See MIB object: rttMonRtpStatsOperMinOWSD MIB type: Gauge (32 bit)
MaxOWSD	integer	Not Null	See MIB object: rttMonRtpStatsOperMaxOWSD MIB type: Gauge (32 bit)
AvgOWDS	numeric(30,6)	Not Null	See MIB object: rttMonRtpStatsOperAvgOWDS MIB type: Gauge (32 bit)
MinOWDS	integer	Not Null	See MIB object: rttMonRtpStatsOperMinOWDS MIB type: Gauge (32 bit)
MaxOWDS	integer	Not Null	See MIB object: rttMonRtpStatsOperMaxOWDS MIB type: Gauge (32 bit)

video_oper Table

The Video Operation table is given in Table 81.

Table 81 video_oper Table  

Column Name	Type	Constraints	Description
OperationID	bigint	PRIMARY	Reference to operation(ID)
srcPort	integer	Not Null	Source Port number
tgtPort	integer	Not Null	Target Port number
callDuration	integer	Not Null	Call duration in the range of 1 — 600 seconds. Default is 20 seconds.
profileName	varchar(255)	Not Null	Name of the video profile denoting the type of Video traffic. The profiles could be IPTV, IPVSC, and Telepresence.

Video_Minute_Stats Table

The Video Minute Statistics table is given in Table 82.

Table 82 Video_Minute_Stats Table  

Column Name	Type	Constraints	Description
rowid	bigint	Not Null	Unique identifier
starttime	timestamp	Not Null	Start time of the collector
minofposisd	integer	Not Null	Minimum of positive SD
maxofposisd	integer	Not Null	Maximum of positive SD
AvgPosSD	numeric(30,6)	Not Null	Average of positive SD
numofposisd	integer	Not Null	Number of positive SD
sumofposisd	integer	Not Null	Sum of positive SD
sum2posisd	double	Not Null	Sum squared of positive SD
StdDevPosSD	numeric(30,6)	Not Null	Standard deviation of positive SD
minofnegasd	integer	Not Null	Minimum of negative SD
maxofnegasd	integer	Not Null	Maximum of negative SD
AvgNegSD	numeric(30,6)	Not Null	Average 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
StdDevNegSD	numeric(30,6)	Not Null	Standard deviation of negative SD
NumOfOWSD	integer	Not Null	Number of one way SD
SumOWSD	double	Not Null	Sum of one way SD
Sum2OWSD	double	Not Null	Sum squared of one way SD
StddevOWSD	numeric(30,6)	Not Null	Standard deviation of one way SD
AvgOWSD	numeric(30,6)	Not Null	Average of positive one way SD
MinOWSD	integer	Not Null	Minimum of one way SD
MaxOWSD	integer	Not Null	Maximum of one way SD
numpacketlossSD	integer	Not Null	Number of packet loss SD
PktOutSeq	integer	Not Null	Number of packet out sequence
PktLateArrival	integer	Not Null	Number of packet arrived late
UnSyncRTs	integer	Not Null	Number of unsync round trips
AvgJitterSD	integer	Not Null	Average Jitter SD
IAJOut	integer	Not Null	Inter-arrival Jitter Out
IPDVAvgSDJ	integer	Not Null	Source to Destination IPDV average jitter
VideoSense	integer	Not Null	Application specific sense code for the completion status.
NTPState	integer	Not Null	Value of sync(1) means sender and responder was in sync with NTP
ErrorSenseDescr	varchar	Not Null	Sense description for the completion status of the latest video operation.
CollectorID	bigint	Not Null	Collector (Running Instance) ID.

Video_Hourly_Stats Table

The Video Hourly Statistics table is given in Table 83.

Table 83 Video_Hourly_Stats Table  

Column Name	Type	Constraints	Description
starttime	timestamp	Not Null	Start time of the collector
numvideoCompletions	integer	Not Null	Number of video completions
numOverThresholds	integer	Not Null	Number of overthresholds
minofposisd	integer	Not Null	Minimum of positive SD
maxofposisd	integer	Not Null	Maximum of positive SD
AvgPosSD	numeric(30,6)	Not Null	Average of positive SD
numofposisd	integer	Not Null	Number of positive SD
sumofposisd	integer	Not Null	Sum of positive SD
sum2posisd	double	Not Null	Sum squared of positive SD
StdDevPosSD	numeric(30,6)	Not Null	Standard deviation of positive SD
minofnegasd	integer	Not Null	Minimum of negative SD
maxofnegasd	integer	Not Null	Maximum of negative SD
AvgNegSD	numeric(30,6)	Not Null	Average 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
StdDevNegSD	numeric(30,6)	Not Null	Standard deviation of negative SD
NumOfOW	integer	Not Null	Number of one way SD
SumOWSD	double	Not Null	Sum of one way SD
Sum2OWSD	double	Not Null	Sum squared of one way SD
StddevOWSD	numeric(30,6)	Not Null	Standard deviation of one way SD
AvgOWSD	numeric(30,6)	Not Null	Average of positive one way SD
MinOWSD	integer	Not Null	Minimum of one way SD
MaxOWSD	integer	Not Null	Maximum of one way SD
numpacketlossSD	integer	Not Null	Number of packet loss SD
PktOutSeq	integer	Not Null	Number of packet out sequence
PktLateArrival	integer	Not Null	Number of packet arrived late
PktSkipped	integer	Not Null	Number of packet skipped
Errors	integer	Not Null	Number of errors
Busies	integer	Not Null	Number of busies
UnSyncRTs	integer	Not Null	Number of unsync round trips
AvgJitterSD	integer	Not Null	Average Jitter SD
IAJOut	integer	Not Null	Inter-arrival Jitter Out
IAJIn	integer	Not Null	Inter-arrival Jitter In
numTries	integer	Not Null	Number of tries
Error_perc	numeric(30,6)	Not Null	Error percentage
OverThreshold_perc	numeric(30,6)	Not Null	Over threshold percentage
Completion_perc	numeric(30,6)	Not Null	Completion percentage
Packet_Error_perc	numeric(30,6)	Not Null	Packet error percentage
CollectorID	bigint	Not Null	Collector (Running Instance) ID.

Video_Daily_Stats Table

The Video Daily Statistics table is given in Table 84.

Table 84 Video_Daily_Stats Table  

Column Name	Type	Constraints	Description
starttime	timestamp	Not Null	Start time of the collector
numvideoCompletions	integer	Not Null	Number of video completions
numOverThresholds	integer	Not Null	Number of overthresholds
minofposisd	integer	Not Null	Minimum of positive SD
maxofposisd	integer	Not Null	Maximum of positive SD
AvgPosSD	numeric(30,6)	Not Null	Average of positive SD
numofposisd	integer	Not Null	Number of positive SD
sumofposisd	integer	Not Null	Sum of positive SD
sum2posisd	double	Not Null	Sum squared of positive SD
StdDevPosSD	numeric(30,6)	Not Null	Standard deviation of positive SD
minofnegasd	integer	Not Null	Minimum of negative SD
maxofnegasd	integer	Not Null	Maximum of negative SD
AvgNegSD	numeric(30,6)	Not Null	Average 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
StdDevNegSD	numeric(30,6)	Not Null	Standard deviation of negative SD
NumOfOW	integer	Not Null	Number of one way SD
SumOWSD	double	Not Null	Sum of one way SD
Sum2OWSD	double	Not Null	Sum squared of one way SD
StddevOWSD	numeric(30,6)	Not Null	Standard deviation of one way SD
AvgOWSD	numeric(30,6)	Not Null	Average of positive one way SD
MinOWSD	integer	Not Null	Minimum of one way SD
MaxOWSD	integer	Not Null	Maximum of one way SD
numpacketlossSD	integer	Not Null	Number of packet loss SD
PktOutSeq	integer	Not Null	Number of packet out sequence
PktLateArrival	integer	Not Null	Number of packet arrived late
PktSkipped	integer	Not Null	Number of