CiscoWorks LAN Management Solution

Table Of Contents

Open Database Schema Support in CiscoWorks LAN Management Solution 3.2

Contents

Enabling Access to Database

Accessing Database Views

Accessing Database From a Local Server

Accessing Database Using Jconnect JDBC Access Method

Accessing Database Using iAnyWhere JDBC Access Method

Accessing Database Using ODBC Access Method

Accessing the Database From a Remote Server

Prerequisites for Accessing Database Views on Windows Systems

Prerequisites for Accessing Database Views on Solaris Systems

Sample Code to Access Database From a Remote Server

Changing the Database Password

Exposed Database Views and Tables

Schema of Exposed Database Views

Network_Devices View Details

Job_Details View Details

End_Hosts View Details

Device_Inventory View Details

Module_Inventory View Details

Port_Inventory View Details

Processor_Inventory View Details

Memory_Inventory View Details

Device_Credential_Status View Details

Device_Inventory_Collection_Status View Details

Device_Config_Archive_Status View Details

Change_Audit_History View Details

Syslog_Today or Syslog_Lastday View Details

Fault_Alert_History View Details

Fault_Event_History View Details

Fault_Event_Details View Details

IPM Database Schema

Connecting to IPM Database

Schema of IPM Database Tables

Source Table

Target Table

IPMDevice Table

Operation Table

IPEchoOper Table

UDPEchoOper Table

PathEchoOper Table

jitter_oper Table

ICMPJitterOper Table

RTPOper Table

ethernet_oper Table

http_oper Table

dns_oper Table

ftp_oper Table

dhcp_oper Table

DLSwOper Table

PostDialDelayOper Table

tcpconnect_oper Table

React Table

Collector Table

VrfList Table

outage_details Table

completed_outages Table

Collector _Schedule Table

Latency_Minute_Stats Table

Availability_Latency_Hourly_Stats Table

Availability_Latency_Daily_Stats Table

Availability_Latency_Weekly_Stats Table

Availability_Latency_Monthly_Stats Table

Jitter_Minute_Stats Table

Jitter_Hourly_Stats Table

Jitter_Daily_Stats Table

Jitter_Weekly_Stats Table

Jitter_Monthly_Stats Table

ICMP_Jitter_Minute_Stats Table

ICMP_Jitter_Hourly_Stats Table

ICMP_Jitter_Daily_Stats Table

ICMP_Jitter_Weekly_Stats Table

ICMP_Jitter_Monthly_Stats Table

Ethernet_Jitter_Minute_Stats Table

Ethernet_Jitter_Hourly_Stats Table

Ethernet_Jitter_Daily_Stats Table

Ethernet_Jitter_Weekly_Stats Table

Ethernet_Jitter_Monthly_Stats Table

Http_Minute_Stats Table

Http_Hourly_Stats Table

Http_Daily_Stats Table

Http_Weekly_Stats Table

Http_Monthly_Stats Table

PATHECHO_Hourly_Stats Table

PATHECHO_Daily_Stats Table

PATHECHO_Weekly_Stats Table

PATHECHO_Monthly_Stats Table

RTP_Minute_Stats Table

RTP_Hourly_Stats Table

RTP_Daily_Stats Table

RTP_Weekly _Stats Table

RTP_Monthly_Stats Table

Open Database Schema Support in CiscoWorks LAN Management Solution 3.2

---

Contents

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

•Enabling Access to Database

•Accessing Database Views

•Exposed Database Views and Tables

•Schema of Exposed Database Views

•IPM Database Schema

Enabling Access to Database

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

You must run:

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

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

where,

•NMSROOT — Default CiscoWorks installation directory

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

•clean — Command line parameter that cleans the existing views

•debug — Prints the debug and warning messages on the screen

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

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

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

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

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

You can ignore these warning messages.

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

Accessing Database Views

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

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

You can access the created views either from:

•The local CiscoWorks Server.

Or

•A remote server with or without CiscoWorks installed.

This section contains:

•Accessing Database From a Local Server

•Accessing the Database From a Remote Server

Accessing Database From a Local Server

This section contains the sample code for:

•Accessing Database Using Jconnect JDBC Access Method

•Accessing Database Using iAnyWhere JDBC Access Method

•Accessing Database Using ODBC Access Method

Accessing Database Using Jconnect JDBC Access Method

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

import java.util.Date;

import java.sql.*;

public class JdbcAccess {

	private static Connection conn;

	private static Statement stmt;

	private static ResultSet rs;

	/**

	 * @param args

	 */

	public static void main(String[] args) throws SQLException, ClassNotFoundException {

		Class.forName("com.sybase.jdbc2.jdbc.SybDriver");

		// The following information such as port, and service names are to be 	

		// changed based on the application database that you want to connect. 

		// For example, conn = DriverManager.getConnection("jdbc:sybase:Tds:localhost:

		// <ServerPort>?SERVICENAME=<DBName>","<View username>","<View password>");

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

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

		//Create Statement now

		stmt = conn.createStatement();

		String query = "SELECT Device_Id, Device_Display_Name, Management_IPAddress FROM 
Network_Devices";

		rs = stmt.executeQuery(query);

		while (rs.next()) {

			System.out.println("Device_Id: " + rs.getString("Device_Id"));

			System.out.println("Device_Display_Name: " + 
rs.getString("Device_Display_Name"));

			System.out.println("Management_IPAddress" + 
rs.getString("Management_IPAddress"));

System.out.println("-----------------------------------------------------------");

		}

	}

}

---

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

---

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

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

where,

•localhost —Local CiscoWorks Server.

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

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

•lmsdatafeed — Default database view username

•dbpasswd — Database view password

Application Database Names and Port Number Details

The application database names are given in the table below:

Application	Database Name	Port Number to Connect to Database
Common Services	cmfDb	43441
Campus Manager	aniDb	43443
Resource Manager Essentials	rmengdb	43455
Device Fault Manager (DFM Fault History)	dfmFhDb	43445

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

Accessing Database Using iAnyWhere JDBC Access Method

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

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","dbpasswd");

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

		//Create Statement now

		stmt = conn.createStatement();

		String query = "SELECT Device_Id, Device_Display_Name, Management_IPAddress FROM 
Network_Devices";

		rs = stmt.executeQuery(query);

		while (rs.next()) {

			System.out.println("Device_Id: " + rs.getString("Device_Id"));

			System.out.println("Device_Display_Name: " + 
rs.getString("Device_Display_Name"));

			System.out.println("Management_IPAddress" + 
rs.getString("Management_IPAddress"));

System.out.println("-----------------------------------------------------------");

		}

	}

}

---

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

---

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

conn = DriverManager.getConnection("jdbc:odbc:dsn=cmf","lmsdatafeed","dbpasswd"); 

where,

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

•lmsdatafeed — Default database view username

•dbpasswd — Database view password

Application Data Source Names

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

Application	Data Source Name (dsn)
Common Services	cmf
Campus Manager	ani
Resource Manager Essentials	rmeng
Device Fault Manager (DFM Fault History)	dfmFh

Accessing Database Using ODBC Access Method

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

use DBI;

my ($dbh, $cur, $sqlstr);

my $connString = "dsn=cmf;uid=lmsdatafeed";

$dbh = DBI->connect('DBI:ASAny:', $connString, 'dbpasswd', {PrintError => 1});

if ($dbh) {

   my $sqlstr = "SELECT Device_Id, Device_Display_Name, Management_IPAddress FROM 
Network_Devices";

   my $cur = $dbh->prepare($sqlstr);

   $cur->execute if ($cur);

   while (my $rs = $cur->fetchrow_arrayref) {

      my ($devId, $dispName, $ip,) = @$rs;

      print "Device_Id: $devId\n";

      print "Device_Display_Name: $dispName\n";

      print "Management_IPAddress: $ip\n";

      print "--------------------------------------------\n";

   }

   $cur->finish;

   $dbh->disconnect();

}

To run this perl code on CiscoWorks Server:

---

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

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

Step 3 Save the changes to the perl file.

Step 4 Run the perl script using the following commands:

•NMSROOT/bin/perl Perl_file_name (on Solaris systems)

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

where,

•NMSROOT — CiscoWorks Installation directory.

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

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

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

---

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

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

where,

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

•lmsdatafeed — Default database view username

•dbpasswd — Database view password

Accessing the Database From a Remote Server

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

•Prerequisites for Accessing Database Views on Windows Systems

•Prerequisites for Accessing Database Views on Solaris Systems

•Sample Code to Access Database From a Remote Server

Prerequisites for Accessing Database Views on Windows Systems

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

•Copy the CiscoWorks files to the remote Windows server

•Create DSNs in the remote Windows server

This section explains:

•Copying CiscoWorks files to a Remote Windows Server

•Creating DSNs on Windows Systems

Copying CiscoWorks files to a Remote Windows Server

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

•NMSROOT\lib\classpath\jconn2.jar

•NMSROOT\lib\classpath\jodbc.jar

•NMSROOT\objects\db\win32\dbodbc10.dll

•NMSROOT\objects\db\win32\dblgen10.dll

•NMSROOT\objects\db\win32\dbcon10.dll

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

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

Creating DSNs on Windows Systems

To create DSNs and configure ODBC on Windows system:

---

Step 1 Launch the Registry Editor on remote Windows server.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

The ODBC Data Source Administrator dialog box appears.

Step 14 Click the System DSN tab.

Step 15 Click the Add... button.

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

Step 16 Select CiscoWorks Embedded Database and click Finish.

The ODBC Configuration for SQL Anywhere 10 dialog box appears.

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

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

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

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

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

The default database view user name is lmsdatafeed.

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

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

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

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

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

Step 25 Click the Network tab.

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

where,

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

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

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

HOST=10.77.213.130;DOBROADCAST=NO;ServerPort=43441

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

Step 28 Click OK to apply the changes.

---

Application Database Engine Name Details

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

Application	Database Engine Name
Common Services	cmfEng
Campus Manager	aniEng
Resource Manager Essentials	rmengEng
Device Fault Manager (DFM Fault History)	dfmFhEng

Prerequisites for Accessing Database Views on Solaris Systems

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

•Copy the CiscoWorks files to a remote Solaris server

•Create DSNs on a remote Solaris server

This section explains:

•Copying CiscoWorks files to a Remote Solaris Server

•Creating DSNs on Solaris Systems

Copying CiscoWorks files to a Remote Solaris Server

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

•NMSROOT/lib/classpath/jconn2.jar

•NMSROOT/lib/classpath/jodbc.jar

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

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

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

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

Creating DSNs on Solaris Systems

To create DSNs on Solaris systems:

---

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

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

[Application Name]

EngineName=Name_of _the _Application_Engine

PWD=Password

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

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

UID=Default_Database_View_User_Name

Description=CiscoWorks Embedded Database

where,

•CiscoWorks_Server_Name— Default CiscoWorks installation directory.

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

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

•Password — Password used to connect to the database

•CiscoWorks_Server_Name — Hostname or IP Address of the remote CiscoWorks Server which you want to connect to

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

•Database_View_User_Name — Database view user name. The default username is lmsdatafeed.

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

[cmf]

EngineName=cmfEng

PWD=cisco

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

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

UID=lmsdatafeed

Description=CiscoWorks Embedded Database

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

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

setenv ODBCINI /opt/.odbc.ini

---

Sample Code to Access Database From a Remote Server

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

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

•Accessing Database Using Jconnect JDBC Access Method

•Accessing Database Using iAnyWhere JDBC Access Method

•Accessing Database Using ODBC Access Method

Changing the Database Password

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

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

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

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

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

Exposed Database Views and Tables

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

Table 1 Exposed Database Views and Tables

CiscoWorks Application	Name of Views or Tables
Common Services (CS) Views	Network_Devices
	Job_Details
Campus Manager (CM) Views	End_Hosts
Device Fault Manager (DFM) Views	Fault_Alert_History
	Fault_Event_History
	Fault_Event_Details
Resource Manager Essentials (RME) Views	Device_Inventory
	Module_Inventory
	Port_Inventory
	Processor_Inventory
	Memory_Inventory
	Device_Credential_Status
	Device_Inventory_Collection_Status
	Device_Config_Archive_Status
	Change_Audit_History
	Syslog_Today
	Syslog_Lastday
Internetwork Performance Monitor (Tables)	Source (Source Table)
	Target (Target Table)
	IPMDevice (IPM Device Table )
	IPEchoOper (IPEcho Sub-Operation Table)
	UDPEchoOper (UDP Echo Sub-Operation Table)
	PathEchoOper (PathEcho Sub-Operation Table)
	jitter_oper (Jitter Sub-Operation Table)
	ICMPJitterOper (ICMP Jitter Sub-Operation Table)
	RTPOper (RTP Sub-Operation Table)
	ethernet_oper (Ethernet Sub-Operation Table)
	http_oper (HTTP Operation Table)
	dns_oper (DNS Operation Table)
	ftp_oper (FTP Operation Table)
	dhcp_oper (DHCP Operation Table)
	DLSwOper (DLSw Operation Table)
	PostDialDelayOper (Post Dial Delay Operation Table)
	tcpconnect_oper (TcpConnect Operation Table)
	ReactTable (React Table)
	Collector (Collector Table)
	VrfList (VRF List Table)
	outage_details (Outage Details Table)
	completed_outages (Completed Outage Table)
	Collector_Schedule (Collector Schedule Table)
	Latency_Minute_Stats (Latency Minute Statistics Table)
	Availability_Latency_Hourly_Stats (Availability Latency Hourly Statistics Table)
Internetwork Performance Monitor (Tables) (continued)	Availability_Latency_Daily_Stats (Availability Latency Daily Statistics Table)
	Availability_Latency_Weekly_Stats (Availability Latency Weekly Statistics Table0
	Availability_Latency_Monthly_Stats (Availability Latency Monthly Statistics Table)
	Jitter_Minute_Stats (Jitter Minute Statistics Table)
	Jitter_Hourly_Stats (Jitter Hourly Statistics Table )
	Jitter_Daily_Stats (Jitter Daily Statistics Table)
	Jitter_Weekly_Stats (Jitter Weekly Statistics Table)
	Jitter_Monthly_Stats (Jitter Monthly Statistics Table)
	ICMP_Jitter_Minute_Stats (ICMP Jitter Minute Statistics Table)
	ICMP_Jitter_Hourly_Stats (ICMP Jitter Hourly Statistics Table)
	ICMP_Jitter_Daily_Stats (ICMP Jitter Daily Statistics Table)
	ICMP_Jitter_Weekly_Stats (ICMP Jitter Weekly Statistics Table)
	ICMP_Jitter_Monthly_Stats (ICMP Jitter Monthly Statistics Table)
	Ethernet_Jitter_Minute_Stats (Ethernet Jitter Minute Statistics Table)
	Ethernet_Jitter_Hourly_Stats (Ethernet Jitter Hourly Statistics Table)
	Ethernet_Jitter_Daily_Stats (Ethernet Jitter Daily Statistics Table)
	Ethernet_Jitter_Weekly_Stats (Ethernet Jitter Weekly Statistics Table)
	Ethernet_Jitter_Monthly_Stats (Ethernet Jitter Monthly Statistics Table)
	Http_Minute_Stats (HTTP Minute Statistics Table)
	Http_Hourly_Stats (HTTP Hourly Statistics Table)
	Http_Daily_Stats (HTTP Daily Statistics Table)
	Http_Weekly_Stats (HTTP Weekly Statistics Table)
	Http_Monthly_Stats (HTTP Monthly Statistics Table)
	PATHECHO_Hourly_Stats (Pathecho Hourly Statistics Table)
	PATHECHO_Daily_Stats (Pathecho Daily Statistics Table)
	PATHECHO_Weekly_Stats (Pathecho Weekly Statistics Table)
Internetwork Performance Monitor (Tables) (continued)	PATHECHO_Monthly_Stats (Pathecho Monthly Statistics Table)
	RTP_Minute_Stats (RTP Minute Statistics Table)
	RTP_Hourly_Stats (RTP Hourly Statistics Table)
	RTP_Daily_Stats (RTP Daily Statistics Table)
	RTP_Weekly_Stats (RTP Weekly Statistics Table )
	RTP_Monthly_Stats (RTP Monthly Statistics Table)

Schema of Exposed Database Views

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

---

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

---

It contains the details of the following views:

•Network_Devices View Details

•Job_Details View Details

•End_Hosts View Details

•Device_Inventory View Details

•Module_Inventory View Details

•Port_Inventory View Details

•Processor_Inventory View Details

•Memory_Inventory View Details

•Device_Credential_Status View Details

•Device_Inventory_Collection_Status View Details

•Device_Config_Archive_Status View Details

•Change_Audit_History View Details

•Syslog_Today or Syslog_Lastday View Details

•Fault_Alert_History View Details

•Fault_Event_History View Details

•Fault_Event_Details View Details

Network_Devices View Details

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

Table 2 Network_Devices Schema Details

Column Name	Column Type	Constraints	Column Description
Device_Id	integer	PRIMARY	DCR Device ID. Unique Identifier to the device
Device_Display_Name	varchar(128)	Not Null	Device Display Name
Management_Ip_Address	varchar(128)	Null	Management IP Address of the device
Host_Name	varchar(128)	Null	Hostname of the device
Domain_Name	varchar(128)	Null	Domain Name of the device
sysObjectID	varchar(128)	Null	SysObjectId of the device
Device_Category	varchar(512)	Null	Device category
Device_Series	varchar(512)	Null	Device Series name
Device_Model	varchar(512)	Null	Device Model name
UDF0-15	varchar(128)	Null	A maximum of 16 user-defined fields are allowed. The first field name isUDF$FieldNumber For example, UDF0.

Job_Details View Details

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

.

Table 3 Job_Details Schema Details 

Column Name	Column Type	Constraints	Column Description
Job_Id	integer	PRIMARY Job_Id, and Job_Instance_Id columns form a Primary key.	Job ID
Job_Instance_Id	integer	PRIMARY Job_Id, and Job_Instance_Id columns form a Primary key.	Job Instance ID
Job_Type	varchar(256)	Not null	Type of job
Job_Description	varchar(1024)	Null	Job description entered by user or application
Job_Sch_Type	integer	Not null	Frequency of the job. Options include: •Run immediately •Run once •Run on a calendar basis (periodic) •Run on a time-start basis •Run on a time-stop basis The integer values are: •0 — Never Ran •1 — Immediate •2 — Run Once •257 — Day of Every Month •258 — Day of Every Week •259 — Every N-th Day •260 — Last week day (Sunday, Monday, or so on) of every N-th month •261 — Same week day (Sunday, Monday, or so on) of every N-th month •262 — last day of month every N-th month •263 — Weekdays (Sun,Mon,..Sat) •513 — Every N-Seconds (Start time based) •514 — Every N-Min (Start time based) •515 — Every N-hour (Start time based) •769 — Every N-Seconds (End time based) •770 — Every N-Min (End time based) •771— Every N-hour (End time based)
Job_Run_State	integer	Not null	Describes the current state or the result of the last run of the job. The integer values are: • 0 — Scheduled (Never Ran), Missed start, Suspended, Rejected • 1 — Running • 2 — Succeeded • 3 — Succeeded with info • 4 —Failed • 5 — Crashed • 6 — Failed at Start • 7 — Cancelled • 8 — Cancelled (for Instances) • 9 — Cancelling (Job cancellation in progress)
Job_Sch_State	integer	Not null	Determines whether the job can be scheduled to run. This is based on whether it is enabled, requires approval, or has already been approved. The integer values are: • 0 — Waiting • 1 — Requires Approval • 2 — Enabled • 4 — Approved • 8 — Rejected
Job_Start_Time	timestamp	Null	Job Start Time
Job_End_Time	timestamp	Null	Job End Time
Job_Owner	varchar(32)	Null	Owner of the Job
Job_Approver	varchar(32)	Null	User who approved the job. Value is blank if there is no approver.
Job_Progress	varchar(1024)	Null	Job Progress String.

End_Hosts View Details

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

Table 4 End_Hosts Schema Details 

Column Name	Column Type	Constraints	Column Description
HostName	varchar(64)	Null	Name of the end host
UserName	varchar(64)	Null	Logged In User name
IPAddress	varchar(15)	Null	IP Address of the end host
SubnetMask	varchar(15)	Null	Subnet mask of the device to which end host is connected
MACAddress	varchar(17)	Null	MAC Address of the end host
DeviceName	varchar(64)	Null	Device Name (Host Name) to which the end host is connected
Device	varchar(15)	Null	Device IP Address to which the end host is connected
LastSeen	varchar(32)	Null	Time at which end host is last seen
Port	varchar(32)	Null	Name of the port where the end host is connected
VLAN	varchar(32)	Null	VLAN name. Example: VLAN100
Subnet	varchar(15)	Null	Subnet of the device to which end host is connected
Notes	varchar(255)	Null	Notes entered by the user
PrefixLength	integer	Null	Subnet prefix length
PortDuplex	varchar(32)	Null	Mode of the port to where end host is connected
VTPDomain	varchar(32)	Null	VTP Domain Name of the device where the end host is connected.
VlanId	integer	Null	VLAN ID Example: 100
PortName	varchar(255)	Null	Port Description entered by the user
IPv6Address	varchar(150)	Null	IPV6 address, if configured
dot1xEnabled	varchar(15)	Null	dot1x enabled status. The value could be True or False.
associatedRouters	varchar(250)	Null	Comma separated list of routers in the subnet

Device_Inventory View Details

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

Table 5 Device Inventory Schema Details  

Column Name	Column Type	Constraints	Column Description
Device_Id	integer	Not null	DCR Device ID
Device_Display_Name	varchar(128)	Not null	Device Display Name
Device_Description	varchar(255)	Null	Description of the device
Device_Location	varchar(255)	Null	Sys Location
Device_Contact	varchar(255)	Null	Sys Contact
Device_SW_Version	varchar(64)	Null	Device Software Version
User_Defined_Serial_Number	varchar(255)	Null	User-defined serial number

Module_Inventory View Details

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

Table 6 Module_Inventory Schema Details

Column Name	Column Type	Constraints	Column Description
Device_Id	integer	Not null	DCR Device ID
Device_Display_Name	varchar(128)	Not null	Device Display Name
Module_Name	varchar(255)	Null	Module
Vendor_Type	varchar(255)	Null	Module Vendor Type
SW_Version	varchar(255)	Null	Software version of the module
FW_Version	varchar(255)	Null	Firmware version of the module
Slot_Number	integer	Null	Slot Number of this module
Oper_Status	smallint	Null	Operation Status
Admin_Status	smallint	Null	Administrative status

Port_Inventory View Details

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

Table 7 Port_Inventory Schema Details  

Column Name	Column Type	Constraints	Column Description
Device_Id	integer	Not null	DCR Device ID
Device_Display_Name	varchar(128)	Not null	Device Display Name
Port_Name	varchar(255)	Null	Name of Port from ifName
Port_Desc	varchar(1024)	Null	Port description from ifDescr
Port_Type	smallint	Null	Port type. Enumeration from IANAifType MIB
Port_Admin_Status	smallint	Null	Port Administrative status
Port_Oper_Status	smallint	Null	Port Operation status
Port_Speed	float	Null	Port Speed in bits per second
Port_Duplex_Mode	varchar(15)	Null	Port Duplex Mode
Is_Link_Port	smallint	Null	0 — Configured as Link port 1— Not configured as Link port.
Is_Access_Port	smallint	Null	0 — Configured as Access port 1— Not configured as Access port.
Is_Trunk_Port	smallint	Null	0 — Configured as Trunk port 1— Not configured as Trunk port.
Is_Port_Channel	smallint	Null	0 - If etherchannels is configured and 1 otherwise
Vlan_Name	varchar(36)	Null	VLAN Name. Example: VLAN100
VlanId	integer	Null	VLAN ID. Example: 100d
VTPDomain	varchar(64)	Null	VTP Domain configured
Neighbour_Type	varchar(36)	Null	Neighbour Type. Examples: Device, EndHost, Phone

Processor_Inventory View Details

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

Table 8 Processor_Inventory Schema Details

Column Name	Column Type	Constraints	Column Description
Device_Id	Integer	Not null	DCR Device ID
Device_Display_Name	varchar(128)	Not null	Device Display Name
Processor_model_name	varchar(255)	Null	Processor Model Name, if available
Processor_module_description	varchar(255)	Null	Module description
Processor_vendor_type	varchar(255)	Null	Vendor equipment type of processor
Processor_manufacturer	varchar(255)	Null	Manufacturer, if available
serialnumber	varchar(255)	Null	Serial Number, if available

Memory_Inventory View Details

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

Table 9 Memory_Inventory Schema Details

Column Name	Column Type	Constraints	Column Description
Device_Id	Integer	Not null	DCR Device ID
Device_Display_Name	varchar(128)	Not null	Device Display Name
Processor_Memory	numeric(29,9)	Null	Processor memory. This is in Mega Bytes (MB).

.

Device_Credential_Status View Details

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

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

Table 10 Device_Credential_Status Schema Details 

Column Name	Column Type	Constraints	Column Description
Device_Id	integer	PRIMARY	DCR Device ID
Device_Display_Name	varchar(128)	Not null	Device Display Name
Credential_Type	smallint	Not null	Credential Type. The types could be: •SNMP Read Write community •SNMP Read Only •SNMPv3 •Telnet •Telnet Enable mode •SSH •SSH Enable mode
Credential_Type_Description	varchar(64)	Not null	Description of the credentials mentioned in the Credential_Type column description.
Credential_Status	smallint	Not null	Credential Check Status. The integer values could be: •1 — OK •12 — Cannot test RW without RO •11 — OK (Primary Failed, Secondary Successful) •10 — OK (Primary Successful) •9 — Not implemented yet •8 — Failed (Because of wrong credentials) •7 — Not supported •6 — No Value to Test •5 — Did Not Try •4 — No Data Yet •3— Incorrect (unable to test the credentials because of connection failure) •2— No authentication configured
Cred_Status_Description	varchar(64)	Not null	Description of the credential check status.
Cred_Status_Reason	varchar(1024)	Null	Reason for sucess or failure.
Status_Update_Time	varchar(60)	Null	Time (in milliseconds) at which the credentials are verified and updated.

Device_Inventory_Collection_Status View Details

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

Table 11 Device_Inventory_Collection_Status Schema Details

Column Name	Column Type	Constraints	Column Description
Device_Id	integer	PRIMARY	DCR Device ID
Device_Display_Name	varchar(128)	Not null	Device Display Name
Inventory_Collection_Status	integer	Null	Inventory Collection Status •1— Success •2— Failed
Failure_Reason	varchar(255)	Null	Reason for inventory connection failure. Value is blank if the connection did not fail.
Inventory_Updated_At	timestamp	Null	Time when the inventory is last updated

Device_Config_Archive_Status View Details

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

Table 12 Device_Config_Archive_Status Schema Details

Column Name	Column Type	Constraints	Column Description
Device_Id	integer	Not Null Device_Id, Config_ Type and Config_File_Type columns form a Primary key.	DCR Device ID
Device_Display_Name	varchar(128)	Not null	Device Display Name
Config_Type	integer	Not Null Device_Id, Config_ Type and Config_File_Type columns form a Primary key.	The integer values could be: •1 — Primary •2 — VLAN •3 — Secondary
Config_File_Type	integer	Not Null Device_Id, Config_ Type and Config_File_Type columns form a Primary key.	The integer values could be: •1 - STARTUP •2 - RUNNING
Archive_Status	integer	Null	Status of the Configuration archive. The integer values could be: •1 — Success •2 — Failure •3 — Partially Successful
Archive_Updated_At	timestamp	Null	Time when the Config is last updated

Change_Audit_History View Details

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

Table 13 Change_Audit_History Schema Details

Column Name	Column Type	Constraints	Column Description
Device_Id	integer	Not null	DCR Device ID
Device_Display_Name	varchar(128)	Not null	Device Display Name
Created_At	timestamp	Null	Date and time when the application communicated the network change or when Change Audit module received the change record.
User_Name	varchar(64)	Null	User who made the configuration change or discovered that there is a configuration change
App_Name	varchar(64)	Null	Application that discovered the configuration change. Archive Mgmt, ConfigEditor, CwConfig, ICServer, NetConfig, Software Management are the possible values for application names.
Host_Name	varchar(64)	Null	Host name of the machine from which the user accessed the device or the host name of the RME server. The host name can containthe IP Address if the address does not resolve to a name. The ICServer application enters the host name and the Config Archive application enters the IP Address of the server
Conn_Mode	varchar(255)	Null	Connection mode through which the change was made. SNMP, TFTP, TELNET, and CONSOLE are the possible values for connection modes
Description	varchar(1024)	Null	Change Audit description that explains which process has changed the configuration.
Category	varchar(64)	Null	Type of change. The values for this column could be: •CONFIG_CHANGE •INVENTORY_CHANGE •SOFTWARE_CHANGE

Syslog_Today or Syslog_Lastday View Details

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

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

Table 14 Syslog Schema Details

Column Name	Column Type	Constraints	Column Description
Device_Display_Name	varchar(128)	Not null	Device Display Name
Syslog_Message_Id	bigint	PRIMARY	Primary key
Syslog_Device_Id	bigint	Null	DCR device ID
Syslog_Device_Name	varchar(255)	Not null	The IP Address of the interface through which the syslog was sent.
Syslog_TimeStamp	timestamp	Null	Date and time the message was logged. This timestamp is provided by the device. Syslog Analyzer provides a timestamp if the device does not provide one.
Syslog_Facility	char(48)	Null	Facility can be a hardware device, a protocol, or a module of the system software. For example, SYS. See the System Error Messages section in the Cisco IOS reference manual for a predefined list of facility codes.
Syslog_SubFacility	char(48)	Null	SubFacility is the subfacility in the device that generated the Syslog message. In most cases, this is blank. For example, SYS-5-CONFIG I.
Syslog_Severity	char(1)	Null	Message severity level. The level varies from informational (6) to emergency (0).
Syslog_Mnemonic	char(48)	Null	Code that uniquely identifies the error message. Older Catalyst messages do not display a mnemonic. An example of a mnemonic for an IOS message is CONFIG I.
Syslog_Description	varchar(512)	Null	Syslog message description
Syslog_Category	char(1)	Null	Syslog category

Fault_Alert_History View Details

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

Table 15 Fault_Alert_History Schema Details

Column Name	Column Type	Constraints	Column Description
Device_Name	varchar(255)	Null	Device name or IP address.
Alert_Id	bigint	Not null	Alert identifier number
Alert_Category	varchar(255)	Null	Alert category. Possible values for this field could be: •Application •Connectivity •Environment •Interface •Other •Reachability •System Hardware •Utilization
Status	varchar(16)	Null	Alert status, based on last polling. The status could be: •Active — Alert is alive •Cleared — Alert is no longer live. Also, when a device is suspended, all alerts are cleared. •Acknowledged — Alert was manually recognized by a user
Severity	varchar(16)	Null	Alert severity. The severity can be Critical, or Informational.
Alert_Update_Time	bigint	Null	Date and time when the alert was generated. The time is the number of seconds elapsed from Jan 1 1970

Fault_Event_History View Details

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

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

Table 16 Fault_Event_History Schema Details

Column Name	Column Type	Constraints	Column Description
Device_Name	varchar(255)	Null	Device name or IP address.
Event_Id	bigint	Not null	Event identifier number.
Alert_Id	bigint	Not null	Alert identifier number
Event_Name	varchar(255)	Null	DFM event name. See the DFM Online help for the list of events processed by DFM.
Event_Status	varchar(16)	Null	Event status, based on last polling. The status could be: •Active — Event is live. •Cleared — Event is no longer live. Events on suspended devices are moved to Cleared, but the alert remains active. •Suspended — Device is suspended. •Resumed — Device is being resumed. •Deleted — Device has been deleted
Component_Name	varchar(255)	Null	Device element on which the event occurred.
Event_Update_Time	bigint	Null	Time at which the event occurred. The time is the number of seconds elapsed from Jan 1 1970

Fault_Event_Details View Details

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

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

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

Table 17 Fault_Event_History Schema Details

Column Name	Column Type	Constraints	Column Description
Event_Id	bigint	Not null	Event identifier number
Event_Property_Name	varchar(32)	Null	Name of the property
Event_Property_Value	varchar(255)	Null	Property value

IPM Database Schema

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

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

Connecting to IPM Database

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

•Username — DBA

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

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

•Database name — ipm

•Database source name — ipm

•Database engine name — ipmEng

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

–43280 in IPM 4.2 (with LMS 3.2) release

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

Schema of IPM Database Tables

This chapter contains the following tables:

•Source Table

•Target Table

•IPMDevice Table

•IPEchoOper Table

•UDPEchoOper Table

•PathEchoOper Table

•jitter_oper Table

•ICMPJitterOper Table

•RTPOper Table

•ethernet_oper Table

•http_oper Table

•dns_oper Table

•ftp_oper Table

•dhcp_oper Table

•DLSwOper Table

•PostDialDelayOper Table

•tcpconnect_oper Table

•React Table

•Collector Table

•VrfList Table

•outage_details Table

•completed_outages Table

•Collector _Schedule Table

•Latency_Minute_Stats Table

•Availability_Latency_Hourly_Stats Table

•Availability_Latency_Daily_Stats Table

•Availability_Latency_Weekly_Stats Table

•Availability_Latency_Monthly_Stats Table

•Jitter_Minute_Stats Table

•Jitter_Hourly_Stats Table

•Jitter_Daily_Stats Table

•Jitter_Weekly_Stats Table

•Jitter_Monthly_Stats Table

•ICMP_Jitter_Minute_Stats Table

•ICMP_Jitter_Hourly_Stats Table

•ICMP_Jitter_Daily_Stats Table

•ICMP_Jitter_Weekly_Stats Table

•ICMP_Jitter_Monthly_Stats Table

•Ethernet_Jitter_Minute_Stats Table

•Ethernet_Jitter_Hourly_Stats Table

•Ethernet_Jitter_Daily_Stats Table

•Ethernet_Jitter_Weekly_Stats Table

•Ethernet_Jitter_Monthly_Stats Table

•Http_Minute_Stats Table

•Http_Hourly_Stats Table

•Http_Daily_Stats Table

•Http_Weekly_Stats Table

•Http_Monthly_Stats Table

•PATHECHO_Hourly_Stats Table

•PATHECHO_Daily_Stats Table

•PATHECHO_Weekly_Stats Table

•PATHECHO_Monthly_Stats Table

•RTP_Minute_Stats Table

•RTP_Hourly_Stats Table

•RTP_Daily_Stats Table

•RTP_Weekly _Stats Table

•RTP_Monthly_Stats Table

Source Table

The Source table is given in Table 18.

Table 18 Source Table  

Column Name	Type	Constraints	Description
DeviceID	Bigint	IDENTITY, primary key	Unique identifier
IOSVersion	Varchar(64)	Null	Version of the IOS
MaxColl	Integer	Null	Estimated System. The maximum number of entries in the router.
LastTimeSet	Timestamp	Null	The last time at which a set operation occurred on any of the objects in this MIB. See MIB object: rttMonApplTimeOfLastSet
DisplayName	Varchar(255)	Null	Display name of the device
IPSLAVersion	Varchar(16)	Null	See MIB object: rttMonApplVersion MIB type: DisplayString Round Trip Time monitoring application version string
CollCount	Integer	Null	Estimated number of configurable operations in the router. See MIB object: rttMonApplProbeCapacity
LastRebootTime	timestamp	Not null	Last reboot time of the source device

---

Note Source Table (table name `Source') contains all necessary information about a source router. A unique device ID is assigned to each source router. This device ID acts as the Primary Key of the table.

---

Target Table

The Target table is given in Table 19.

Table 19 Target Table

Column Name	Type	Constraints	Description
DeviceID	Bigint	IDENTITY, Primary key	Unique identifier
DisplayName	Varchar(255)	Null	Display name of the device
DeviceType	Integer	Null	Type of target •0 = ip target •1 = responder enabled •2 = adhoc device

Target Table (table name Target) contains all information about a target. This target could be an SAA router, IPSLA responder enabled device, or an adhoc device. A unique device ID is assigned to each target in the table. This device ID acts as the Primary Key of the table.

IPMDevice Table

The IPM Device Table is given in Table 20.

Table 20 IPMDevice Table

Column Name	Type	Constraints	Description
DeviceID	Bigint	IDENTITY, Primary key	Unique identifier
DCRID	Varchar(255)	Null	Device ID from the DCR table
snmptimeout	Bigint	Null	Duration of time that a system should wait for a device to respond before the system re-tries to access the device. The SNMP timeout values are displayed in milliseconds. The default value is 2.The minimum value is 0.There is no maximum value.
snmpretry	Bigint	Null	Number of times the system retries to access devices using SNMP options. The default value is 3. The minimum value is 0. The maximum value is 6.

Operation Table

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

For parameters associated with a specific type of operation, check the detailed sub-operation table for the specific type of operation.

A unique Operation ID is also assigned to each operation in the table. This Operation ID acts as the Primary Key of the table.

IPEchoOper Table

The IPEchoOper table details is explained in Table 21

Table 21 IPEchoOper Table  

Column Name	Type	Constraints	Description
OperationID	Bigint	Not Null	Reference to operation(ID)
DataReqSize	Integer	Not Null	See MIB object: rttMonEchoAdminPktDataRequestSize MIB type: Integer32(0..16384) Default Value: {1} Number of OCTETS to include in the request data.
TypeOfService	Integer	Not Null	See MIB object: rttMonEchoAdminTOS MIB type: Integer32(0..255) Default Value: {0} The type of service octet in an IP header

UDPEchoOper Table

The UDPEchoOper table is given in Table 22.

Table 22 UDPEchoOper Table  

Column Name	Type	Constraints	Description
OperationID	Bigint	Not Null	Reference to operation(ID)
TypeOfService	Integer	Not Null	See MIB object: rttMonEchoAdminTOS MIB type: Integer32(0..255) Default Value: {0} The type of service octet in an IP header
ReqPayload	Integer	Not Null	See MIB object rttMonEchoAdminPktDataRequestSize MIB type Integer32(0..16384) Default Value {1} Number of OCTETS to include in the request data.
TargetPort	Integer	Not Null	See MIB object: rttMonEchoAdminTargetPort MIB type: Integer32(0..65536) Default Value: {0} The target's port number.

PathEchoOper Table

The PathEchoOper table is given in Table 23.

Table 23 PathEchoOper Table  

Column Name	Type	Constraints	Description
OperationID	Bigint	Not Null	Reference to operation(ID)
TypeOfService	Integer	Null	See MIB object: rttMonEchoAdminTOS MIB type: Integer32(0..255) Default Value: {0} The type of service octet in an IP header
DataReqSize	Integer	Null	See MIB object: rttMonEchoAdminPktDataRequestSize MIB type: Integer32(0..16384) Default Value: {1} Number of OCTETS to include in the request data
MaximumPaths	Integer	Null	See MIB object: rttMonStatisticsAdminNumPaths MIB type: Integer32(1..128) Default Value: { 5 } Maximum number of statistics route buckets to keep
MaximumHops	Integer	Null	See MIB object: rttMonStatisticsAdminNumHops MIB type: Integer32(1..30) Default Value: {16} Maximum number of statistics hop buckets to keep
LSREnable	Varchar(127)	Not Null	Reserved
LSRHop1	Varchar(127)	Not Null	Reserved
LSRHop2	Varchar(127)	Not Null	Reserved
LSRHop3	Varchar(127)	Not Null	Reserved
LSRHop4	Varchar(127)	Not Null	Reserved
LSRHop5	Varchar(127)	Not Null	Reserved
LSRHop6	Varchar(127)	Not Null	Reserved
LSRHop7	Varchar(127)	Not Null	Reserved
LSRHop8	Varchar(127)	Not Null	Reserved

jitter_oper Table

The jitter_oper table is given in Table 24.

Table 24 jitter_oper Table  

Column Name	Type	Constraints	Description
OperationID	Bigint	Not Null	Reference to operation(ID)
sampleinterval	Bigint	Not Null	Unused
TypeofService	Integer	Null	See MIB object: rttMonEchoAdminTOS MIB type: Integer32(0..255) Default Value: {0} The type of service octet in an IP header
reqPayload	Integer	Null	See MIB object: rttMonEchoAdminCodecPayload MIB type: Integer32
trgtPort	Integer	Null	See MIB object: rttMonEchoAdminTargetPort MIB type: Integer32(0..65536) Default Value: {0} The target's port number.
numpacket	Integer	Null	See MIB object: rttMonEchoAdminNumPackets MIB type: Integer32 Default Value: {10} Number of packets that need to be transmitted
pktInterval	Integer	Null	See MIB object: rttMonEchoAdminInterval MIB type: Integer32(0..60000) Default Value: {20} The inter-packet delay between packets. This is in milliseconds
respStatusOfTarget	Integer	Null	Statistics of the target
codecType	Integer	Null	See MIB object: rttMonEchoAdminCodecType MIB type: Integer32
icpifAdvFactor	Integer	Null	See MIB object: rttMonEchoAdminICPIF AdvFactor MIB type: Integer32
isCodecSupport	Varchar(6)	Null	Codec support
precisionlevel	tinyint	Not Null	Precision level See MIB object rttMonEchoAdminPrecision MIB type 32 DefaultValue: millisecond(1) Accuracy of statistics that needs to be calculated •milliseconds(1). The accuracy of statistics will be in milliseconds. •microseconds(2). The accuracy of statistics will be in microseconds

ICMPJitterOper Table

The ICMPJitterOper table is given in Table 25.

Table 25 ICMPJitterOper Table

Column Name	Type	Constraints	Description
OperationID	Bigint	UNIQUE	Reference to operation(ID)
TypeOfService	Integer	Not Null	See MIB object: rttMonEchoAdminTOS MIB type: Integer32(0..255) Default Value: {0} The type of service octet in an IP header
ReqPayload	Integer	Not Null	Unused
NumOfPackets	Integer	Not Null	See MIB object: rttMonEchoAdminNumPackets MIB type: Integer32 Default Value: {10} Number of packets that need to be transmitted
PktInterval	Integer	Not Null	See MIB object: rttMonEchoAdminInterval MIB type: Integer32

RTPOper Table

The RTP Sub Operation table is given in Table 26.

Table 26 RTPOper Table  

Column Name	Type	Constraints	Description
OperationID	Bigint	UNIQUE	Reference to operation(ID)
SourceIP	Varchar(127)	Null	Source IP
SourceVoicePort	Varchar(127)	Null	See MIB object: rttMonEchoAdminSourceVoicePort MIB type: Octets
CodecType	smallint	Null	See MIB object: rttMonEchoAdminCodecType MIB type: Integer32
CallDuration	Integer	Null	See MIB object: rttMonEchoAdminCallDuration MIB type: Integer32
AdvantageFactor	Integer	Null	Advantage Factor range from 0 to 20

ethernet_oper Table

The Ethernet Sub Operation table is given in Table 27.

Table 27 ethernet_oper Table  

Column Name	Type	Constraints	Description
OperationID	Bigint	UNIQUE	Reference to operation(ID)
vlanID	Integer	Not Null	See MIB object: •ethernetPing - rttMonEchoAdminTargetVLAN •ethernetJitter - rttMonEchoAdminTargetVLAN •ethernetPingAutoIPSLA - ipslaEthernetGrpCtrlVLAN •ethernetJitterAutoIPSLA - ipslaEthernetGrpCtrlVLAN
domainName	Varchar(255)	Not Null	See MIB object: •ethernetPing - rttMonEchoAdminTargetDomainName •ethernetJitter - rttMonEchoAdminTargetDomainName •ethernetPingAutoIPSLA - ipslaEthernetGrpCtrlDomainName •ethernetJitterAutoIPSLA - ipslaEthernetGrpCtrlDomainName
mepIDs	Varchar(8192)	Null	See MIB object: rttMonEchoAdminTargetMPID
exMepIDs	Varchar(8192)	Null	See MIB object: ipslaEthernetGrpCtrlMPIDExLst
classOfService	Integer	Null	See MIB object: •ethernetPing - rttMonEchoAdminEthernet COS •ethernetJitter - rttMonEchoAdminEthernet COS •ethernetPingAutoIPSLA - ipslaEthernetGrpCtrlCOS •ethernetJitterAutoIPSLA - ipslaEthernetGrpCtrlCOS
packetReqSize	Integer	Null	See MIB object: •ethernetPing,ethernetJitter - rttMonEchoAdminPktData RequestSize •ethernetPingAutoIPSLA, ethernetJitterAutoIPSLA - ipslaEthernetGrpCtrlReq DataSize
numOfFrames	Integer	Null	Specify the number of frames between 1 and 60000
frameInterval	Integer	Null	Specify the interval between 1 and 60000
schedulePeriod	Integer	Null	Scheduling Period

http_oper Table

The HTTP Operation table is given in Table 28.

Table 28 http_oper Table  

Column Name	Type	Constraints	Description
OperationID	Bigint	Not Null	Reference to operation(ID)
Port	Integer	Null	Target Port No See MIB object rttMonEchoAdminTargetPort MIB type Integer32 DefaultValue:80
URLRelativePath	Varchar(127)	Null	See MIB object: rttMonEchoAdminURL MIB type: DisplayString Default Value: {""} String that represents the URL to which an HTTP probe should communicate with.
CachedPagesFlag	Smallint	Null	See MIB object: rttMonEchoAdminCache MIB type: TruthValue Default Value: {true} If False, the HTTP request should not download cached pages. Hence, the request must be forwarded to the original server.
ProxyServer	Varchar(255)	Null	See MIB object: rttMonTargetAddress
EnableProxy	Smallint	Null	Checkbox for enabling proxy server. The default value is 2
TypeOfService	Integer	Null	See MIB object: rttMonEchoAdminTOS MIB type: Integer32(0..255) Default Value: {0} The type of service octet in an IP Header.
DnsNameServer	Varchar(127)	Not Null	See MIB object: rttMonEchoAdminNameServer MIB type: Octets
EnableDns	Smallint	Not Null	Checkbox for enabling dnsname server. The default value is 2.

dns_oper Table

The DNS Operation table is given in Table 29.

Table 29 dns_oper Table  

Column Name	Type	Constraints	Description
OperationID	Bigint	Not Null	Reference to operation(ID)
targetaddr	Varchar(127)	Null	Unused
nameserver	Varchar(127)	Null	See MIB object: rttMonEchoAdminNameServer MIB type: RttMonTargetAddress Default Value: {""} The IP Address of the nameserver
namesvraddr	Varchar(127)	Null	IP Address of nameserver

ftp_oper Table

The FTP Operation table is given in Table 30.

Table 30 ftp_oper Table  

Column Name	Type	Constraints	Description
OperationID	Bigint	Not Null	Reference to operation(ID)
TypeOfService	Integer	Null	See MIB object: rttMonEchoAdminTOS MIB type: Integer32(0..255) Default Value: {0} The type of service octet in an IP header
FTPMode	Integer	Null	rttMonAdminMode Set to active or passive FTP mode
UserName	Varchar(127)	Null	The username for FTP that enables you to access the FTP server.
Password	Varchar(127)	Null	The Password for FTP in encrypted format. The password that enables you to access the FTP server.
FileLocation	Varchar(127)	Null	FTP file location

dhcp_oper Table

The DHCP Operation table is given in Table 31

Table 31 dhcp_oper Table

Column Name	Type	Constraints	Description
OperationID	Bigint	Not Null	Reference to operation(ID)
targetaddr	Varchar(127)	Null	See MIB object: rttMonEchoAdminTargetAddress MIB type: RttMonTargetAddress Default Value: {""} The address of the target
targetipaddr	Varchar(127)	Null	IP Address of the DHCP server

DLSwOper Table

The DLSw Operation Table is given in Table 32

Table 32 DLSwOper Table

Column Name	Type	Constraints	Description
OperationID	Bigint	Not Null	Reference to operation(ID)
ReqPayload	Varchar(127)	Null	See MIB object: rttMonEchoAdminCodecPayload MIB type: Integer32
ResponsePayload	Varchar(127)	Null	unused

PostDialDelayOper Table

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

Table 33 PostDialDelayOper Table

Column Name	Type	Constraints	Description
OperationID	Bigint	Not Null	Reference to operation(ID)
PhoneNumber	Varchar(127)	Null	Phone number
DetectPoint	Integer	Null	See MIB object rttMonEchoAdminDetectPoint Default value : 1: voipDTAlertRinging (name)

tcpconnect_oper Table

The TcpConnect Operation table is given in Table 34

Table 34 tcpconnect_oper Table

Column Name	Type	Constraints	Description
OperationID	Bigint	Not Null	Reference to operation(ID)
TargetPort	Integer	Null	See MIB object: rttMonEchoAdminTargetPort MIB type: Integer32(0..65536) Default Value: {0} The target's port number.
ControlEnable	Smallint	Null	See MIB object: rttMonEchoAdminControlEnable MIB type: TruthValue Default Value: {true} If enabled, the RTR application will send control messages to a responder, in the target router. This will respond to the data request packets being sent by the source router.
TypeOfService	Integer	Null	See MIB object: rttMonEchoAdminTOS MIB type: Integer32(0..255) Default Value: {0} The type of service octet in an IP header

React Table

The React table is given in Table 35.

Table 35 ReactTable

Column Name	Type	Constraints	Description
OperationID	Bigint	Unique identifier, primarykey	Reference to Operation (ID).
reactvar	Integer	Not Null	React variable See MIB object: rttMonReactVar
reactID	Integer	Not Null	React ID See MIB object: rttMonReactVar
RisingThresh	Integer	Null	Rising threshold value See MIB object: rttMonReactThreshold Rising
FallingThresh	Integer	Null	Falling threshold value See MIB object: rttMonReactThreshold Falling. If this new MIB is not supported the following MIB will be used: rttMonReactAdmin ThresholdFalling
XthreshCount	Integer	Null	X threshold count See MIB object: rttMonReactThresholdCountX . If this new MIB is not supported the following MIB will be used: rttMonReactAdmin ThresholdCount
YthreshCount	Integer	Null	Y threshold count See MIB object: rttMonReactThreshold CountY If this new MI B is not supported the following MIB will be used: rttMonReactAdmin ThresholdCount2
ThreshType	Integer	Null	Threshold type See MIB object: :rttMonReactThreshold Type If the new MIB is not used the following MIB will be used: :rttMonReactAdmin ThresholdType
ActionType	Integer	Null	Action type See MIB object: rttMonReactActionType If the new MIB is not supported, the following MIB will be used. :rttMonReactAdmin ActionType

Collector Table

The Collector table is given in Table 36.

Table 36 Collector Table

Column Name	Type	Constraints	Description
ID	Bigint	IDENTITY, Primary key	Unique identifier for collector
Name	Varchar(255)	Null	Collector Name
descr	Varchar(255)	Null	Description
SourceID	Varchar(50)	Null	Source. Reference to source(ID)
SourceIntAddr	Varchar(50)	Null	Source interface address
TargetID	Varchar(50)	Null	Target. Reference to target(ID)
OperationID	Varchar(50)	Null	Operation. Reference to operation (ID)
ScheduleID	bigint	Null	ScheduleID of the collector Reference to the Collector Schedule (ID).
Owner	Varchar(255)	Null	Owner
Status	Integer	Null	Current Statistics of the collector 1=Running 2=Completed 3=Dormant 4=Suspended 5=Cancelled 6=Config failed 7=Scheduled 8=Delete pending 10=Config pending 11=Update pending 12=Resume pending 13=Suspend pending 14=Cancel pending 15=Reconfig pending 16=Source not responding 17=Complete pending 18=Dormant pending 19=End point missing
PreviousStatus	Integer	Null	Previous Statistics of the collector
StatusInfo	Varchar(255)	Null	Statistics information of the collector
AdminIndex	Integer	Null	Entry number assigned for this collector in the SAA agent
Tag	Varchar(255)	Null	Name of the collector to be sent to device (15 char limit)
OpType	Integer	Null	Operation type for this collector. This information is duplicated in the Type column in the Operation table.
CollectorType	Integer	Null	Collector type: 2 = Monitored. 1 = Statistical. Historical statistical data will be collected and saved into database.
PollInterval	bigint	Null	Polling interval
OpName	Varchar(255)	Null	Operation name
SourceAddress	Varchar(50)	Null	IP Address or HostName of source device from DCR_device_detail of CMF table.
TargetAddress	Varchar(50)	Null	IP Address or Host Name of the target device from DCR_device_detail of CMF table.
AutoIPSLA Parent	bigint	Not Null	Associated Parent Collector ID
IsToBe Reconfigured	smallint	Not Null	Flag whether to configure the collector or not.
VrfName	varchar(255)	Not null	Vrf Name for the collector
LastModified	timestamp	Not null	Last modified time of the collector

VrfList Table

The VRF List table is given in Table 37.

Table 37 VrfList Table  

Column Name	Type	Constraints	Description
deviceid	bigint	Composite primary key. Notnull	Source device ID
vrfName	Varchar(255)	Composite primary key . Not null	VRF name of the source device

outage_details Table

The Outage Details table is given

Table 38 outage_details Table

Column Name	Type	Contraints	Description
outage_id	integer	Not null	Outage ID
start_date	biginit	Not null	Start date of the outage
start_time	timestamp	Not null	The time when the outage is scheduled to begin
end_date	biginit	Not null	End date of the outage
end_time	timestamp	Not null	The time when the outage is schedule to end
rec_type	varchar(32)	Not null	The type of recurrence such as once, weekly, monthly
rec_on	smallinit	Not null	The day when the outage re-occurs. For example, if you want the outage to occur again for all days of a week, select all the days in a week.
outage_name	varchar (255)	Not null	Name of the outage
description	varchar (255)	Not null	The details of the outage

Table 38.

completed_outages Table

The Completed Outages table is given in Table 39

Table 39 completed_outages Table

Column	Type	Constraints	Description
Outage Id	Integer	Not null	Outage Id
Collector Id	biginit	Not null	Collector id of the outage
Start Date Time	timestamp	Not null	Start date and time for the outage period
EndDate Time	timestamp	Not null	End date and time for the outage period

Collector _Schedule Table

The Collector Schedule table is given in Table 40

Table 40 Collector_Schedule Table

Column Name	Type	Constraints	Description
ID	bigint	IDENTITY, primary key	Unique identifier for collector Reference to Collector (ID)
scheduleType	Integer	Null	Schedule type
startDate	bigint	Null	Start date of the collector. The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM
startTime	Timestamp	Null	Start time of the collector
endDate	bigint	Null	End date The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM
endTime	Timestamp	Null	End time
daysOfWeek	Integer	Null	Days of week for polling
suspendedTimestamp	bigint	Null	Suspended time period The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM
resumeTimestamp	bigint	Null	Resume time period The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM

Latency_Minute_Stats Table

The Latency Minute Statistics table in given in Table 41.

Table 41 Latency_Minute_Stats Table

Column Name	Type	Constraints	Description
RowID	Bigint	IDENTITY, Primary key	Unique identifier
CollectorID	Bigint	Not Null	Collector (Running Instance) ID. Reference to collector(ID)
StartTime	Timestamp	Not Null	Start time of the latest RTT operation
Latency_RTT	Integer	Not Null	See MIB object: rttMonLatestRttOperTim. The value of the agent system time at the time of the latest RTT operation.

Availability_Latency_Hourly_Stats Table

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

Table 42 Availability_Latency_Hourly_Stats Table

Column Name	Type	Constraints	Description
RowID	Bigint	IDENTITY, Primary key	Unique identifier
CollectorID	Bigint	Not Null	Collector (Running Instance) ID. Reference to collector(ID)
StartTime	Timestamp	Not Null	Start time of this hourly bucket
MinRTT	Integer	Not Null	See MIB object: rttMonStatsCaptureCompletion- TimeMin MIB type: Gauge32 Minimum RTT
MaxRTT	Integer	Not Null	Maximum of RTT. See MIB object: rttMonStatsCaptureCompletion TimeMax MIB type: Gauge32 Maximum RTT
SumRTT	Integer	Not Null	See MIB object: rttMonStatsCaptureSum CompletionTime MIB type: Gauge32 Accumulated RTTs
SumSqrdRTT	Integer	Not Null	Sum square of all RTT See MIB object: rttMonStatsCaptureSum CompletionTime2Low, rttMonStatsCaptureSum CompletionTime2HighionT ime2High Accumulated RTT Squares
Num Completions	Integer	Not Null	See MIB object: rttMonStatsCapture CompletionsMIB type: Integer32(0..2147483647) Number of RTTs completed
NumOverThresholds	Integer	Not Null	Number of overthresholds. See MIB object: rttMonStatsCaptureOver Thresholds MIB type: Integer32(0..2147483647) Number of OverThresholds
NumDisconnects	Integer	Not Null	Number of Disconnects. See MIB object: rttMonStatsCollectNum Disconnects MIB type: Integer32(0..2147483647)
NumTimeouts	Integer	Not Null	Number of Timeouts See MIB object: rttMonStatsCollectTimeout MIB type: Integer32(0..2147483647)
NumBusies	Integer	Not Null	Number of busies See MIB object: rttMonStatsCollectBusies MIB type: Integer32(0..2147483647) Number of Busies
NumNo Connections	Integer	Not Null	See MIB object: rttMonStatsCollectNo Connections MIB type: Integer32(0..2147483647) Number of Connections
NumDrops	Integer	Not Null	Number of drops. See MIB object: rttMonStatsCollectDrops MIB type: Integer32(0..2147483647) Number of RTT Dropped
NumSeq Errors	Integer	Not Null	See MIB object: rttMonStatscollectSequence Errors MIB type: Integer32(0..2147483647) Number of Sequence Errors
NumVerify Errors	Integer	Not Null	See MIB object: rttMonStatsCollectVerify Errors MIB type: Integer32(0..2147483647) Number of Verify Errors
NumTries	Integer	Not Null	Number of tries
AvgRTT	Numeric(30)	Not Null	Average of RTT
Standard Deviation	Numeric(30)	Not Null	StandardDeviation
OverThres_ Percent	Numeric(30)	Not Nul	Over threshold percentage
Error_Percent	Numeric(30)	Not Nul	Error percentage
Availability_ Percent	Numeric(30)	Not Nul	Availability Percent

Availability_Latency_Daily_Stats Table

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

Table 43 Availability_Latency_Daily_Stats Table  

Column Name	Type	Constraints	Description
CollectorID	Bigint	IDENTITY, Primary key	Collector (Running Instance) ID. Reference to collector(ID)
Start Time	date	Not Null	Start time of the day
MinRTT	Timestamp	Not Null	Average of all MinRTT.
MaxRTT	Bigint	IDENTITY, Primary key	Average of all MaxRTT
SumRTT	Bigint	Not Null	Sum of all RTT
SumSqrdRTT	Integer	Not Null	Sum square of all RTT
NumCompletions	Integer	Not Null	Number of completions.
NumOverThresholds	Integer	Not Null	Number of over thresholds.
NumDisconnects	Integer	Not Null	Number of disconnects
NumTimeouts	Integer	Not Null	Number of Timeouts
NumBusies	Integer	Not Null	Number of busies
NumNoConnections	Integer	Not Null	Number of no connections.
NumDrops	Integer	Not Null	Number of drops.
NumSeqErrors	Integer	Not Null	Number of sequence errors
NumVerifyErrors	Integer	Not Null	Number of verify errors
NumTries	Integer	Not Null	Number of tires
AvgRTT	Numeric(30)	Not Null	Average of RTT
StandardDeviation	Numeric(30)	Not Null	StandardDeviation
OverThres_Percent	Numeric(30)	Not Null	Over threshold percentage
Error_Percent	Numeric(30)	Not Null	Error Percent
Availability_Percent	Numeric(30)	Not Null	Availability Percent

Availability_Latency_Weekly_Stats Table

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

Table 44 Availability_Latency_Weekly_Stats Table  

Column Name	Type	Constraints	Description
CollectorID	Bigint	IDENTITY, Primary key	Collector (Running Instance) ID. Reference to collector(ID)
starttime	date	Not Null	Start time of the week.
MinRTT	Timestamp	Not Null	Average of all MinRTT.
MaxRTT	Bigint	IDENTITY, Primary key	Average of all MaxRTT.
SumRTT	Bigint	Not Null	Sum of all RTT
SumSqrdRTT	Integer	Not Null	Sum square of all RTT
NumCompletions	Integer	Not Null	Number of completions.
NumOver Thresholds	Integer	Not Null	Number of over thresholds.
NumDisconnects	Integer	Not Null	Number of Disconnects.
NumTimeouts	Integer	Not Null	Number of Timeouts
NumBusies	Integer	Not Null	Number of busies.
NumNo Connections	Integer	Not Null	Number of no connections.
NumDrops	Integer	Not Null	Number of drops.
NumSeqErrors	Integer	Not Null	Number of sequence errors
NumVerifyErrors	Integer	Not Null	Number of VerifyErrors
NumTries	Integer	Not Null	Number of tries
AvgRTT	Numeric(30)	Not Null	Average of RTT
StandardDeviation	Numeric(30)	Not Null	StandardDeviation
OverThres_Percent	Numeric(30)	Not Null	Over threshold percentage
Error_Percent	Numeric(30)	Not Null	Error percentage
Availability_Percent	Numeric(30)	Not Null	Availability Percent

Availability_Latency_Monthly_Stats Table

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

Table 45 Availability_Latency_Monthly_Stats Table

Column Name	Type	Constraints	Description
CollectorID	Bigint	IDENTITY, Primary key	Collector (Running Instance) ID. Reference to collector(ID)
starttime	date	Not Null	Start time of the month.
MinRTT	Timestamp	Not Null	Average of all MinRTT.
MaxRTT	Bigint	IDENTITY, Primary key	Average of all MaxRTT.
SumRTT	Bigint	Not Null	Sum of all RTT
SumSqrdRTT	Integer	Not Null	Sum square of all RTT
NumCompletions	Integer	Not Null	Number of completions.
NumOver Thresholds	Integer	Not Null	Number of over thresholds.
NumDisconnects	Integer	Not Null	Number of Disconnects.
NumTimeouts	Integer	Not Null	Number of Timeouts
NumBusies	Integer	Not Null	Number of busies.
NumNo Connections	Integer	Not Null	Number of no connections.
NumDrops	Integer	Not Null	Number of drops.
NumSeqErrors	Integer	Not Null	Number of sequence errors
NumVerifyErrors	Integer	Not Null	See MIB object:
NumTries	Integer	Not Null	Number of tries
AvgRTT	Numeric(30)	Not Null	Average of RTT
StandardDeviation	Numeric(30)	Not Null	StandardDeviation
OverThres_Percent	Numeric(30)	Not Null	Over threshold percentage
Error_Percent	Numeric(30)	Not Null	Error percentage
Availability_Percent	Numeric(30)	Not Null	Availability Percent

See Table 45.

Jitter_Minute_Stats Table

The Jitter Minute Statistics table is given in Table 46.

Table 46 Jitter_Minute_Stats Table

Column Name	Type	Constraints	Description
rowID	Bigint	Not Null	Unique identifier
CollectorID	Bigint	Not Null	Collector (Running Instance) ID. Reference to collector(ID)
starttime	Bigint	Not Null	Start time. The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM
MinRTT	Integer	Not Null	See MIB object: rttMonLatestJitterOperRTTMin MIB type: Gauge (32 bit)
MaxRTT	Integer	Not Null	See MIB object: rttMonLatestJitterOperRTTMax MIB type: Gauge (32 bit)
NumRTT	Integer	Not Null	See MIB object: rttMonLatestJitterOperNumOfRTT MIB type: Gauge (32 bit)
SumRTT	Integer	Not Null	See MIB object: rttMonLatestJitterOperRTTSum MIB type: Gauge (32 bit)
SumRTT2	Double	Not Null	See MIB object: rttMonLatestJitterOperRTTSum2 MIB type: Gauge (32 bit)
minofposisd	Integer	Not Null	See MIB object: rttMonLatestJitterOperMin Of PositivesSD MIB type: Gauge (32 bit)
maxofposisd	Integer	Not Null	See MIB object: rttMonLatestJitterOperMax OfPositivesDS MIB type: Gauge (32 bit)
numofposisd	Integer	Not Null	See MIB object: rttMonLatestJitterOperNumOf PositivesSD MIB type: Gauge (32 bit)
sumofposisd	Integer	Not Null	See MIB object: rttMonLatestJitterOperSumOf PositivesSD MIB type: Gauge (32 bit)
sum2posisd	Double	Not Null	See MIB object: rttMonLatestJitterOperSum2 PositivesSD MIB type: Gauge (32 bit)
minofnegasd	Integer	Not Null	See MIB object: rttMonLatestJitterOperMinOf NegativesSD MIB type: Gauge (32 bit)
maxofnegasd	Integer	Not Null	See MIB object: rttMonLatestJitterOperMaxOf NegativesSD MIB type: Gauge (32 bit)
numofnegasd	Integer	Not Null	See MIB object: rttMonLatestJitterOperNumOf NegativesSD MIB type: Gauge (32 bit)
sumofnegasd	Integer	Not Null	See MIB object: rttMonLatestJitterOperSumOf NegativesSD MIB type: Gauge (32 bit)
sum2negasd	Double	Not Null	See MIB object: rttMonLatestJitterOperSum2 NegativesSD MIB type: Gauge (32 bit)
minofposids	Integer	Not Null	See MIB object: rttMonLatestJitterOperMinOf PositivesDS MIB type: : Gauge (32 bit)
maxofposids	Integer	Not Null	See MIB object: rttMonLatestJitterOperMaxOf PositivesDS MIB type: : Gauge (32 bit)
numofposids	Integer	Not Null	See MIB object: rttMonLatestJitterOperNumOf PositivesDS MIB type: : Gauge (32 bit)
sumofposids	Integer	Not Null	See MIB object: rttMonLatestJitterOperSumOf PositivesDS MIB type: : Gauge (32 bit)
sum2posids	Double	Not Null	See MIB object: rttMonLatestJitterOperSum2 PositivesDS MIB type: : Gauge (32 bit)
minofnegads	Integer	Not Null	See MIB object: rttMonLatestJitterOperMinOf NegativesDS MIB type: : Gauge (32 bit)
maxofnegads	Integer	Not Null	See MIB object: rttMonLatestJitterOperMaxOf NegativesDS MIB type: : Gauge (32 bit)
numofnegads	Integer	Not Null	See MIB object: rttMonLatestJitterOperNumOf NegativesDS MIB type: : Gauge (32 bit)
sumofnegads	Integer	Not Null	See MIB object: rttMonLatestJitterOperSumOf NegativesDS MIB type: : Gauge (32 bit)
sum2negads	Double	Not Null	See MIB object: rttMonLatestJitterOperSum2 NegativesDS MIB type: : Gauge (32 bit)
numpacketlosssd	Integer	Not Null	See MIB object: rttMonLatestJitterOperPacket LossSD MIB type: : Gauge (32 bit)
numpacketlossds	Integer	Not Null	See MIB object: rttMonLatestJitterOperPacket LossDS MIB type: : Gauge (32 bit)
numpacketseqerr	Integer	Not Null	See MIB object: rttMonLatestJitterOperPacketOut OfSequence MIB type: : Gauge (32 bit)
numpacketmia	Integer	Not Null	See MIB object: rttMonLatestJitterOperPacketMIA MIB type: : Gauge (32 bit)
numpacketlate	Integer	Not Null	See MIB object: rttMonLatestJitterOperPacketLate Arrival MIB type : : Gauge (32 bit)
AvgRTT	Numeric(30)	Null	Average of RTT
AvgPosSD	Numeric(30)	Null	Average of positive from Source to Destination (SD)
StdDevPosSD	Numeric(30)	Null	Standard deviation of positive SD
AvgNegSD	Numeric(30)	Null	Average of negative SD
StdDevNegSD	Numeric(30)	Null	Standard deviation of negative SD
AvgPosDS	Numeric(30)	Null	Average of positive DS
StdDevPosDS	Numeric(30)	Null	Standard deviation of positive DS
AvgNegDS	Numeric(30)	Null	Average of negative DS
StdDevNegDS		Null	Standard deviation of negative DS
StdDevRTT	Numeric(30)	Null	Standard deviation of RTT
mos	Integer	Not Null	See MIB object: rttMonLatestJitterOperMOS MIB type: : Gauge (32 bit)
icpif	Integer	Not Null	See MIB object: rttMonLatestJitterOperICPIF MIB type: : Gauge (32 bit)

Jitter_Hourly_Stats Table

The Jitter Hourly Statistics table is given in Table 47.

Table 47 Jitter_Hourly_Stats Table

Column Name	Type	Constraints	Description
rowID	Bigint	Not Null	Unique identifier
CollectorID	Bigint	Not Null	Collector (Running Instance) ID. Reference to collector(ID)
starttime	Timestamp	Not Null	Start time for this hourly bucket
MinRTT	Integer	Not Null	See MIB object: rttMonJitterStatsRTTMin MIB type: Gauge (32 bit)
MaxRTT	Integer	Not Null	See MIB object: rttMonJitterStatsRTTMax MIB type: Gauge (32 bit)
NumRTT	Integer	Not Null	See MIB object: rttMonJitterStatsNumOfRTT MIB type: Gauge (32 bit)
SumRTT	Integer	Not Null	See MIB object: rttMonJitterStatsRTTSum MIB type: Gauge (32 bit)
SumRTT2	Double	Not Null	See MIB object: rttMonJitterStatsRTTSum2Low and MIB object: rttMonJitterStatsRTTSum2High Accumulated RTT Squares
minofposids	Integer	Not Null	Refer to MIB object: rttMonJitterStatsMinOfPositivesSD MIB type: Gauge32 The minimum of absolute values of all positive jitter values from packets sent from destination to source.
maxofposisd	Integer	Not Null	Refer to MIB object: rttMonJitterStatsMaxOfPositivesSD MIB type: Gauge32 The maximum of absolute values of all positive jitter values from packets sent from destination to source.
numofposisd	Integer	Not Null	Refer to MIB object: rttMonJitterStatsNumOfPositivesSD MIB type: Gauge32 The sum of number of all positive jitter values from packets sent from destination to source.
sumofposisd	Integer	Not Null	Refer to MIB object: rttMonJitterStatsSumOfPositivesSD MIB type: Counter32 The sum of all positive jitter values from packets sent from destination to source.
sum2posisd	Double	Not Null	Refer to MIB object: rttMonJitterStatsSum2PositivesS D2Low and MIB object: rttMonJitterStatsSum2PositivesS D2High The sum of square of RTT's of all positive jitter values from packets sent from destination to source.
minofnegasd	Integer	Not Null	Refer to MIB object: rttMonJitterStatsMinOfNegativesSD MIB type: Gauge32 The minimum of absolute values of all negative jitter values from packets sent from destination to source.
maxofnegasd	Integer	Not Null	Refer to MIB object: rttMonJitterStatsMaxOfNegativesSD MIB type: Gauge32 The maximum of absolute values of all negative jitter values from packets sent from from destination to source.
numofnegasd	Integer	Not Null	Refer to MIB object: rttMonJitterStatsNumOfNegativesSD MIB type: Gauge32 The sum of number of all negative jitter values from packets sent from destination to source.
sumofnegasd	Integer	Not Null	Refer to MIB object: rttMonJitterStatsSumOfNegativesSD MIB type: Counter32 The sum of all negative jitter values from packets sent from source to destination
sum2negasd	Double	Not Null	Refer to MIB object: rttMonJitterStatsSum2Negatives SD2Low and MIB object: rttMonJitterStatsSum2Negatives SD2High The sum of square of RTT's of all negative jitter values from packets sent from destination to source.
minofposids	Integer	Not Null	Refer to MIB object: rttMonJitterStatsMinOfPositivesDS MIB type: Gauge32 The minimum of absolutevalues of all positive jitter values from packets sent from destination to source.
maxofposids	Integer	Not Null	Refer to MIB object: rttMonJitterStatsMaxOfPositivesDS MIB type: Gauge32 The maximum of absolute values of all positive jitter values from packets sent from destination to source
numofposids	Integer	Not Null	Refer to MIB object: rttMonJitterStatsNumOfPositivesDS MIB type: Gauge32 The sum of number of all positive jitter values from packets sent from destination to source.
sumofposids	Integer	Not Null	Refer to MIB object: rttMonJitterStatsSumOfPositivesDS MIB type: Counter32 The sum of all positive jitter values from packets sent from destination to source.
sum2posids	Double	Not Null	Refer to MIB object: rttMonJitterStatsSum2Positives DS2Low and MIB object: rttMonJitterStatsSum2Positives DS2High The sum of square of RTT's of all positive jitter values from packets sent from destination to source.
minofnegads	Integer	Not Null	Refer to MIB object: rttMonJitterStatsMinOfNegativesDS MIB type: Gauge32 The minimum of absolute values of all negative jitter values from packets sent from source to destination
maxofnegads	Integer	Not Null	Refer to MIB object: rttMonJitterStatsMaxOfNegativesDS MIB type: Gauge32 The maximum of absolute values of all negative jitter values from packets sent from source to destination
numofnegads	Integer	Not Null	Refer to MIB object: rttMonJitterStatsNumOfNegativesDS MIB type: Gauge32 The sum of number of all negative jitter values from packets sent from destination to source.
sumofnegads	Integer	Not Null	Refer to MIB object: rttMonJitterStatsSumOfNegativesDS MIB type: Counter32 The sum of all negative jitter values from packets sent from destination to source
sum2negads	Double	Not Null	Refer to MIB object: rttMonJitterStatsSum2Negatives DS2Low and MIB object: rttMonJitterStatsSum2Negatives DS2High The sum of square of RTT's of all negative jitter values from packets sent from destination to source
numcomplete	Integer	Not Null	Refer to MIB object: rttMonJitterStatsCompletions MIB type: Counter32 Number of RTTs completed
numoverthresh	Integer	Not Null	Refer to MIB object: rttMonJitterStatsOverThresholds MIB type: Counter32 Number of OverThresholds
numpacketlossds	Integer	Not Null	Refer to MIB object: rttMonJitterStatsPacketLossSD MIB type: Counter32 The number of packets lost when sent from destination to source.
numpacketlossds	Integer	Not Null	Refer to MIB object: rttMonJitterStatsPacketLossDS MIB type: Counter32 The number of packets lost when sent from destination to source.
numpacketseqerr	Integer	Not Null	Refer to MIB object: rttMonJitterStatsPacketOutOf- Sequence MIB type: Counter32 The number of packets arrived out of sequence
numpacketmia	Integer	Not Null	Refer to MIB object: rttMonJitterStatsPacketMIA MIB type: Counter32 The number of packets that are lost for which we cannot determine the direction
numpacketlate	Integer	Not Null	Refer to MIB object: rttMonJitterStatsPacketLateArrival MIB type: Counter32 The number of packets that arrived after the timeout
NumJitterStatsErrors	Integer	Not Null	Refer mib object : rttMonJitterStatsError Mib type : Counter (32 bit)
numerror	Integer	Not Null	Refer to MIB object: rttMonJitterStatsError MIB type: Counter32 The number of occasions when a jitter operation could not be initiated because an internal error
numbusy	Integer	Not Null	Refer to MIB object: rttMonJitterStatsBusies MIB type: Counter32 The number of occasions when a jitter operation could not be initiated because a previous jitter operation has not been completed
AvgRtt	Numeric(30)	Not Null	Average of RTT
Error_Percent	Numeric(30)	Not Null	Error percent
NumTries	Integer	Not Null	Number of tries
AvgPosSD	Numeric(30)	Not Null	Average of positive SD
StdDevPosSD	Numeric(30)	Not Null	Standard deviation of positive SD
AvgNegSD	Numeric(30)	Not Null	Average of negative SD
StdDevNegSD	Numeric(30)	Not Null	Standard deviation negative SD
AvgPosDS	Numeric(30)	Not Null	Average of positive DS
StdDevPosDS	Numeric(30)	Not Null	Standard deviation of positive DS
AvgNegDS	Numeric(30)	Not Null	Average of negative DS
StdDevNegDS	Numeric(30)	Not Null	Standard deviation of negative DS
PacketErrorPercent	Numeric(30)	Null	Packet Error Percent
OverThresholdPercent	Numeric(30)	Null	Over Threshold Percent
StdDevRTT	Numeric(30)	Null	Standard deviation RTT
TotalPackets	Integer	Null	Total Packets
minmos	Integer	Not Null	Min of MOS
maxmos	Integer	Not Null	Max of MOS
minicpif	Integer	Not Null	Min of icpif
maxicpif	Integer	Not Null	Max of icpif

Jitter_Daily_Stats Table

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

Table 48 Jitter_Daily_Stats Table

Column Name	Type	Constraints	Description
CollectorID	Bigint	Not Null	Collector (Running Instance) ID. Reference to collector(ID)
starttime	date	Not Null	Start time of the day
MinRTT	Integer	Not Null	Average of all Min RTT
MaxRTT	Integer	Not Null	Average of all Max RTT
NumRTT	Integer	Not Null	Number of RTT's that are successfully measured
SumRTT	Integer	Not Null	Accumulated RTTs
SumRTT2	Double	Not Null	Accumulated RTT Squares
minofposisd	Integer	Not Null	Minimum of positive SD
maxofposisd	Integer	Not Null	Maximum of positive SD
numofposisd	Integer	Not Null	Number of positve SD
sumofposisd	Integer	Not Null	Sum of positive SD
sum2posisd	Double	Not Null	Sum squared of positive SD
minofnegasd	Integer	Not Null	Minimum of negative SD
maxofnegasd	Integer	Not Null	Maximum of negative SD
numofnegasd	Integer	Not Null	Number of negative SD
sumofnegasd	Integer	Not Null	Sum of negative SD
sum2negasd	Double	Not Null	Sum squared of negative SD
minofposids	Integer	Not Null	Minimum of positive DS
maxofposids	Integer	Not Null	Maximum of positive DS
numofposids	Integer	Not Null	Number of positive DS
sumofposids	Integer	Not Null	Sum of positive DS
sum2posids	Double	Not Null	Sum squared of positive DS
minofnegads	Integer	Not Null	Minimum of nagative DS
maxofnegads	Integer	Not Null	Maximum of negative DS
numofnegads	Integer	Not Null	Number of negative DS
sumofnegads	Integer	Not Null	Sum of negative DS
sum2negads	Double	Not Null	Sum squared of negative DS
numcomplete	Integer	Not Null	Number of completions
numoverthresh	Integer	Not Null	Number of overthreshold
numpacketlosssd	Integer	Not Null	Number of packet loss SD
numpacketlossds	Integer	Not Null	Number of packet loss DS
numpacketseqerr	Integer	Not Null	Number of error packets
numpacketmia	Integer	Not Null	Number of packet MIA
numpacketlate	Integer	Not Null	Number of late packets
NumJitterStatsErrors	Integer	Not Null	Number of JitterStatsErrors
numerror	Integer	Not Null	Numerror
numbusy	Integer	Not Null	Numbusy
AvgRtt	Numeric(30)	Not Null	Average RTT
Error_Percent	Numeric(30)	Not Null	Error percentage
NumTries	Integer	Not Null	Number of tries
AvgPosSD	Numeric(30)	Not Null	Average of positive SD
StdDevPosSD	Numeric(30)	Not Null	Standared deviation of positive SD
AvgNegSD	Numeric(30)	Not Null	Average of negative SD
StdDevNegSD	Numeric(30)	Not Null	Standared deviation of negative SD
AvgPosDS	Numeric(30)	Not Null	Average of positive DS
StdDevPosDS	Numeric(30)	Not Null	Standared deviation of positive DS
AvgNegDS	Numeric(30)	Not Null	Average of negative DS
StdDevNegDS	Numeric(30)	Not Null	Standared deviation of negative DS
PacketErrorPercent	Numeric(30)	Null	PacketErrorPercent
OverThresholdPercent	Numeric(30)	Null	OverThresholdPercent
StdDevRTT	Numeric(30)	Null	Standared deviation of RTT
TotalPackets	Integer	Null	TotalPackets
minmos	Integer	Not Null	Min MOS
maxmos	Integer	Not Null	Max MOS
minicpif	Integer	Not Null	Min ICPIF
maxicpif	Integer	Not Null	Max ICPIF

Jitter_Weekly_Stats Table

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

.

Table 49 Jitter_Weekly_Stats Table

Column Name	Type	Constraints	Description
CollectorID	Bigint	Not Null	Collector (Running Instance) ID. Reference to collector(ID)
starttime	date	Not Null	Start time of the week
MinRTT	Integer	Not Null	Average of all Min RTT
MaxRTT	Integer	Not Null	Average of all Max RTT
NumRTT	Integer	Not Null	Number of RTT's that are successfully measured
SumRTT	Integer	Not Null	Accumulated RTTs
SumRTT2	Double	Not Null	Accumulated RTT Squares
minofposisd	Integer	Not Null	Minimum of positive SD
maxofposisd	Integer	Not Null	Maximum of positive SD
numofposisd	Integer	Not Null	Number of positve SD
sumofposisd	Integer	Not Null	Sum of positive SD
sum2posisd	Double	Not Null	Sum squared of positive SD
minofnegasd	Integer	Not Null	Minimum of negative SD
maxofnegasd	Integer	Not Null	Maximum of negative SD
numofnegasd	Integer	Not Null	Number of negative SD
sumofnegasd	Integer	Not Null	Sum of negative SD
sum2negasd	Double	Not Null	Sum squared of negative SD
minofposids	Integer	Not Null	Minimum of positive DS
maxofposids	Integer	Not Null	Maximum of positive DS
numofposids	Integer	Not Null	Number of positive DS
sumofposids	Integer	Not Null	Sum of positive DS
sum2posids	Double	Not Null	Sum squared of positive DS
minofnegads	Integer	Not Null	Minimum of nagative DS
maxofnegads	Integer	Not Null	Maximum of negative DS
numofnegads	Integer	Not Null	Number of negative DS
sumofnegads	Integer	Not Null	Sum of negative DS
sum2negads	Double	Not Null	Sum squared of negative DS
numcomplete	Integer	Not Null	Number of completions
numoverthresh	Integer	Not Null	Number of overthreshold
numpacketlosssd	Integer	Not Null	Number of packet loss SD
numpacketlossds	Integer	Not Null	Number of packet loss DS
numpacketseqerr	Integer	Not Null	Number of error packets
numpacketmia	Integer	Not Null	Number of packet MIA
numpacketlate	Integer	Not Null	Number of late packets
NumJitterStatsErrors	Integer	Not Null	Number of JitterStatsErrors
numerror	Integer	Not Null	Numerror
numbusy	Integer	Not Null	Numbusy
AvgRtt	Numeric(30)	Not Null	Average RTT
Error_Percent	Numeric(30)	Not Null	Error percentage
NumTries	Integer	Not Null	Number of tries
AvgPosSD	Numeric(30)	Not Null	Average of positive SD
StdDevPosSD	Numeric(30)	Not Null	Standared deviation of positive SD
AvgNegSD	Numeric(30)	Not Null	Average of negative SD
StdDevNegSD	Numeric(30)	Not Null	Standared deviation of negative SD
AvgPosDS	Numeric(30)	Not Null	Average of positive DS
StdDevPosDS	Numeric(30)	Not Null	Standared deviation of positive DS
AvgNegDS	Numeric(30)	Not Null	Average of negative DS
StdDevNegDS	Numeric(30)	Not Null	Standared deviation of negative DS
PacketErrorPercent	Numeric(30)	Null	PacketErrorPercent
OverThresholdPercent	Numeric(30)	Null	OverThresholdPercent
StdDevRTT	Numeric(30)	Null	Standared deviation of RTT
TotalPackets	Integer	Null	TotalPackets
minmos	Integer	Not Null	Min MOS
maxmos	Integer	Not Null	Max MOS
minicpif	Integer	Not Null	Min ICPIF
maxicpif	Integer	Not Null	Max ICPIF

Jitter_Monthly_Stats Table

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

Table 50 Jitter_Monthly_Stats Table

Column Name	Type	Constraints	Description
CollectorID	Bigint	Not Null	Collector (Running Instance) ID. Reference to collector(ID)
starttime	date	Not Null	Start time of the monthly
MinRTT	Integer	Not Null	Average of all Min RTT
MaxRTT	Integer	Not Null	Average of all Max RTT
NumRTT	Integer	Not Null	Number of RTT's that are successfully measured
SumRTT	Integer	Not Null	Delay in the polling interval of collectors.
SumRTT2	Double	Not Null	Accumulated RTT Squares
minofposisd	Integer	Not Null	Minimum of positive SD
maxofposisd	Integer	Not Null	Maximum of positive SD
numofposisd	Integer	Not Null	Number of positve SD
sumofposisd	Integer	Not Null	Sum of positive SD
sum2posisd	Double	Not Null	Sum squared of positive SD
minofnegasd	Integer	Not Null	Minimum of negative SD
maxofnegasd	Integer	Not Null	Maximum of negative SD
numofnegasd	Integer	Not Null	Number of negative SD
sumofnegasd	Integer	Not Null	Sum of negative SD
sum2negasd	Double	Not Null	Sum squared of negative SD
minofposids	Integer	Not Null	Minimum of positive DS
maxofposids	Integer	Not Null	Maximum of positive DS
numofposids	Integer	Not Null	Number of positive DS
sumofposids	Integer	Not Null	Sum of positive DS
sum2posids	Double	Not Null	Sum squared of positive DS
minofnegads	Integer	Not Null	Minimum of nagative DS
maxofnegads	Integer	Not Null	Maximum of negative DS
numofnegads	Integer	Not Null	Number of negative DS
sumofnegads	Integer	Not Null	Sum of negative DS
sum2negads	Double	Not Null	Sum squared of negative DS
numcomplete	Integer	Not Null	Number of completions
numoverthresh	Integer	Not Null	Number of overthreshold
numpacketlosssd	Integer	Not Null	Number of packet loss SD
numpacketlossds	Integer	Not Null	Number of packet loss DS
numpacketseqerr	Integer	Not Null	Number of error packets
numpacketmia	Integer	Not Null	Number of packet MIA
numpacketlate	Integer	Not Null	Number of late packets
NumJitterStatsErrors	Integer	Not Null	Number of JitterStatsErrors
numerror	Integer	Not Null	Numerror
numbusy	Integer	Not Null	Numbusy
AvgRtt	Numeric(30)	Not Null	Average RTT
Error_Percent	Numeric(30)	Not Null	Error percentage
NumTries	Integer	Not Null	Number of tries
AvgPosSD	Numeric(30)	Not Null	Average of positive SD
StdDevPosSD	Numeric(30)	Not Null	Standared deviation of positive SD
AvgNegSD	Numeric(30)	Not Null	Average of negative SD
StdDevNegSD	Numeric(30)	Not Null	Standared deviation of negative SD
AvgPosDS	Numeric(30)	Not Null	Average of positive DS
StdDevPosDS	Numeric(30)	Not Null	Standared deviation of positive DS
AvgNegDS	Numeric(30)	Not Null	Average of negative DS
StdDevNegDS	Numeric(30)	Not Null	Standared deviation of negative DS
PacketErrorPercent	Numeric(30)	Null	PacketErrorPercent
OverThresholdPercent	Numeric(30)	Null	OverThresholdPercent
StdDevRTT	Numeric(30)	Null	Standared deviation of RTT
TotalPackets	Integer	Null	TotalPackets
minmos	Integer	Not Null	Min MOS
maxmos	Integer	Not Null	Max MOS
minicpif	Integer	Not Null	Min ICPIF
maxicpif	Integer	Not Null	Max ICPIF

ICMP_Jitter_Minute_Stats Table

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

Table 51 ICMP_Jitter_Minute_Stats Table

Column Name	Type	Constraints	Description
rowID	Bigint	IDENTITY, primary key	Unique identifier
CollectorID	Bigint	Not Null	Collector (Running Instance) ID. Reference to collector(ID)
starttime	Timestamp	Not Null	Starttime
MinRTT	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterRTTMin MIB type: Gauge (32 bit)
MaxRTT	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterRTTMax MIB type: Gauge (32 bit)
NumRTT	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterNumRTT MIB type: Gauge (32 bit)
SumRTT	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterRTTSum MIB type: Gauge (32 bit)
SumRTT2	Double	Not Null	See MIB object: rttMonLatestIcmpJitterRTTSum2 MIB type: Gauge (32 bit)
minofposisd	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterMinPosSD MIB type: Gauge (32 bit)
maxofposisd	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterMaxPosSD MIB type: Gauge (32 bit)
numofposisd	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterNumPosSD MIB type: Gauge (32 bit)
sumofposisd	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterSumPosSD MIB type: Gauge (32 bit)
sum2posisd	Double	Not Null	See MIB object: rttMonLatestIcmpJitterSum2PosSD MIB type: Gauge (32 bit)
minofnegasd	Not Null	Not Null	See MIB object: rttMonLatestIcmpJitterMinNegSD MIB type: Gauge (32 bit)
maxofnegasd	Not Null	Not Null	See MIB object: rttMonLatestIcmpJitterMaxNegSD MIB type: Gauge (32 bit)
numofnegasd	Not Null	Not Null	See MIB object: rttMonLatestIcmpJitterNumNegSD MIB type: Gauge (32 bit)
sumofnegasd	Not Null	Not Null	See MIB object: rttMonLatestIcmpJitterSumNegSD MIB type: Gauge (32 bit)
sum2negasd	Double	Not Null	See MIB object: rttMonLatestIcmpJitterSum2NegSD MIB type: Gauge (32 bit)
minofposids	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterMinPosDS MIB type: Gauge (32 bit)
maxofposids	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterMaxPosDS MIB type: Gauge (32 bit)
numofposids	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterNumPosDS MIB type: Gauge (32 bit)
sumofposids	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterSumPosDS MIB type: Gauge (32 bit)
sum2posids	Double	Not Null	See MIB object: rttMonLatestIcmpJitterSum2PosDS MIB type: Gauge (32 bit)
minofnegads	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterMinNegDS MIB type: Gauge (32 bit)
maxofnegads	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterMaxNegDS MIB type: Gauge (32 bit)
numofnegads	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterNumNegDS MIB type: Gauge (32 bit)
sumofnegads	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterSumNegDS MIB type: Gauge (32 bit)
sum2negads	Double	Not Null	See MIB object: rttMonLatestIcmpJitterSum2NegDS MIB type: Gauge (32 bit)
numPktLoss	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterPktLoss MIB type: Counter (32 bit)
numPktOutSeqBoth	Integer	Not Null	See MIB object: rttMonLatestIcmpJPktOutSeqBoth MIB type: Counter (32 bit)
numPktOutSeqSDes	Integer	Not Null	See MIB object: rttMonLatestIcmpJPktOutSeqSD MIB type: Counter (32 bit)
numPktOutSeqDSes	Integer	Not Null	See MIB object: rttMonLatestIcmpJPktOutSeqDS MIB type: Counter (32 bit)
numPktSkippeds	Integer	Not Null	unused
numPktLateAs	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterPktLateA MIB type: Counter (32 bit)
minSuccPktLoss	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterMinSucPktL MIB type: Gauge (32 bit)
maxSuccPktLoss	Integer	Not Null	See MIB object: rttMonLatestIcmpJitterMaxSucPktL MIB type: Gauge (32 bit)
AvgRTT	Numeric(30,6)	Null	Average of RTT
AvgPosSD	Numeric(30,6)	Null	Average of positive SD
StdDevPosSD	Numeric(30,6)	Null	Standard deviation of positive SD
AvgNegSD	Numeric(30,6)	Null	Average of negative SD
StdDevNegSD	Numeric(30,6)	Null	Standard deviation of negative SD
AvgPosDS	Numeric(30,6)	Null	Average of positive DS
StdDevPosDS	Numeric(30,6)	Null	Standard deviation of positive DS
AvgNegDS	Numeric(30,6)	Null	Average of negative DS
StdDevNegDS	Numeric(30,6)	Null	Standard deviation of negative DS
StdDevRTT	Numeric(30,6)	Null	Standard deviation of RTT

ICMP_Jitter_Hourly_Stats Table

The ICMP Jitter Hourly Statistics table is given in Table 52

Table 52 ICMP_Jitter_Hourly_Stats Tabl;e

Column Name	Type	Constraints	Description
rowID	Bigint	IDENTITY, primary key	Unique identifier
CollectorID	Bigint	Not Null	Collector (Running Instance) ID. Reference to collector(ID).
starttime	Timestamp	Not Null	Start time of the hourly bucket
MinRTT	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsRTTMin MIB type: Gauge (32 bit)
MaxRTT	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsRTTMax MIB type: Gauge (32 bit)
NumRTT	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsNumRTTs MIB type: Gauge (32 bit)
SumRTT	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsRTTSums MIB type: Gauge (32 bit)
SumRTT2	Double	Not Null	See MIB object: rttMonIcmpJStatsRTTSum2Lows,rttMonIcmpJStatsRTTSum2Highs. The high and low order 32 bits of the accumulated squares of completion times (in milliseconds) of RTT operations that complete successfully.
minofposisd	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsMinPosSD MIB type: Gauge (32 bit)
maxofposisd	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsMaxPosSD MIB type: Gauge (32 bit)
numofposisd	Integer	Not Null	See MIB object: rttMonIcmpJitter StatsNumPosSDs MIB type: Gauge (32 bit)
sumofposisd	Integer	Not Null	See MIB object: rttMonIcmpJitter StatsSumPosSDs MIB type: Gauge (32 bit)
sum2posisd	Double	Not Null	See MIB object: Sum2PosSDLows,rttMonIcmpJStatsSum2PosSDHighs. The sum of the square of RTTs of all positive jitter values from packets sent from source to destination (Low and higher order 32 bits).
minofnegasd	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsMinNegSD MIB type: Gauge (32 bit)
maxofnegasd	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsMaxNegSD MIB type: Gauge (32 bit)
numofnegasd	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsNumNegSDs MIB type: Gauge (32 bit)
sumofnegasd	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsSumNegSDs MIB type: Gauge (32 bit)
sum2negasd	Double	Not Null	See MIB object: rttMonIcmpJStatsSum2NegSDLows,rttMonIcmpJStatsSum2NegSDHighs. The sum of the square of RTTs of all negative jitter values from packets sent from source to destination. (Low and higher order 32 bits
minofposids	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsMinPosDS MIB type: Gauge (32 bit)
maxofposids	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsMaxPosDS MIB type: Gauge (32 bit)
numofposids	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsNumPosDSes MIB type: Gauge (32 bit)
sumofposids	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsSumPosDSes MIB type: Gauge (32 bit)
sum2posids	Double	Not Null	See MIB object:
minofnegads	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsMinNegDS MIB type: Gauge (32 bit)
maxofnegads	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsMaxNegDS MIB type: Gauge (32 bit)
numofnegads	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsNumNegDSes MIB type: Gauge (32 bit)
sumofnegads	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsSumNegDSes MIB type: Gauge (32 bit)
sum2negads	Double	Not Null
numcomplete	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsCompletions MIB type: Counter (32 bit)
numoverthresh	Integer	Not Null	See MIB object: rttMonIcmpJStatsOverThresholds MIB type: Counter (32 bit)
numPktLoss	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsPktLosses MIB type: Counter (32 bit)
numPktOutSeqBoth	Integer	Not Null	See MIB object: rttMonIcmpJStatsPktOutSeqBoth MIB type: Counter (32 bit)
numPktOutSeqSDes	Integer	Not Null	See MIB object: rttMonIcmpJStatsPktOutSeqSDs MIB type: Counter (32 bit)
numPktOutSeqDSes	Integer	Not Null	See MIB object: rttMonIcmpJStatsPktOutSeqDSes MIB type: Counter (32 bit)
numPktSkippeds	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsPktSkippeds MIB type: Counter (32 bit)
numPktLateAs	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsPktLateAs MIB type: Counter (32 bit)
minSuccPktLoss	Integer	Not Null	See MIB object: rttMonIcmpJitterMinSucPktLoss MIB type:gauge(32)
maxSuccPktLoss	Integer	Not Null	See MIB object: rttMonIcmpJitterMaxSucPktLoss MIB type:gauge(32)
numerror	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsErrors MIB type: Counter (32 bit)
numbusy	Integer	Not Null	See MIB object: rttMonIcmpJitterStatsBusies MIB type: Counter (32 bit)
AvgRtt	Numeric(30)	Not Null	Average RTT
Error_Percent	Numeric(30)	Not Null	Error percentage
NumTries	Integer	Not Null	Number of tries
AvgPosSD	Numeric(30)	Not Null	Average positive SD
StdDevPosSD	Numeric(30)	Not Null	Standard deviation positive SD
AvgNegSD	Numeric(30)	Not Null	Average negative SD
StdDevNegSD	Numeric(30)	Not Null	Standard deviation negative SD
AvgPosDS	Numeric(30)	Not Null	Average of positive SD
StdDevPosDS	Numeric(30)	Not Null	Standard deviation positive DS
AvgNegDS	Numeric(30)	Not Null	Average negative DS
StdDevNegDS	Numeric(30)	Not Null	Standard deviation negative DS
PacketErrorPercent	Numeric(30)	Null	Packet error percentage
OverThresholdPercent	Numeric(30)	Null	Over threshold percentage
StdDevRTT	Numeric(30)	Null	Standard deviation RTT
TotalPackets	Integer	Null	Total packets

ICMP_Jitter_Daily_Stats Table

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

Table 53 ICMP_Jitter_Daily_Stats Table

Column Name	Type	Constraints	Description
CollectorID	Bigint	Not Null	Collector (Running Instance) ID. Reference to collector(ID)
starttime	date	Not Null	Start time of the day
MinRTT	Integer	Not Null