open database schema support in cisco prime lan …2 open database schema support in cisco prime lan...
TRANSCRIPT
Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
ContentsThis document explains the open database schema support in Cisco Prime LAN Management Solution (LMS 4.2). This document contains the following sections:
• Enabling Access to Database
• Accessing Database Views
• Changing the Database Password
• Exposed Database Views and Tables
• Schema of Exposed Database Views
• IPSLA Database Schema
Enabling Access to DatabaseTo enable the access to applications database, you must run the dbaccess.pl utility from the command line.
You must run:
• NMSROOT/bin/perl NMSROOT/bin/dbaccess.pl {install|clean} [debug] — on Solaris or Soft Appliance systems
• NMSROOT\bin\perl NMSROOT\bin\dbaccess.pl {install|clean} [debug] — on Windows systems
where,
• NMSROOT — Default LMS installation directory
• install — Command line parameter that cleans the existing views, creates new views, and provides access to databases
Americas Headquarters:Cisco Systems, Inc., 170 West Tasman Drive, San Jose, CA 95134-1706 USA
Enabling Access to Database
• clean — Command line parameter that cleans the existing views
• debug — Prints the debug and warning messages on the screen
The default username to access the database view as a normal user is lmsdatafeed.
The default username to access the database view as a ssecure user is lmssecuredatafeed.
The CLI utility prompts you to enter the passwords for normal database view user and secure database view user.
As a normal database view user, you will be able to access all views except EnergyWise_Domain view.
You can access EnergyWise_Domain view only when you connect the database as a secure database view user.
The passwords can be between 5 and 30 characters long.
A few warning messages appear while running the utility with the debug option. These messages appear when the view definitions are not in the database.
For example, you may get the following warning messages while the utility enables access to Common Services database:
WARN: User ID 'lmsdatafeed' does not exist (DBD: execute failed).WARN: User ID 'lmssecuredatafeed' does not exist (DBD: execute failed).WARN: Table 'Network_Devices' not found (DBD: execute failed).WARN: Table 'Job_Details' not found (DBD: execute failed).
You can ignore these warning messages.
See Connecting to IPSLA Database for details on connecting to the IPSLA database.
You can also access the following databases using the default usernames.
The database names and their default usernames are given in the table below:
The password to connect to the database is the password you entered or randomly generated during installation of LMS 4.2.
Database Name User Name
cmf cmfDBA
ipm DBA
rmeng DBA
dfmInv itemInvUser
dfmEpm itemEpmUser
dfmFh itemFhUser
upm dba
ani cwsiSA
2Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Accessing Database Views
Accessing Database ViewsYou can access the created views using database access methods such as JDBC and ODBC.
You should use select * from View_Name to access the database views:
You can access the created views either from:
• The local LMS Server.
Or
• A remote server with or without LMS installed.
This section contains:
• Accessing Database From a Local Server
• Accessing the Database From a Remote Server
Accessing Database From a Local ServerThis section contains the sample code for:
• Accessing Database Using Jconnect JDBC Access Method
• Accessing Database Using iAnyWhere JDBC Access Method
• Accessing Database Using ODBC Access Method
Accessing Database Using Jconnect JDBC Access Method
The following is the sample code to connect to the database, using the Jconnect JDBC access method:
import java.util.Date;import java.sql.*;public class JdbcAccess {
private static Connection conn;private static Statement stmt;private static ResultSet rs;/** * @param args */public static void main(String[] args) throws SQLException, ClassNotFoundException {
Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
// The following information such as port, and service names are to be // changed based on the application database that you want to connect. // For example, conn = DriverManager.getConnection("jdbc:sybase:Tds:localhost:// <ServerPort>?SERVICENAME=<DBName>","<View username>","<View password>");conn = DriverManager.getConnection("jdbc:sybase:Tds:localhost:43441?
SERVICENAME=cmfDb","lmsdatafeed | lmssecuredatafeed","dbpasswd");
System.out.println("[" + new Date() + "] INFO: Connection successful...");
//Create Statement nowstmt = 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"));
3Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Accessing Database Views
System.out.println("Device_Display_Name: " + rs.getString("Device_Display_Name"));
System.out.println("Management_IPAddress" + rs.getString("Management_IPAddress"));
System.out.println("-----------------------------------------------------------");}
}}
Note This sample code uses the Jconnect JDBC driver. You must include the Jconnect Jar file (NMSROOT/lib/classpath/jconn2.jar) in the CLASSPATH before you connect to the database.
In the code snippet below, you must change the information such as port, service name, dsn names based on the application database to which you want to connect:
conn = DriverManager.getConnection("jdbc:sybase:Tds:localhost:43441?SERVICENAME=cmfDb","lmsdatafeed | lmssecuredatafeed","dbpasswd");
where,
• localhost —Local LMS Server.
• 43441 — Port number to connect to the database. In this sample, it refers to the port number used to connect to the Common Services database. See Application Database Names and Port Number Details for details on other port numbers to use.
• cmfDb — Name of the database service. In this sample, it refers to the Common Services database. See Application Database Names and Port Number Details for details on other port numbers to use.
• lmsdatafeed — Default username to connect as a normal database view user.
• lmssecuredatafeed — Default username to connect as a secure database view user.
• dbpasswd — Database view password. You should enter the password corresponding to the view username you are using to connect to the database.
Application Database Names and Port Number Details
The application database names are given in the table below:
The port number mentioned in the table could vary. You can get the appropriate port numbers from the odbc.tmpl file of respective databases.
Application Database Name Port Number to Connect to Database
Common Services cmfDb 43441
Network Topology, Layer 2 Services and User Tracking
aniDb 43443
Inventory, Config and Image Management
rmengdb 43455
Fault Management (Fault History) dfmFhDb 43445
4Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Accessing Database Views
Accessing Database Using iAnyWhere JDBC Access Method
The following is the sample code to connect to the database using the iAnyWhere JDBC access method:
import java.util.Date;import java.sql.*;public class JdbcAccess {
private static Connection conn;private static Statement stmt;private static ResultSet rs;/** * @param args */public static void main(String[] args) throws SQLException, ClassNotFoundException {
Class.forName("ianywhere.ml.jdbcodbc.IDriver");
// DSN names should be changed based on the application database that you want// to connect.
conn = DriverManager.getConnection("jdbc:odbc:dsn=cmf","lmsdatafeed | lmssecuredatafeed","dbpasswd");
System.out.println("[" + new Date() + "] INFO: Connection successfull...");
//Create Statement nowstmt = conn.createStatement();String query = "SELECT Device_Id, Device_Display_Name, Management_IPAddress FROM
Network_Devices";rs = stmt.executeQuery(query);while (rs.next()) {
System.out.println("Device_Id: " + rs.getString("Device_Id"));System.out.println("Device_Display_Name: " +
rs.getString("Device_Display_Name"));System.out.println("Management_IPAddress" +
rs.getString("Management_IPAddress"));
System.out.println("-----------------------------------------------------------");}
}}
Note This sample code uses the iAnywhere driver. You must include the jodbc.jar file (NMSROOT/lib/classpath/jodbc.jar) in the CLASSPATH before you connect to the database.
In the code snippet below, you must change the dsn names based on the application database to which you want to connect:
conn = DriverManager.getConnection("jdbc:odbc:dsn=cmf","lmsdatafeed | lmssecuredatafeed","dbpasswd");
where,
• dsn=cmf —Name of the data source. In this sample, the data source name refers to cmf. See Application Data Source Names for details on dsn names to connect to the database.
• lmsdatafeed — Default username to connect as a normal database view user
• lmssecuredatafeed — Default username to connect as a secure database view user
• dbpasswd — Database view password. You should enter the password corresponding to the view username you are using to connect to the database.
5Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Accessing Database Views
Application Data Source Names
The following table lists the data source names of LMS applications whose database views are exposed:
Accessing Database Using ODBC Access Method
The following is the sample code to connect to the database using the ODBC access method:
use DBI;my ($dbh, $cur, $sqlstr);my $connString = "dsn=cmf;uid=lmsdatafeed | lmssecuredatafeed";$dbh = DBI->connect('DBI:ASAny:', $connString, 'dbpasswd', {PrintError => 1});if ($dbh) { my $sqlstr = "SELECT Device_Id, Device_Display_Name, Management_IPAddress FROM Network_Devices"; my $cur = $dbh->prepare($sqlstr); $cur->execute if ($cur); while (my $rs = $cur->fetchrow_arrayref) { my ($devId, $dispName, $ip,) = @$rs; print "Device_Id: $devId\n"; print "Device_Display_Name: $dispName\n"; print "Management_IPAddress: $ip\n"; print "--------------------------------------------\n"; } $cur->finish; $dbh->disconnect();}
To run this perl code on LMS Server:
Step 1 Create a perl file, for example, sample.pl and store it on your LMS Server.
Step 2 Update the perl file with the sample perl code given above to connect to the database.
Step 3 Save the changes to the perl file.
Step 4 Run the perl script using the following commands:
• NMSROOT/bin/perl Perl_file_name (on Solaris or Soft Appliance systems)
• NMSROOT\bin\perl Perl_file_name (on Windows systems)
where,
• NMSROOT — LMS Installation directory.
• Perl_file_name —Absolute file name of the perl script with the code to connect to the database.
For example, if you have stored the perl file sample.pl under C:\ in a Windows systems, and if the LMS installation directory is under D:\CSCOpx you must enter the following to run the perl script:
D:\CSCOpx\bin\perl C:\sample.pl
Application Data Source Name (dsn)
Common Services cmf
Network Topology, Layer 2 Services and User Tracking
ani
Inventory, Config and Image Management rmeng
Fault Management (Fault History) dfmFh
6Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Accessing Database Views
In the code snippet below, you must change the dsn names based on the application database to which you want to connect:
my $connString = "dsn=cmf;uid=lmsdatafeed | lmssecuredatafeed";$dbh = DBI->connect('DBI:ASAny:', $connString, 'dbpasswd', {PrintError => 1});
where,
• dsn=cmf —Name of the data source. In this sample, the data source name refers to cmf. See Application Data Source Names for details on dsn names to connect to the database.
• lmsdatafeed — Default username to connect as a normal database view user.
• lmssecuredatafeed — Default username to connect as a secure database view user.
• dbpasswd — Database view password. You should enter the password corresponding to the view user name you are using to connect to the database.
Accessing the Database From a Remote ServerThis section explains how to access the database in a LMS Server from a remote server. It contains:
• Prerequisites for Accessing Database Views on Windows Systems
• Prerequisites for Accessing Database Views on Solaris and Soft Appliance Systems
• Sample Code to Access Database From a Remote Server
Prerequisites for Accessing Database Views on Windows Systems
Before you access the database views in the LMS Server, from a remote Windows server, you must:
• Copy the LMS files to the remote Windows server
• Create DSNs in the remote Windows server
This section explains:
• Copying LMS files to a Remote Windows Server
• Creating DSNs on Windows Systems
Copying LMS files to a Remote Windows Server
Before you access the database views from a remote Windows server, you must copy the following LMS files to a directory on the remote server:
If LMS is not installed on a Windows server, go to /opt/CSCOpx/RemoteDbAccess and extract the files from RemoteDbAccess.zip file.
• NMSROOT\lib\classpath\jconn2.jar
• NMSROOT\lib\classpath\jodbc.jar
• NMSROOT\objects\db\win32\dbodbc10.dll
• NMSROOT\objects\db\win32\dblgen10.dll
• NMSROOT\objects\db\win32\dbcon10.dll
If you use perl on the remote server to access the LMS database, ensure that you have installed the required Sybase-related perl modules such as DBI and DBD::ASAny.
7Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Accessing Database Views
You can search for the perl modules DBI and DBD::ASAny in the URL http://www.cpan.org and download them to your remote server.
Creating DSNs on Windows Systems
To create DSNs and configure ODBC on Windows systems:
Step 1 Launch the Registry Editor on remote Windows server.
Step 2 On a Windows 32 bit server, navigate to HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\ODBC Drivers in the registry tree on the left.On a Windows 64 bit server, navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers in the registry tree on the left.
Step 3 Click Edit > New > Key to create a new registry key.
Step 4 Rename the newly created registry key as Cisco Prime Embedded Database.
Step 5 Click Edit > New > Expandable String value to create an expandable string value for Cisco Prime Embedded Database key.
Step 6 Enter the name of the expandable string value that you have created as Driver and value data as Location_Name\dbodbc10.dll.
Location_Name denotes the folder name where you have stored the LMS files.
For example, if you have stored the LMS files in C:\dbaccess, the value data is C:\dbaccess\dbodbc10.dll.
Step 7 Click Edit > New > Expandable String value to create another expandable string value for LMS Embedded Database key.
Step 8 Enter the name of the expandable string value that you have created as Setup and value data as Location_Name\dbodbc10.dll.
Location_Name denotes the folder name where you have stored the LMS files.
For example, if you have stored the LMS files at C:\dbaccess, the value data is C:\dbaccess\dbodbc10.dll.
Step 9 On a Windows 32 bit server, navigate to HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\ODBC Drivers in the registry tree on the left.On a Windows 64 bit server, navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers in the registry tree on the left.
Step 10 Click Edit > New > String value to create a string value for ODBC Drivers key.
Step 11 Enter the value name as Cisco Prime Embedded Database and value data as Installed.
Step 12 Click File > Exit to quit the Registry Editor.
Step 13 On a Windows 32 bit system, click Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC).On a Windows 64 bit system, go to the directory in which Windows is installed and navigate to SysWOW64 \ odbcad32.exe
The ODBC Data Source Administrator dialog box appears.
Step 14 Click the System DSN tab.
Step 15 Click the Add... button.
8Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Accessing Database Views
The Create Data Source dialog box appears with the list of drivers for which you want to set up data sources.
Step 16 Select Cisco Prime Embedded Database and click Finish.
The ODBC Configuration for SQL Anywhere 10 dialog box appears.
Step 17 Enter the name of the data source to which you want to connect in the Data source name field.
For example, if you want to connect to the Common Services database, you must enter the data source name as cmf. See Application Data Source Names for details on dsn names to connect to the database.
Step 18 Enter a brief description of the data source in the Description field.
Step 19 Click the Login tab in the ODBC Configuration for SQL Anywhere 10 dialog box.
Step 20 Enter the username to connect to the database view in the User ID field.
The default normal database view username is lmsdatafeed. The default secure database view username is lmssecuredatafeed.
Step 21 Enter the password to connect to the database view in the Password field.
Step 22 Click the Database tab of the ODBC Configuration for SQL Anywhere 10 dialog box.
Step 23 Enter the name of the application database engine in the Server Name field.
See Application Database Engine Name Details for details of the application engine names to enter.
Step 24 Select the Stop database after last disconnect checkbox if you need to stop the database after the connections are removed.
Step 25 Click the Network tab.
Step 26 Enter HOST=Host_name;DOBROADCAST=NO;ServerPort=App_DB_Port in the TCP/IP field.
where,
• Host_name — Denotes the hostname or IP Address of the remote LMS Server to which you want to connect.
• App_DB_Port— Denotes the port number that is used to connect to the application database. See Application Database Names and Port Number Details for details on other port numbers that can be used.
For example, to connect to Common Services application in the LMS Server whose IP Address is 10.77.213.130, you must enter the following in the TCP/IP field.
HOST=10.77.213.130;DOBROADCAST=NO;ServerPort=43441
Step 27 Click OK to go back to Create DataSource Dialog box.
Step 28 Click OK to apply the changes.
Application Database Engine Name Details
The following table lists the data engine names of LMS applications whose database views are exposed:
Application Database Engine Name
Common Services cmfEng
Network Topology, Layer 2 Services and User Tracking
aniEng
Inventory, Config and Image Management rmengEng
Fault Management (Fault History) dfmFhEng
9Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Accessing Database Views
Prerequisites for Accessing Database Views on Solaris and Soft Appliance Systems
Before you access the database views on the LMS Server, from a remote Windows server, you must:
• Copy the LMS files to a remote Solaris and Soft Appliance servers
• Create DSNs on a remote Solaris and Soft Appliance servers
This section explains:
• Copying LMS files to a Remote Solaris and Soft Appliance Servers
• Creating DSNs on Solaris and Soft Appliance Systems
10Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Accessing Database Views
Copying LMS files to a Remote Solaris and Soft Appliance Servers
Before you access the database views from a remote Solaris and Soft Appliance servers, you must copy the following LMS files to a directory on the remote server:
• NMSROOT/lib/classpath/jconn2.jar
• NMSROOT/lib/classpath/jodbc.jar
• NMSROOT/objects/db/lib32/libdbodbc10.so.1
• NMSROOT/objects/db/lib32/libdblib10.so.1
If you use perl on the remote server to access the LMS database, ensure that you have installed the required Sybase-related perl modules such as DBI and DBD::ASAny.
You can search for the perl modules DBI and DBD::ASAny in the URL http://www.cpan.org and download them to your remote server.
Creating DSNs on Solaris and Soft Appliance Systems
To create DSNs on Solaris and Soft Appliance systems:
Step 1 Create a configuration file .odbc.ini under the directory /opt.
Step 2 Add the following content to the .odbc.ini configuration file:
[Application Name]
EngineName=Name_of _the _Application_Engine
PWD=Password
CommLinks=tcpip{HOST=LMS_Server_Name;DOBROADCAST=NO;ServerPort=Application_Port_Number}
Driver=NMSRoot/objects/db/lib32/libdbodbc10.so.1
UID=Default_Database_View_User_Name
Description=Cisco Prime Embedded Database
where,
• LMS_Server_Name— Default LMS installation directory.
• Application Name — Name of the application database to which you want to connect.
• Name_of _the _Application_Engine — Name of the application engine. See Application Database Engine Name Details for details on the application engine names to enter.
• Password — Password used to connect to the database.
• LMS_Server_Name — Hostname or IP Address of the remote LMS Server to which you want to connect
• Application_Port_Number — Port number that is used to connect to the application database. See Application Database Names and Port Number Details for details of other port numbers to be used.
• Database_View_User_Name — Database view username. To connect as a normal database view user, the default username is lmsdatafeed. To connect as a secure database view user, the default username is lmssecuredatafeed.
11Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Accessing Database Views
For example, to add the DSN for Common Services application in the LMS server whose IP Address is 10.77.213.130, you must add the following lines to /opt/.odbc.ini configuration file.
[cmf]
EngineName=cmfEng
PWD=cisco
CommLinks=tcpip{HOST=10.77.213.130;DOBROADCAST=NO;ServerPort=43441}
Driver=/opt/CSCOpx/objects/db/lib32/libdbodbc10.so.1
UID=lmsdatafeed
Description=Cisco Prime Embedded Database
You can add multiple DSNs for other LMS applications in the /opt/.odbc.ini file.
Step 3 Set the environmental variable ODBCINI to point to the /opt/.odbc.ini file by running the following command:
setenv ODBCINI /opt/.odbc.ini
Sample Code to Access Database From a Remote Server
After you have copied the required files from LMS Server to remote server and created DSNs, you can access the LMS database from a remote server.
See the following sections for the sample code to access the LMS database:
• Accessing Database Using Jconnect JDBC Access Method
• Accessing Database Using iAnyWhere JDBC Access Method
• Accessing Database Using ODBC Access Method
Importing Data into Microsoft Office Excel Using dbviewsTo import data into Microsoft Office Excel using DbViews
Step 1 Open a new worksheet in Microsoft Excel.
Step 2 Choose Data > Import External Data > New Database Query.
Step 3 Select the required DSN name.
Step 4 Select Views from Table Options.
Step 5 Click OK.
Step 6 Select the table from the list of tables annmsd columns and the columns required.
Step 7 Click Next.
Step 8 Filter the data to specify which rows to include in your query if required.
Step 9 Click Next.
Step 10 Specify how the data should be sorted if required.
Step 11 Click Next.
Step 12 Select Return to Microsoft Office Excel.
Step 13 Click Finish.
12Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Changing the Database Password
Step 14 Select the appropriate range in the Excel worksheet to import the data.
Step 15 Click Ok.
For importing data into Microsoft Excel from a remote server:
Step 1 Copy the following LMS directories to your local system:
• NMSROOT/objects/db/charsets
• NMSROOT/objects/db/java
• NMSROOT/objects/db/scripts
• NMSROOT/objects/db/win32
Step 2 Create a new DSN for exporting data to Microsoft Office Excel. See Creating DSNs on Windows Systems
Step 3 Click the Login tab in the ODBC Configuration for SQL Anywhere 10 dialog box.
Step 4 Enter the username to connect to the database view in the User ID field.
The default normal database view username is lmsdatafeed. The default secure database view username is lmssecuredatafeed.
Step 5 Enter the password to connect to the database view in the Password field.
Step 6 Click the Database tab of the ODBC Configuration for SQL Anywhere 10 dialog box.
Step 7 Go to Step 3 of the previous section and continue till Step 9
Changing the Database PasswordWhile installing LMS, the installer prompts you to enter the database password. If you do not enter the password, LMS generates the password at random.
However, we recommend that you change the password periodically to ensure system security.
You must use the dbpasswd.pl utility to change the database password.
Caution You need to shut down LMS, change the password and then restart LMS, for the changes to take effect. Make sure you are not running any critical tasks. Otherwise, you might lose data.
This section explains the following:
• Changing Password on Solaris and Soft Appliance
• Changing Password on Windows
• Formats Available for Changing the Database Password
13Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Changing the Database Password
Changing Password on Solaris and Soft ApplianceTo change the password on Solaris and Soft Appliance:
Step 1 Log in as the superuser, and enter the root password.
Step 2 Stop all processes by entering:
/etc/init.d/dmgtd stop
Step 3 Change to the installation directory by entering:
cd NMSROOT/bin
NMSROOT is your default LMS installation directory.
Step 4 Enter the following command to list the different formats available for changing the database password:
NMSROOT/bin/perl dbpasswd.pl
Step 5 When prompted, enter the new password and verify it by re-entering it.
The password can contain a maximum of 30 characters.
Step 6 Start all processes by entering:
/etc/init.d/dmgtd start
Changing Password on WindowsTo change the password on Windows:
Step 1 At the command line, make sure you have the correct permissions.
Step 2 Stop all processes by entering:
net stop crmdmgtd
Step 3 Change to the Installation Directory by entering:
cd NMSROOT\bin
NMSROOT is your default LMS installation directory.
Step 4 Enter the following command to list the different formats available for changing the database password:
NMSROOT\bin\perl dbpasswd.pl
Step 5 When prompted, enter the new password and verify it by re-entering it.
The password can contain a maximum of 30 characters.
Step 6 Start all processes by entering:
net start crmdmgtd
14Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Changing the Database Password
Formats Available for Changing the Database PasswordThe different formats available and the commands for changing the database passwords on Windows and Solaris and Soft Appliance platform are tabulated below:
Format Command
Format 1 detects the available datasource names and databases and prompts you to enter and confirm the passwords for each of them.
It also allows you to encrypt the password.
On Solaris and Soft Appliance:
NMSROOT/bin/perl dbpasswd.pl all
On Windows:
NMSROOT\bin\perl dbpasswd.pl all
Format 2 allows you to list all the databases and datasource names (DSNs) available in the server.
On Solaris and Soft Appliance:
NMSROOT/bin/perl dbpasswd.pl listdsn
On Windows:
NMSROOT\bin\perl dbpasswd.pl listdsn
Format 3 allows you to change the database password.
On Solaris and Soft Appliance:
NMSROOT/bin/perl dbpasswd.pl dsn=odbc_datasource
On Windows:
NMSROOT\bin\perl dbpasswd.pl dsn=odbc_datasource
Format 4 allows you to change the database password for a specific DSN.
It also allows you to enter a new password in the command line using the npwd option.
On Solaris and Soft Appliance:
NMSROOT/bin/perl dbpasswd.pl dsn=dsn-name npwd=new-password
On Windows:
NMSROOT\bin\perl dbpasswd.pl dsn=dsn-name npwd=new-password
Format 5 allows you to encrypt the existing database password.
On Solaris and Soft Appliance:
NMSROOT/bin/perl dbpasswd.pl dsn=dsn-name encyption=yes
On Windows:
NMSROOT\bin\perl dbpasswd.pl dsn=dsn-name encyption=yes
Format 6 allows you to change the database password for a specific DSN.
Format 6.0 also:
• Allows you to enter a new password in the command line using the npwd option.
• Allows you to encrypt the password using the encryption option.
On Solaris and Soft Appliance:
NMSROOT/bin/perl dbpasswd.pl dsn=dsn-name npwd=new-password encryption=yes
On Windows:
NMSROOT\bin\perl dbpasswd.pl dsn=dsn-name npwd=new-password encryption=yes
15Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Exposed Database Views and Tables
Exposed Database Views and TablesTable 1 lists the database views or tables that are exposed in LMS applications.
Table 1 Exposed Database Views and Tables
LMS Application Name of Views or Tables
Common Services (CS) Views Network_Devices
Job_Details
Network Topology, Layer 2 Services and User Tracking Views
End_Hosts
UT_History
VTPDomainPorts
Fault Management Views Fault_Alert_History
Fault_Event_History
Fault_Event_Details
Inventory, Config and Image Management Views
Device_Inventory
Module_Inventory
Port_Inventory
Processor_Inventory
Memory_Inventory
Device_Credential_Status
Device_Inventory_Collection_Status
Device_Config_Archive_Status
Change_Audit_History
Syslog_Today
Syslog_Lastday
Device_EnergyWise
Port_EnergyWise
EnergyWise_Domain
16Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Exposed Database Views and Tables
IPSLA Performance Management (Tables)
Source (Source Table)
Target (Target Table)
IPMDevice (IPM Device Table)
Operation (Operation Table)
IPEchoOper (IPEcho Sub-Operation Table)
UDPEchoOper (UDP Echo Sub-Operation Table)
PathEchoOper (PathEcho Sub-Operation Table)
jitter_oper (Jitter Sub-Operation Table)
ICMPJitterOper (ICMP Jitter Sub-Operation Table)
RTPOper (RTP Sub-Operation Table)
ethernet_oper (Ethernet Sub-Operation Table)
http_oper (HTTP Operation Table)
dns_oper (DNS Operation Table)
ftp_oper (FTP Operation Table)
dhcp_oper (DHCP Operation Table)
DLSwOper (DLSw Operation Table)
PostDialDelayOper (Post Dial Delay Operation Table)
tcpconnect_oper (TcpConnect Operation Table)
ReactTable (React Table)
Collector (Collector Table)
VrfList (VRF List Table)
outage_details (Outage Details Table)
completed_outages (Completed Outage Table)
Collector_Schedule (Collector Schedule Table)
Latency_Minute_Stats (Latency Minute Statistics Table)
Availability_Latency_Hourly_Stats (Availability Latency Hourly Statistics Table)
Availability_Latency_Daily_Stats (Availability Latency Daily Statistics Table)
Availability_Latency_Weekly_Stats (Availability Latency Weekly Statistics Table0
Availability_Latency_Monthly_Stats (Availability Latency Monthly Statistics Table)
Jitter_Minute_Stats (Jitter Minute Statistics Table)
Jitter_Hourly_Stats (Jitter Hourly Statistics Table)
Jitter_Daily_Stats (Jitter Daily Statistics Table)
Jitter_Weekly_Stats (Jitter Weekly Statistics Table)
Table 1 Exposed Database Views and Tables (continued)
LMS Application Name of Views or Tables
17Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Exposed Database Views and Tables
IPSLA Performance Management (Tables)
(continued)
Jitter_Monthly_Stats (Jitter Monthly Statistics Table)
ICMP_Jitter_Minute_Stats (ICMP Jitter Minute Statistics Table)
ICMP_Jitter_Hourly_Stats (ICMP Jitter Hourly Statistics Table)
ICMP_Jitter_Daily_Stats (ICMP Jitter Daily Statistics Table)
ICMP_Jitter_Weekly_Stats (ICMP Jitter Weekly Statistics Table)
ICMP_Jitter_Monthly_Stats (ICMP Jitter Monthly Statistics Table)
Ethernet_Jitter_Minute_Stats (Ethernet Jitter Minute Statistics Table)
Ethernet_Jitter_Hourly_Stats (Ethernet Jitter Hourly Statistics Table)
Ethernet_Jitter_Daily_Stats (Ethernet Jitter Daily Statistics Table)
Ethernet_Jitter_Weekly_Stats (Ethernet Jitter Weekly Statistics Table)
Ethernet_Jitter_Monthly_Stats (Ethernet Jitter Monthly Statistics Table)
Http_Minute_Stats (HTTP Minute Statistics Table)
Http_Hourly_Stats (HTTP Hourly Statistics Table)
Http_Daily_Stats (HTTP Daily Statistics Table)
Http_Weekly_Stats (HTTP Weekly Statistics Table)
Http_Monthly_Stats (HTTP Monthly Statistics Table)
PATHECHO_Hourly_Stats (Pathecho Hourly Statistics Table)
PATHECHO_Daily_Stats (Pathecho Daily Statistics Table)
PATHECHO_Weekly_Stats (Pathecho Weekly Statistics Table)
PATHECHO_Monthly_Stats (Pathecho Monthly Statistics Table)
RTP_Minute_Stats (RTP Minute Statistics Table)
RTP_Hourly_Stats (RTP Hourly Statistics Table)
RTP_Daily_Stats (RTP Daily Statistics Table)
RTP_Weekly_Stats (RTP Weekly Statistics Table )
RTP_Monthly_Stats (RTP Monthly Statistics Table)
video_oper (Video Operations Table)
Video_Minute_Stats (Video Minute Statistics Table)
Table 1 Exposed Database Views and Tables (continued)
LMS Application Name of Views or Tables
18Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Schema of Exposed Database ViewsThis section explains the exposed tables, the fields in each table, the type of fields and a brief description about each field.
Note The column names in the exposed database views are case insensitive.
Schema of Exposed Database Views contains the details of the following views:
• Network_Devices View Details
• Job_Details View Details
• End_Hosts View Details
• UT_History View Details
• VTPDomainPorts View Details
• Device_Inventory View Details
• Module_Inventory View Details
• Port_Inventory View Details
• Processor_Inventory View Details
• Memory_Inventory View Details
• Device_Credential_Status View Details
• Device_Inventory_Collection_Status View Details
• Device_Config_Archive_Status View Details
• Change_Audit_History View Details
• Syslog_Today or Syslog_Lastday View Details
• Device_EnergyWise View Details
• Port_EnergyWise View Details
• EnergyWise_Domain View Details
• Fault_Event_History View Details
• Fault_Event_Details View Details
IPSLA Performance Management (Tables)
(continued)
Video_Hourly_Stats (Video Hourly Statistics Table
Video_Daily_Stats (Video Daily Statistics Table)
Video_Weekly_Stats (Video Weekly Statistics Table)
Video_Monthly_Stats (Video Monthly Statistics Table)
Table 1 Exposed Database Views and Tables (continued)
LMS Application Name of Views or Tables
19Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Network_Devices View DetailsNetwork_Devices view displays the network devices information, as explained in Table 2.
Job_Details View DetailsJob_Details view displays the Job details information, as explained in Table 3.
Table 2 Network_Devices Schema Details
Column Name Column Type Constraints Column Description
Device_Id integer PRIMARY DCR Device ID. Unique Identifier for the device
Device_Display_Name varchar(128) Not Null Device Display Name
Management_Ip_Address varchar(128) Null Management IP Address of the device
Host_Name varchar(128) Null Hostname of the device
Domain_Name varchar(128) Null Domain Name of the device
sysObjectID varchar(128) Null SysObjectId of the device
Device_Category varchar(512) Null Device category
Device_Series varchar(512) Null Device Series name
Device_Model varchar(512) Null Device Model name
UDF0-15 varchar(128) Null A maximum of 16 user-defined fields are allowed.
The first field name is UDF$FieldNumber
For example, UDF0.
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
20Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Job_Sch_Type integer Not null Frequency of the job.
Options include:
• Run immediately
• Run once
• Run on a calendar basis (periodic)
• Run on a time-start basis
• Run on a time-stop basis
The integer values are:
• 0 — Never Ran
• 1 — Immediate
• 2 — Run Once
• 257 — Day of Every Month
• 258 — Day of Every Week
• 259 — Every N-th Day
• 260 — Last week day (Sunday, Monday, or so on) of every N-th month
• 261 — Same week day (Sunday, Monday, or so on) of every N-th month
• 262 — the Last day of month every N-th month
• 263 — Weekdays (Sun,Mon,..Sat)
• 513 — Every N-Seconds (Start time based)
• 514 — Every N-Mins (Start time based)
• 515 — Every N-Hours (Start time based)
• 769 — Every N-Seconds (End time based)
• 770 — Every N-Mins (End time based)
• 771— Every N-Hours (End time based)
Table 3 Job_Details Schema Details (continued)
21Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
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.
Table 3 Job_Details Schema Details (continued)
22Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
End_Hosts View DetailsThe End_Hosts view displays the end host details, as explained in Table 4.
Table 4 End_Hosts Schema Details
Column Name Column Type Constraints Column Description
HostName varchar(64) Null Name of the end host
UserName varchar(64) Null Logged in username
IPAddress varchar(15) Null IP address of the end host
SubnetMask varchar(15) Null Subnet mask of the device to which end host is connected
MACAddress varchar(17) Null MAC address of the end host
DeviceName varchar(64) Null Device name (Host Name) to which the end host is connected
Device varchar(15) Null Device IP address to which the end host is connected
LastSeen varchar(32) Null Time at which end host is last seen
Port varchar(32) Null Name of the port to which the end host is connected
VLAN varchar(32) Null VLAN name.
Example: VLAN100
Subnet varchar(15) Null Subnet of the device to which the end host is connected
Notes varchar(255) Null Notes entered by the user
PrefixLength integer Null Subnet prefix length
PortDuplex varchar(32) Null Mode of the port to which end host is connected
VTPDomain varchar(32) Null VTP Domain Name of the device to which the end host is connected.
VlanId integer Null VLAN ID
Example: 100
PortName varchar(255) Null Port Description entered by the user
IPv6Address varchar(150) Null IPV6 address, if configured
dot1xEnabled varchar(15) Null dot1x enabled status.
The value could be True or False.
associatedRouters varchar(250) Null Comma separated list of routers in the subnet
23Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
UT_History View DetailsThe UT_History view displays the user tracking history details, as explained in Table 5.
VTPDomainPorts View DetailsThe VTPDomainPorts view displays the end host details, as explained in Table 6.
Table 5 UT_History Schema Details
Column Name Column Type Constraints Column Description
UserName varchar(30) Null Logged in username
MACAddress bigint Null MAC address of the end host
iLogin varchar(32) Null Date and time when the user logged in
iLogout varchar(32) Null Date and time when the user logged out
Table 6 VTPDomainPorts Schema Details
Column Name Column Type Constraints Column Description
isLink char Not Null True - Configured as Link Port
False - Not configured as Link Port
PortDescription varchar(255) Null Description of the port. It could be the CDP Name or Interface alias name
PortName varchar(254) Null Name of the port
Device Name varchar(64) Null Name of the device to which the port belongs to
Device IPAddress varchar(40) Null Management IP address of the device
PortStatus char Not Null Up - Port is operationally up and administratively up
Down - Port is down either operationally or administratively or both
isTrunk char Not Null True - Configured as Trunk Port
False - Not configured as Trunk Port
Vlan varchar(128) Null VLAN name associated with port.
Assosiation Type char Not Null Comma separated list of routers in the subnet.
The Association type could be:
• Secondary
• Auxiliary
• Native
• Unknown
24Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Device_Inventory View DetailsThis view displays the device inventory information as explained in Table 7.
Module_Inventory View DetailsThis view displays the module inventory information as explained in Table 8.
Port Mode char Not Null The port mode could be:
• Non-PVLAN
• PVLAN Host
• PVLAN Trunk
• Promiscuous
• Unknown
Domain varchar(64) Null Management Domain name.
dbId integer Primary DCR Device ID. Unique Identifier for the device.
Table 6 VTPDomainPorts Schema Details (continued)
Table 7 Device Inventory Schema Details
Column Name Column Type Constraints Column Description
Device_Id integer Not null DCR Device ID
Device_Display_Name varchar(128) Not null Device Display Name
Device_Description varchar(255) Null Description of the device
Device_Location varchar(255) Null Sys Location
Device_Contact varchar(255) Null Sys Contact
Device_SW_Version varchar(64) Null Device Software Version
User_Defined_Serial_Number varchar(255) Null User-defined serial number
Table 8 Module_Inventory Schema Details
Column Name Column Type Constraints Column Description
Device_Id integer Not null DCR Device ID
Device_Display_Name varchar(128) Not null Device Display Name
Module_Name varchar(255) Null Module
Vendor_Type varchar(255) Null Module Vendor Type
SW_Version varchar(255) Null Software version of the module
FW_Version varchar(255) Null Firmware version of the module
Slot_Number integer Null Slot Number of this module
Oper_Status smallint Null Operation Status
Admin_Status smallint Null Administrative status
25Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Port_Inventory View DetailsThis view displays the physical port inventory information from Configuration, Inventory, and Software Management, as explained in Table 9.
Table 9 Port_Inventory Schema Details
Column Name Column Type Constraints Column Description
Device_Id integer Not null DCR Device ID
Device_Display_Name varchar(128) Not null Device Display Name
Port_Name varchar(255) Null Name of Port from ifName
Port_Desc varchar(1024) Null Port description from ifDescr
Port_Type smallint Null Port type.
Enumeration from IANAifType MIB
Port_Admin_Status smallint Null Port Administrative status
Port_Oper_Status smallint Null Port Operation status
Port_Speed float Null Port Speed in bits per second
Port_Duplex_Mode varchar(15) Null Port Duplex Mode
Is_Link_Port smallint Null 0 — Configured as Link port
1— Not configured as Link port
Is_Access_Port smallint Null 0 — Configured as Access port
1— Not configured as Access port
Is_Trunk_Port smallint Null 0 — Configured as Non-Trunk port
1 — Configured as Trunk port
Is_Port_Channel smallint Null 0 — Channels are not configured
1 — Channels are configured
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
26Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Processor_Inventory View DetailsThis view displays the processor inventory information as explained in Table 10.
Memory_Inventory View DetailsThe Memory_Inventory view displays the processor memory information., as explained in Table 11.
Device_Credential_Status View DetailsThe Device_Credential_Status view displays the end host details, as explained in Table 12.
This is used to store the device credential check information. This information is available only if the CDA reports have been run.
Table 10 Processor_Inventory Schema Details
Column Name Column Type Constraints Column Description
Device_Id Integer Not null DCR Device ID
Device_Display_Name varchar(128) Not null Device Display Name
Processor_model_name varchar(255) Null Processor Model Name, if available
Processor_module_description varchar(255) Null Module description
Processor_vendor_type varchar(255) Null Vendor equipment type of processor
Processor_manufacturer varchar(255) Null Manufacturer, if available
serialnumber varchar(255) Null Serial Number, if available
Table 11 Memory_Inventory Schema Details
Column Name Column Type Constraints Column Description
Device_Id Integer Not null DCR Device ID
Device_Display_Name varchar(128) Not null Device Display Name
Processor_Memory numeric(29,9) Null Processor memory.
This is in Mega Bytes (MB).
Table 12 Device_Credential_Status Schema Details
Column Name Column Type Constraints Column Description
Device_Id integer PRIMARY DCR Device ID
Device_Display_Name varchar(128) Not null Device Display Name
27Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Credential_Type smallint Not null Credential Type.
The types could be:
• SNMP Read Write community
• SNMP Read Only
• SNMPv3
• Telnet
• Telnet Enable mode
• SSH
• SSH Enable mode
Credential_Type_Description varchar(64) Not null Description of the credentials mentioned in the Credential_Type column description.
Credential_Status smallint Not null Credential Check Status.
The integer values could be:
• 1 — OK
• 12 — Cannot test RW without RO
• 11 — OK (Primary Failed, Secondary Successful)
• 10 — OK (Primary Successful)
• 9 — Not implemented yet
• 8 — Failed (Because of wrong credentials)
• 7 — Not supported
• 6 — No Value to Test
• 5 — Did Not Try
• 4 — No Data Yet
• 3— Incorrect (unable to test the credentials because of connection failure)
• 2— No authentication configured
Cred_Status_Description varchar(64) Not null Description of the credential check status.
Cred_Status_Reason varchar(1024) Null Reason for success or failure.
Status_Update_Time varchar(60) Null Time (in milliseconds) at which the credentials are verified and updated.
Table 12 Device_Credential_Status Schema Details (continued)
28Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Device_Inventory_Collection_Status View DetailsThe Device_Inventory_Collection_Status view displays the Inventory collection status details, as explained in Table 13.
Device_Config_Archive_Status View DetailsThe Device_Config_Archive_Status view displays the Config Archive status details, as explained in Table 14.
Table 13 Device_Inventory_Collection_Status Schema Details
Column Name Column Type Constraints Column Description
Device_Id integer PRIMARY DCR Device ID
Device_Display_Name varchar(128) Not null Device Display Name
Inventory_Collection_Status integer Null Inventory Collection Status
• 1— Success
• 2— Failed
Failure_Reason varchar(255) Null Reason for inventory connection failure.
Value is blank if the connection did not fail.
Inventory_Updated_At timestamp Null Time when the inventory is last updated
Table 14 Device_Config_Archive_Status Schema Details
Column Name Column Type Constraints Column Description
Device_Id integer Not Null
Device_Id, Config_ Type and Config_File_Type columns form a Primary key.
DCR Device ID
Device_Display_Name varchar(128) Not null Device Display Name
Config_Type integer Not Null
Device_Id, Config_ Type and Config_File_Type columns form a Primary key.
The integer values could be:
• 1 — Primary
• 2 — VLAN
• 3 — Secondary
Config_File_Type integer Not Null
Device_Id, Config_ Type and Config_File_Type columns form a Primary key.
The integer values could be:
• 1 - STARTUP
• 2 - RUNNING
29Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Change_Audit_History View DetailsThe Change_Audit_History view displays the Change Audit History details, as explained in Table 15.
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
Table 14 Device_Config_Archive_Status Schema Details (continued)
Table 15 Change_Audit_History Schema Details
Column Name Column Type Constraints Column Description
Device_Id integer Not null DCR Device ID
Device_Display_Name varchar(128) Not null Device Display Name
Created_At timestamp Null Date and time when the application communicated the network change or when Change Audit module received the change record.
User_Name varchar(64) Null User who made the configuration change or discovered that there is a configuration change
App_Name varchar(64) Null Application that discovered the configuration change.
Archive Mgmt, ConfigEditor, CwConfig, ICServer, NetConfig, Software Management are the possible values for application names.
Host_Name varchar(64) Null Host name of the machine from which the user accessed the device or the host name of the LMS server.
The host name can contain the IP Address if the address does not resolve to a name.
The ICServer application enters the host name and the Config Archive application enters the IP Address of the server
Conn_Mode varchar(255) Null Connection mode through which the change was made.
SNMP, TFTP, TELNET, and CONSOLE are the possible values for connection modes
30Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Syslog_Today or Syslog_Lastday View DetailsThe Syslog_Today or Syslog_Lastday view displays the Syslog details as explained in Table 16.
These views are created everyday to reflect the current day and the previous day’s Syslog details.
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
Table 15 Change_Audit_History Schema Details (continued)
Table 16 Syslog Schema Details
Column Name Column Type Constraints Column Description
Device_Display_Name varchar(128) Not null Device Display Name
Syslog_Message_Id bigint PRIMARY Primary key
Syslog_Device_Id bigint Null DCR device ID
Syslog_Device_Name varchar(255) Not null The IP Address of the interface through which the syslog was sent.
Syslog_TimeStamp timestamp Null Date and time the message was logged. This timestamp is provided by the device.
Syslog Analyzer provides a timestamp if the device does not provide one.
Syslog_Facility char(48) Null Facility can be a hardware device, a protocol, or a module of the system software.
For example, SYS.
See the System Error Messages section in the Cisco IOS reference manual for a predefined list of facility codes.
Syslog_SubFacility char(48) Null Facility in the device that generated the Syslog message.
In most cases, this is blank.
For example, SYS-5-CONFIG I.
Syslog_Severity char(1) Null Message severity level.
The level varies from informational (6) to emergency (0).
31Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Device_EnergyWise View DetailsThe Device_EnergyWise view details displays the EnergyWise details of a device as explained in Table 17.
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
Table 16 Syslog Schema Details (continued)
Table 17 Device_EnergyWise Schema Details
Column Name Column Type Constraints Column Description
Device_ID integer PRIMARY DCR Device ID. Unique Identifier for the device.
Device_Display_Name varchar(128) Not Null Device Display Name.
DomainName varchar(255) Null Name of the EnergyWise domain consisting EnergyWise-enabled devices and endpoints.
Keyword varchar(255) Null Word that helps you identify a specific device or group of devices.
Role varchar(255) Null Role or function of the device in the EnergyWise domain.
Importance smallint Null Value of EnergyWise Importance of the endpoint.
This value differentiates the endpoints in a domain based on their power usage. For example, a desk phone has a lower importance than a business-critical emergency phone.
Value can be within the range of 1 to 100.
EnergyWiseState smallint Null EnergyWise status of the device.
0 — Software Incapable
1 — Disabled
2 — Enabled
MinSupportedOS varchar(50) Null Minimum supported software for the device.
32Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Port_EnergyWise View DetailsThe Port_EnergyWise viewdetails displays the EnergyWise details of a port as explained in Table 18.
EnergyWise_Domain View DetailsThe EnergyWise_Domain view details displays the EnergyWise domain details as explained in Table 19.
Note You can access EnergyWise_Domain view only when you connect the database as a secure database view user.
Table 18 Port_EnergyWise Schema Details
Column Name Column Type Constraints Column Description
Device_ID integer PRIMARY DCR Device ID. Unique Identifier for the device.
Device_Display_Name varchar(128) Not Null Device Display Name.
Portname varchar(255) Null Port to which the endpoint is connected.
Keyword varchar(255) Null Word that helps you identify a specific device or group of devices.
Role varchar(255) Null Role or function of the device in the EnergyWise domain.
Importance smallint Null Value of EnergyWise Importance of the endpoint.
This value differentiates the endpoints in a domain based on their power usage. For example, a desk phone has a lower importance than a business-critical emergency phone.
Value can be within the range of 1 to 100.
Table 19 EnergyWise_Domain Schema Details
Column Name Column Type Constraints Column Description
Device_ID integer PRIMARY DCR Device ID. Unique Identifier for the device.
Device_Display_Name varchar(128) Not Null Device Display Name.
Device_IPAddress varchar(128) Null Management IP Address of the device.
Hostname varchar(128) Null Hostname of the device.
Domain varchar(255) Null Name of the EnergyWise domain consisting EnergyWise-enabled devices and endpoints.
Domain_Secret varchar(255) Null Secret used by the EnergyWise protocol to enable communication between devices within the domain.
Management_Secret varchar(255) Null Secret used by the LMS server to collect data from the devices in the domain.
33Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Schema of Exposed Database Views
Fault_Event_History View DetailsThe Fault_Event_History view displays the fault event history details as explained in Table 20.
Event List contains the list of events for an alert.
Endpoint_Secret varchar(255) Null Secret used by EnergyWise protocol to communicate with the endpoint devices in the domain.
NTP_Secret varchar(255) Null Secret used by the EnergyWise protocol to enable communication between devices in the domain.
Port bigint Null Port to which the endpoint is connected.
Table 19 EnergyWise_Domain Schema Details (continued)
Table 20 Fault_Event_History Schema Details
Column Name Column Type Constraints Column Description
Device_Name varchar(255) Null Device name or IP address.
Event_Id bigint Not null Event identifier number.
Alert_Id bigint Not null Alert identifier number
Event_Name varchar(255) Null Event name.
See the Online help for the Event Monitor processed by LMS.
Event_Status varchar(16) Null Event status, based on last polling.
The status could be:
• Active — Event is live.
• Cleared — Event is no longer live.
Events on suspended devices are moved to Cleared, but the alert remains active.
• Suspended — Device is suspended.
• Resumed — Device is being resumed.
• Deleted — Device has been deleted
Component_Name varchar(255) Null Device element on which the event occurred.
Event_Update_Time bigint Null Time at which the event occurred.
The time is the number of seconds elapsed from Jan 1 1970
34Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Fault_Event_Details View DetailsThe Fault_Event_History view displays the fault event details as explained in Table 21.
Event Details contains the properties and details of the event. Each event may have multiple properties and the number of properties is dependent on the event type. So each property is represented as one row.
For example, if the event has five properties, there will be five rows for that event.
IPSLA Database SchemaThe IPM database schema defines the tables, fields in each table and the relationships between fields and tables.
The IPM database schema details are updated after installing the application and launching the same. You do not need to run the dbaccess.pl utility to see the schema details.
This section contains:
• Connecting to IPSLA Database
• Schema of IPSLA Database Tables
Connecting to IPSLA DatabaseTo connect to the IPSLA database, you may have to enter the following information:
• Username — DBA
• Database password — You must enter the database password that you have provided while installing LMS
To change the database password, see the Changing the Database Password section.
• Database name — ipm
• Database source name — ipm
• Database engine name — ipmEng
Schema of IPSLA Database TablesThis chapter contains the following tables:
• Source Table
• Target Table
• IPMDevice Table
• Operation Table
Table 21 Fault_Event_History Schema Details
Column Name Column Type Constraints Column Description
Event_Id bigint Not null Event identifier number
Event_Property_Name varchar(32) Null Name of the property
Event_Property_Value varchar(255) Null Property value
35Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
• IPEchoOper Table
• UDPEchoOper Table
• PathEchoOper Table
• jitter_oper Table
• ICMPJitterOper Table
• RTPOper Table
• ethernet_oper Table
• http_oper Table
• dns_oper Table
• ftp_oper Table
• dhcp_oper Table
• DLSwOper Table
• PostDialDelayOper Table
• tcpconnect_oper Table
• React Table
• Collector Table
• User Stopped Collector Table
• VrfList Table
• outage_details Table
• completed_outages Table
• Collector _Schedule Table
• Latency_Minute_Stats Table
• Availability_Latency_Hourly_Stats Table
• Availability_Latency_Daily_Stats Table
• Availability_Latency_Weekly_Stats Table
• Availability_Latency_Monthly_Stats Table
• Jitter_Minute_Stats Table
• Jitter_Hourly_Stats Table
• Jitter_Daily_Stats Table
• Jitter_Weekly_Stats Table
• Jitter_Monthly_Stats Table
• ICMP_Jitter_Minute_Stats Table
• ICMP_Jitter_Hourly_Stats Table
• ICMP_Jitter_Daily_Stats Table
• ICMP_Jitter_Weekly_Stats Table
• ICMP_Jitter_Monthly_Stats Table
• Ethernet_Jitter_Minute_Stats Table
• Ethernet_Jitter_Hourly_Stats Table
36Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
• Ethernet_Jitter_Daily_Stats Table
• Ethernet_Jitter_Weekly_Stats Table
• Ethernet_Jitter_Monthly_Stats Table
• Http_Minute_Stats Table
• Http_Hourly_Stats Table
• Http_Daily_Stats Table
• Http_Weekly_Stats Table
• Http_Monthly_Stats Table
• PATHECHO_Hourly_Stats Table
• PATHECHO_Daily_Stats Table
• PATHECHO_Weekly_Stats Table
• PATHECHO_Monthly_Stats Table
• RTP_Minute_Stats Table
• RTP_Hourly_Stats Table
• RTP_Daily_Stats Table
• RTP_Weekly _Stats Table
• RTP_Monthly_Stats Table
• video_oper Table
• Video_Minute_Stats Table
• Video_Hourly_Stats Table
• Video_Daily_Stats Table
• Video_Weekly_Stats Table
• Video_Monthly_Stats Table
Source Table
The Source table is given in Table 22.
Table 22 Source Table
Column Name Type Constraints Description
DeviceID Bigint IDENTITY,
primary key
Unique identifier
IOSVersion Varchar(64) Null Version of IOS
MaxColl Integer Null Estimated System.
The maximum number of entries in the router.
37Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Note Source Table (table name ‘Source’) contains all necessary information about a source router. A unique device ID is assigned to each source router. This device ID acts as the Primary Key of the table.
Target Table
The Target table is given in Table 23.
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.
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
Table 22 Source Table (continued)
Table 23 Target Table
Column Name Type Constraints Description
DeviceID Bigint IDENTITY, Primary key
Unique identifier
DisplayName Varchar(255) Null Display name of the device
DeviceType Integer Null Type of target
• 0 = ip target
• 1 = responder enabled
• 2 = adhoc device
38Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
IPMDevice Table
The IPM Device Table is given in Table 24.
Operation Table
Details of Operation Table is given in Table 25.
Table 24 IPMDevice Table
Column Name Type Constraints Description
DeviceID Bigint IDENTITY, Primary key
Unique identifier
DCRID Varchar(255) Null Device ID from the DCR table
snmptimeout Bigint Null Duration for which a system should wait for a device to respond before the system retries to access the device.
The SNMP timeout values are displayed in milliseconds.
The default value is 2.The minimum value is 0. There is no maximum value.
snmpretry Bigint Null Number of times the system retries to access devices using SNMP options.
The default value is 3. The minimum value is 0. The maximum value is 6.
Table 25 Operation Table
Column Name Type Constraints Description
OperationID Bigint IDENTITY,
primary key
Unique identifier
CreationFlag Integer Not Null Flag 0 – system defined operations
Flag 1 – user defined operations
Operation Name Varchar(127) Not Null Unique operation name
Owner Varchar(64) Null See MIB object:
rttMonCtrlAdminOwner
MIB type:
OwnerString
Owner of the Operation
Descr Varchar(255) Null Description
39Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
RTTType Integer Null See MIB object:
rttMonCtrlAdminRttType
MIB type:
RttMonRttType
Default Value:
{echo}
Specifies the type of RTT operation to be performed:
1 = echo
2 = pathEcho
5 = udpEcho
6 = tcpConnect
7 = http
8 = dns
9 = jitter
10 = dlsw
11 = dhcp
12 = ftp
14 = RTP
16 = icmpjitter
18 = VoipCallSetupPostDialDelay
19 = VoipGKRegDelay
1019-Ethernetping
1020-Ethernetjitter
1119-EthernetPingAutoIPSLA
1120-EthernetPingAutoIPSLA
Frequency Integer Null See MIB object:
rttMonCtrlAdminFrequency
MIB type:
Integer32(0..604800)
The frequency values are displayed in seconds.
Default Value:
{ 60 }
Duration between initiating RTT
requests
Table 25 Operation Table (continued)
40Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Operation Table (table name ‘Operation’) contains general parameters for an operation, such as frequency, rtt type, and threshold type.
For parameters associated with a specific type of operation, check the detailed sub-operation table for the specific type of operation.
A unique Operation ID is also assigned to each operation in the table. This Operation ID acts as the Primary Key of the table.
timeout Integer Null See MIB object:
rttMonCtrlAdminTimeout
MIB type:
Integer32(0..604800000)
Default Value:
{ 5000 }
Duration to wait for an RTT response
adminThreshold Integer Not Null Threshold range in milli seconds
verifydata smallint Not Null See MIB object:
rttMonCtrlAdminVerifyData
Default Value : false
Table 25 Operation Table (continued)
41Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
IPEchoOper Table
The IPEchoOper table details is explained in Table 26
Table 26 IPEchoOper Table
Column Name Type Constraints Description
OperationID Bigint Not Null Reference to operation(ID)
DataReqSize Integer Not Null See MIB object:
rttMonEchoAdminPktDataRequestSize
MIB type:
Integer32(0..16384)
Default Value:
{1}
Number of octets to include in the request data.
TypeOfService Integer Not Null See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
42Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
UDPEchoOper Table
The UDPEchoOper table is given in Table 27.
Table 27 UDPEchoOper Table
Column Name Type Constraints Description
OperationID Bigint Not Null Reference to operation(ID)
TypeOfService Integer Not Null See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
ReqPayload Integer Not Null See MIB object
rttMonEchoAdminPktDataRequestSize
MIB type
Integer32(0..16384)
Default Value
{1}
Number of OCTETS to include in the request data.
TargetPort Integer Not Null See MIB object:
rttMonEchoAdminTargetPort
MIB type:
Integer32(0..65536)
Default Value:
{0}
The target’s port number.
43Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
PathEchoOper Table
The PathEchoOper table is given in Table 28.
Table 28 PathEchoOper Table
Column Name Type Constraints Description
OperationID Bigint Not Null Reference to operation(ID)
TypeOfService Integer Null See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
DataReqSize Integer Null See MIB object:
rttMonEchoAdminPktDataRequestSize
MIB type:
Integer32(0..16384)
Default Value:
{1}
Number of OCTETS to include in the request data
MaximumPaths Integer Null See MIB object:
rttMonStatisticsAdminNumPaths
MIB type:
Integer32(1..128)
Default Value:
{ 5 }
Maximum number of statistics route buckets to keep
44Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
jitter_oper Table
The jitter_oper table is given in Table 29.
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
Table 28 PathEchoOper Table (continued)
Column Name Type Constraints Description
Table 29 jitter_oper Table
Column Name Type Constraints Description
OperationID Bigint Not Null Reference to operation(ID)
sampleinterval Bigint Not Null Unused
TypeofService Integer Null See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
reqPayload Integer Null See MIB object:
rttMonEchoAdminCodecPayload
MIB type:
Integer32
45Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
trgtPort Integer Null See MIB object:
rttMonEchoAdminTargetPort
MIB type:
Integer32(0..65536)
Default Value:
{0}
The target’s port number.
numpacket Integer Null See MIB object:
rttMonEchoAdminNumPackets
MIB type:
Integer32
Default Value:
{10}
Number of packets that need to be transmitted
pktInterval Integer Null See MIB object:
rttMonEchoAdminInterval
MIB type:
Integer32(0..60000)
Default Value:
{20}
The inter-packet delay. This is in milliseconds
respStatusOfTarget Integer Null Statistics of the target
codecType Integer Null See MIB object:
rttMonEchoAdminCodecType
MIB type: Integer32
icpifAdvFactor Integer Null See MIB object:
rttMonEchoAdminICPIFAdvFactor
MIB type: Integer32
Table 29 jitter_oper Table (continued)
Column Name Type Constraints Description
46Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
ICMPJitterOper Table
The ICMPJitterOper table is given in Table 30.
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
Table 29 jitter_oper Table (continued)
Column Name Type Constraints Description
Table 30 ICMPJitterOper Table
Column Name Type Constraints Description
OperationID Bigint UNIQUE Reference to operation(ID)
TypeOfService Integer Not Null See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
ReqPayload Integer Not Null Unused
47Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
RTPOper Table
The RTP Sub Operation table is given in Table 31.
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
Table 30 ICMPJitterOper Table (continued)
Column Name Type Constraints Description
Table 31 RTPOper Table
Column Name Type Constraints Description
OperationID Bigint UNIQUE Reference to operation(ID)
SourceIP Varchar(127) Null Source IP
SourceVoicePort Varchar(127) Null See MIB object:
rttMonEchoAdminSourceVoicePort
MIB type: Octets
CodecType smallint Null See MIB object:
rttMonEchoAdminCodecType
MIB type: Integer32
CallDuration Integer Null See MIB object:
rttMonEchoAdminCallDuration
MIB type: Integer32
AdvantageFactor Integer Null Advantage Factor range from 0 to 20
48Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
ethernet_oper Table
The Ethernet Sub Operation table is given in Table 32.
Table 32 ethernet_oper Table
Column Name Type Constraints Description
OperationID Bigint UNIQUE Reference to operation(ID)
vlanID Integer Not Null See MIB object:
• ethernetPing - rttMonEchoAdminTargetVLAN
• ethernetJitter – rttMonEchoAdminTargetVLAN
• ethernetPingAutoIPSLA – ipslaEthernetGrpCtrlVLAN
• ethernetJitterAutoIPSLA - ipslaEthernetGrpCtrlVLAN
domainName Varchar(255) Not Null See MIB object:
• ethernetPing – rttMonEchoAdminTargetDomainName
• ethernetJitter – rttMonEchoAdminTargetDomainName
• ethernetPingAutoIPSLA – ipslaEthernetGrpCtrlDomainName
• ethernetJitterAutoIPSLA - ipslaEthernetGrpCtrlDomainName
mepIDs Varchar(8192) Null See MIB object:
rttMonEchoAdminTargetMPID
exMepIDs Varchar(8192) Null See MIB object:
ipslaEthernetGrpCtrlMPIDExLst
classOfService Integer Null See MIB object:
• ethernetPing – rttMonEchoAdminEthernetCOS
• ethernetJitter – rttMonEchoAdminEthernetCOS
• ethernetPingAutoIPSLA – ipslaEthernetGrpCtrlCOS
• ethernetJitterAutoIPSLA - ipslaEthernetGrpCtrlCOS
49Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
http_oper Table
The HTTP Operation table is given in Table 33.
packetReqSize Integer Null See MIB object:
• ethernetPing,ethernetJitter – rttMonEchoAdminPktDataRequestSize
• ethernetPingAutoIPSLA, ethernetJitterAutoIPSLA - ipslaEthernetGrpCtrlReqDataSize
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
Table 32 ethernet_oper Table (continued)
Column Name Type Constraints Description
Table 33 http_oper Table
Column Name Type Constraints Description
OperationID Bigint Not Null Reference to operation(ID)
Port Integer Null Target Port No
See MIB object
rttMonEchoAdminTargetPort
MIB type Integer32
DefaultValue:80
URLRelativePath Varchar(127) Null See MIB object:
rttMonEchoAdminURL
MIB type:
DisplayString
Default Value:
{““}
String that represents the URL to which an HTTP probe should communicate.
50Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
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.
Table 33 http_oper Table (continued)
51Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
dns_oper Table
The DNS Operation table is given in Table 34.
ftp_oper Table
The FTP Operation table is given in Table 35.
Table 34 dns_oper Table
Column Name Type Constraints Description
OperationID Bigint Not Null Reference to operation(ID)
targetaddr Varchar(127) Null Unused
nameserver Varchar(127) Null See MIB object:
rttMonEchoAdminNameServer
MIB type:
RttMonTargetAddress
Default Value:
{““}
The IP Address of the nameserver
namesvraddr Varchar(127) Null IP Address of nameserver
Table 35 ftp_oper Table
Column Name Type Constraints Description
OperationID Bigint Not Null Reference to operation(ID)
TypeOfService Integer Null See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
FTPMode Integer Null rttMonAdminMode
Set to active or passive FTP mode
UserName Varchar(127) Null The username for FTP that enables you to access the FTP server.
52Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
dhcp_oper Table
The DHCP Operation table is given in Table 36
DLSwOper Table
The DLSw Operation Table is given in Table 37
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
Table 35 ftp_oper Table (continued)
Table 36 dhcp_oper Table
Column Name Type Constraints Description
OperationID Bigint Not Null Reference to operation(ID)
targetaddr Varchar(127) Null See MIB object:
rttMonEchoAdminTargetAddress
MIB type:
RttMonTargetAddress
Default Value:
{““}
The address of the target
targetipaddr Varchar(127) Null IP Address of the DHCP server
Table 37 DLSwOper Table
Column Name Type Constraints Description
OperationID Bigint Not Null Reference to operation(ID)
ReqPayload Varchar(127) Null See MIB object:
rttMonEchoAdminCodecPayload
MIB type:
Integer32
ResponsePayload Varchar(127) Null unused
53Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
PostDialDelayOper Table
The Post Dial Delay Operation table is given in Table 38.
tcpconnect_oper Table
The TcpConnect Operation table is given in Table 39
Table 38 PostDialDelayOper Table
Column Name Type Constraints Description
OperationID Bigint Not Null Reference to operation(ID)
PhoneNumber Varchar(127) Null Phone number
DetectPoint Integer Null See MIB object
rttMonEchoAdminDetectPoint
Default value : 1: voipDTAlertRinging (name)
Table 39 tcpconnect_oper Table
Column Name Type Constraints Description
OperationID Bigint Not Null Reference to operation(ID)
TargetPort Integer Null See MIB object:
rttMonEchoAdminTargetPort
MIB type:
Integer32(0..65536)
Default Value:
{0}
The target’s port number.
ControlEnable Smallint Null See MIB object:
rttMonEchoAdminControlEnable
MIB type:
TruthValue
Default Value:
{true}
If enabled, the RTR application will send control messages to a responder, in the target router.
This will respond to the data request packets being sent by the source router.
54Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
React Table
The React table is given in Table 40.
TypeOfService Integer Null See MIB object:
rttMonEchoAdminTOS
MIB type:
Integer32(0..255)
Default Value:
{0}
The type of service octet in an IP header
Table 39 tcpconnect_oper Table (continued)
Column Name Type Constraints Description
Table 40 ReactTable
Column Name Type Constraints Description
OperationID Bigint Unique identifier,
primarykey
Reference to Operation (ID).
reactvar Integer Not Null React variable
See MIB object:
rttMonReactVar
reactID Integer Not Null React ID
See MIB object:
rttMonReactVar
RisingThresh Integer Null Rising threshold value
See MIB object:
rttMonReactThresholdRising
FallingThresh Integer Null Falling threshold value
See MIB object:
rttMonReactThresholdFalling.
If this new MIB is not supported the following MIB will be used:
rttMonReactAdminThresholdFalling
55Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
XthreshCount Integer Null X threshold count
See MIB object:
rttMonReactThresholdCountX .
If this new MIB is not supported the following MIB will be used:
rttMonReactAdminThresholdCount
YthreshCount Integer Null Y threshold count
See MIB object:
rttMonReactThresholdCountY
If this new MIB is not supported the following MIB will be used:
rttMonReactAdminThresholdCount2
ThreshType Integer Null Threshold type
See MIB object:
:rttMonReactThresholdType
If the new MIB is not used the following MIB will be used:
:rttMonReactAdminThresholdType
ActionType Integer Null Action type
See MIB object:
rttMonReactActionType
If the new MIB is not supported, the following MIB will be used.
:rttMonReactAdminActionType
Table 40 ReactTable (continued)
Column Name Type Constraints Description
56Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Collector Table
The Collector table is given in Table 41.
Table 41 Collector Table
Column Name Type Constraints Description
ID Bigint IDENTITY,
Primary key
Unique identifier for collector
Name Varchar(255) Null Collector Name
descr Varchar(255) Null Description
SourceID Varchar(50) Null Source.
Reference to source(ID)
SourceIntAddr Varchar(50) Null Source interface address
TargetID Varchar(50) Null Target.
Reference to target(ID)
OperationID Varchar(50) Null Operation.
Reference to operation (ID)
ScheduleID bigint Null ScheduleID of the collector
Reference to the Collector Schedule (ID).
Owner Varchar(255) Null Owner
57Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Status Integer Null Current Statistics of the collector
1=Running
2=Completed
3=Dormant
4=Suspended
5=Cancelled
6=Config failed
7=Scheduled
8=Delete pending
10=Config pending
11=Update pending
12=Resume pending
13=Suspend pending
14=Cancel pending
15=Reconfig pending
16=Source not responding
17=Complete pending
18=Dormant pending
19=End point missing
PreviousStatus Integer Null Previous Statistics of the collector
StatusInfo Varchar(255) Null Statistics information of the collector
AdminIndex Integer Null Entry number assigned for this collector in the SAA agent
Tag Varchar(255) Null Name of the collector to be sent to device (limited to 15 characters)
OpType Integer Null Operation type for this collector.
This information is duplicated in the Type column in the Operation table.
Table 41 Collector Table (continued)
Column Name Type Constraints Description
58Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
User Stopped Collector Table
The User Stopped Collector table is given in Table 42
CollectorType Integer Null Collector type:
2 = Monitored.
1 = Statistical. Historical statistical data will be collected and saved in the database.
PollInterval bigint Null Polling interval
OpName Varchar(255) Null Operation name
SourceAddress Varchar(50) Null IP Address or HostName of source device from DCR_device_detail of CMF table.
TargetAddress Varchar(50) Null IP Address or Host Name of the target device from DCR_device_detail of CMF table.
AutoIPSLAParent
bigint Not Null Associated Parent Collector ID
IsToBeReconfigured
smallint Not Null Flag that indicates whether to configure the collector or not.
VrfName varchar(255) Not null Vrf Name for the collector
LastModified timestamp Not null Time at which the collector was last modified
Table 41 Collector Table (continued)
Column Name Type Constraints Description
Table 42 User Stopped Collector Table
Column Name Type Constraints Description
deviceid bigint Null Source.
CollectorID Bigint IDENTITY,
Primary key
Unique identifier for collector
59Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
VrfList Table
The VRF List table is given in Table 43.
outage_details Table
The Outage Details table is given Table 44.
Table 43 VrfList Table
Column Name Type Constraints Description
deviceid bigint Composite primary key.
Not null
Source device ID
vrfName Varchar(255) Composite primary key.
Not null
VRF name of the source device
Table 44 outage_details Table
Column Name Type Contraints Description
outage_id integer Not null Outage ID
start_date biginit Not null Start date of the outage
start_time timestamp Not null The time when the outage is scheduled to begin
end_date biginit Not null End date of the outage
end_time timestamp Not null The time when the outage is schedule to end
rec_type varchar(32) Not null The type of recurrence such as once, weekly, monthly
rec_on smallinit Not null The day when the outage re-occurs.
For example, if you want the outage to occur again for all days of a week, select all the days in a week.
outage_name varchar (255) Not null Name of the outage
description varchar (255) Not null The details of the outage
flag bit
60Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
completed_outages Table
The Completed Outages table is given in Table 45
Collector _Schedule Table
The Collector Schedule table is given in Table 46
Table 45 completed_outages Table
Column Type Constraints Description
Outage Id Integer Not null Outage ID
Collector Id biginit Not null Collector IDof the outage
Start Date Time timestamp Not null Start date and time for the outage period
EndDate Time timestamp Not null End date and time for the outage period
Table 46 Collector_Schedule Table
Column Name Type Constraints Description
ID bigint IDENTITY,
primary key
Unique identifier for collector
Reference to Collector (ID).
scheduleType Integer Null Schedule type
startDate bigint Null Start date of the collector.
The BIGINT value stored, is the number of milliseconds since January 1, 1970, 00:00:00 GM
startTime Timestamp Null Start time of the collector
endDate bigint Null End date
The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM
endTime Timestamp Null End time
daysOfWeek Integer Null Days of week for polling
suspendedTimestamp bigint Null Suspended time period
The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM
resumeTimestamp bigint Null Resume time period
The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM
61Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Latency_Minute_Stats Table
The Latency Minute Statistics table in given in Table 47.
Availability_Latency_Hourly_Stats Table
The Availability Latency Hourly Statistics table is given in Table 48.
Table 47 Latency_Minute_Stats Table
Column Name Type Constraints Description
RowID Bigint IDENTITY,
Primary key
Unique identifier
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID)
StartTime Timestamp Not Null Start time of the latest RTT operation
Latency_RTT Integer Not Null See MIB object:
rttMonLatestRttOperTim.
The value of the agent system time at the time of the latest RTT operation.
Table 48 Availability_Latency_Hourly_Stats Table
Column Name Type Constraints Description
RowID Bigint IDENTITY,
Primary key
Unique identifier
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID)
StartTime Timestamp Not Null Start time of this hourly bucket
MinRTT Integer Not Null See MIB object:
rttMonStatsCaptureCompletion-
TimeMin
MIB type:
Gauge32
Minimum RTT
62Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
MaxRTT Integer Not Null Maximum of RTT.
See MIB object:
rttMonStatsCaptureCompletion
TimeMax
MIB type:
Gauge32
Maximum RTT
SumRTT Integer Not Null See MIB object:
rttMonStatsCaptureSumCompletionTime
MIB type:
Gauge32
Accumulated RTTs
SumSqrdRTT Integer Not Null Sum square of all RTT
See MIB object:
rttMonStatsCaptureSumCompletionTime2Low, rttMonStatsCaptureSumCompletionTime2HighionTime2High
Accumulated RTT Squares
NumCompletions Integer Not Null See MIB object:
rttMonStatsCaptureCompletionsMIB type:
Integer32(0..2147483647)
Number of RTTs completed
NumOverThresholds Integer Not Null Number of overthresholds.
See MIB object:
rttMonStatsCaptureOverThresholds
MIB type:
Integer32(0..2147483647)
Number of OverThresholds
Table 48 Availability_Latency_Hourly_Stats Table (continued)
Column Name Type Constraints Description
63Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
NumDisconnects Integer Not Null Number of Disconnects.
See MIB object:
rttMonStatsCollectNumDisconnects
MIB type:
Integer32(0..2147483647)
NumTimeouts Integer Not Null Number of Timeouts
See MIB object:
rttMonStatsCollectTimeout
MIB type:
Integer32(0..2147483647)
NumBusies Integer Not Null Number of busies
See MIB object:
rttMonStatsCollectBusies
MIB type:
Integer32(0..2147483647)
Number of Busies
NumNoConnections Integer Not Null See MIB object:
rttMonStatsCollectNoConnections
MIB type:
Integer32(0..2147483647)
Number of Connections
NumDrops Integer Not Null Number of drops.
See MIB object:
rttMonStatsCollectDrops
MIB type:
Integer32(0..2147483647)
Number of RTT Dropped
NumSeqErrors Integer Not Null See MIB object:
rttMonStatscollectSequenceErrors
MIB type:
Integer32(0..2147483647)
Number of Sequence Errors
Table 48 Availability_Latency_Hourly_Stats Table (continued)
Column Name Type Constraints Description
64Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Availability_Latency_Daily_Stats Table
All the column values other than the Collector ID and Start Time are average values from the hourly table. See Table 49.
NumVerifyErrors Integer Not Null See MIB object:
rttMonStatsCollectVerifyErrors
MIB type:
Integer32(0..2147483647)
Number of Verify Errors
NumTries Integer Not Null Number of tries
AvgRTT Numeric(30) Not Null Average of RTT
StandardDeviation Numeric(30) Not Null StandardDeviation
OverThres_Percent Numeric(30) Not Nul Over threshold percentage
Error_Percent Numeric(30) Not Nul Error percentage
Availability_Percent Numeric(30) Not Nul Availability Percent
Table 48 Availability_Latency_Hourly_Stats Table (continued)
Column Name Type Constraints Description
Table 49 Availability_Latency_Daily_Stats Table
Column Name Type Constraints Description
CollectorID Bigint IDENTITY,
Primary key
Collector (Running Instance) ID.
Reference to collector(ID)
Start Time date Not Null Start time of the day
MinRTT Timestamp Not Null Average of all MinRTT.
MaxRTT Bigint IDENTITY,
Primary key
Average of all MaxRTT
SumRTT Bigint Not Null Sum of all RTT
SumSqrdRTT Integer Not Null Sum square of all RTT
NumCompletions Integer Not Null Number of completions.
NumOverThresholds Integer Not Null Number of over thresholds.
NumDisconnects Integer Not Null Number of disconnects
NumTimeouts Integer Not Null Number of Timeouts
NumBusies Integer Not Null Number of busies
NumNoConnections Integer Not Null Number of no connections.
NumDrops Integer Not Null Number of drops.
NumSeqErrors Integer Not Null Number of sequence errors
NumVerifyErrors Integer Not Null Number of verify errors
65Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Availability_Latency_Weekly_Stats Table
All the column values other than the collector ID and Start Time are average values from Daily table. See Table 50.
NumTries Integer Not Null Number of tries
AvgRTT Numeric(30) Not Null Average of RTT
StandardDeviation Numeric(30) Not Null StandardDeviation
OverThres_Percent Numeric(30) Not Null Over threshold percentage
Error_Percent Numeric(30) Not Null Error Percent
Availability_Percent Numeric(30) Not Null Availability Percent
Table 49 Availability_Latency_Daily_Stats Table (continued)
Column Name Type Constraints Description
Table 50 Availability_Latency_Weekly_Stats Table
Column Name Type Constraints Description
CollectorID Bigint IDENTITY,
Primary key
Collector (Running Instance) ID.
Reference to collector(ID)
starttime date Not Null Start time of the week.
MinRTT Timestamp Not Null Average of all MinRTT.
MaxRTT Bigint IDENTITY,
Primary key
Average of all MaxRTT.
SumRTT Bigint Not Null Sum of all RTT
SumSqrdRTT Integer Not Null Sum square of all RTT
NumCompletions Integer Not Null Number of completions.
NumOver
Thresholds
Integer Not Null Number of over thresholds.
NumDisconnects Integer Not Null Number of Disconnects.
NumTimeouts Integer Not Null Number of Timeouts
NumBusies Integer Not Null Number of busies.
NumNo
Connections
Integer Not Null Number of no connections.
NumDrops Integer Not Null Number of drops.
NumSeqErrors Integer Not Null Number of sequence errors
NumVerifyErrors Integer Not Null Number of VerifyErrors
NumTries Integer Not Null Number of tries
AvgRTT Numeric(30) Not Null Average of RTT
StandardDeviation Numeric(30) Not Null StandardDeviation
OverThres_Percent Numeric(30) Not Null Over threshold percentage
66Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Availability_Latency_Monthly_Stats Table
All the column values other than the collector ID and Start Time are average values from the weekly table. See Table 51.
Error_Percent Numeric(30) Not Null Error percentage
Availability_Percent Numeric(30) Not Null Availability Percent
Table 50 Availability_Latency_Weekly_Stats Table (continued)
Column Name Type Constraints Description
Table 51 Availability_Latency_Monthly_Stats Table
Column Name Type Constraints Description
CollectorID Bigint IDENTITY,
Primary key
Collector (Running Instance) ID.
Reference to collector(ID)
starttime date Not Null Start time of the month.
MinRTT Timestamp Not Null Average of all MinRTT.
MaxRTT Bigint IDENTITY,
Primary key
Average of all MaxRTT.
SumRTT Bigint Not Null Sum of all RTT
SumSqrdRTT Integer Not Null Sum square of all RTT
NumCompletions Integer Not Null Number of completions.
NumOver
Thresholds
Integer Not Null Number of over thresholds.
NumDisconnects Integer Not Null Number of Disconnects.
NumTimeouts Integer Not Null Number of Timeouts
NumBusies Integer Not Null Number of busies.
NumNo
Connections
Integer Not Null Number of no connections.
NumDrops Integer Not Null Number of drops.
NumSeqErrors Integer Not Null Number of sequence errors
NumVerifyErrors Integer Not Null See MIB object:
NumTries Integer Not Null Number of tries
AvgRTT Numeric(30) Not Null Average of RTT
StandardDeviation Numeric(30) Not Null StandardDeviation
OverThres_Percent Numeric(30) Not Null Over threshold percentage
Error_Percent Numeric(30) Not Null Error percentage
Availability_Percent Numeric(30) Not Null Availability Percent
67Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Jitter_Minute_Stats Table
The Jitter Minute Statistics table is given in Table 52.
Table 52 Jitter_Minute_Stats Table
Column Name Type Constraints Description
rowID Bigint Not Null Unique identifier
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID)
starttime Bigint Not Null Start time.
The BIGINT value stored is the number of milliseconds since January 1, 1970, 00:00:00 GM
MinRTT Integer Not Null See MIB object:
rttMonLatestJitterOperRTTMin
MIB type: Gauge (32 bit)
MaxRTT Integer Not Null See MIB object:
rttMonLatestJitterOperRTTMax
MIB type: Gauge (32 bit)
NumRTT Integer Not Null See MIB object:
rttMonLatestJitterOperNumOfRTT
MIB type: Gauge (32 bit)
SumRTT Integer Not Null See MIB object:
rttMonLatestJitterOperRTTSum
MIB type: Gauge (32 bit)
SumRTT2 Double Not Null See MIB object:
rttMonLatestJitterOperRTTSum2
MIB type: Gauge (32 bit)
minofposisd Integer Not Null See MIB object:
rttMonLatestJitterOperMin
Of PositivesSD
MIB type: Gauge (32 bit)
68Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
maxofposisd Integer Not Null See MIB object:
rttMonLatestJitterOperMaxOfPositivesDS
MIB type: Gauge (32 bit)
numofposisd Integer Not Null See MIB object:
rttMonLatestJitterOperNumOfPositivesSD
MIB type: Gauge (32 bit)
sumofposisd Integer Not Null See MIB object:
rttMonLatestJitterOperSumOfPositivesSD
MIB type: Gauge (32 bit)
sum2posisd Double Not Null See MIB object:
rttMonLatestJitterOperSum2PositivesSD
MIB type: Gauge (32 bit)
minofnegasd Integer Not Null See MIB object:
rttMonLatestJitterOperMinOfNegativesSD
MIB type: Gauge (32 bit)
maxofnegasd Integer Not Null See MIB object:
rttMonLatestJitterOperMaxOfNegativesSD
MIB type: Gauge (32 bit)
numofnegasd Integer Not Null See MIB object:
rttMonLatestJitterOperNumOfNegativesSD
MIB type: Gauge (32 bit)
sumofnegasd Integer Not Null See MIB object:
rttMonLatestJitterOperSumOfNegativesSD
MIB type: Gauge (32 bit)
sum2negasd Double Not Null See MIB object:
rttMonLatestJitterOperSum2NegativesSD
MIB type: Gauge (32 bit)
Table 52 Jitter_Minute_Stats Table (continued)
Column Name Type Constraints Description
69Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
minofposids Integer Not Null See MIB object:
rttMonLatestJitterOperMinOfPositivesDS
MIB type: : Gauge (32 bit)
maxofposids Integer Not Null See MIB object:
rttMonLatestJitterOperMaxOfPositivesDS
MIB type: : Gauge (32 bit)
numofposids Integer Not Null See MIB object:
rttMonLatestJitterOperNumOfPositivesDS
MIB type: : Gauge (32 bit)
sumofposids Integer Not Null See MIB object:
rttMonLatestJitterOperSumOfPositivesDS
MIB type: : Gauge (32 bit)
sum2posids Double Not Null See MIB object:
rttMonLatestJitterOperSum2PositivesDS
MIB type: : Gauge (32 bit)
minofnegads Integer Not Null See MIB object:
rttMonLatestJitterOperMinOfNegativesDS
MIB type: : Gauge (32 bit)
maxofnegads Integer Not Null See MIB object:
rttMonLatestJitterOperMaxOfNegativesDS
MIB type: : Gauge (32 bit)
numofnegads Integer Not Null See MIB object: rttMonLatestJitterOperNumOfNegativesDS
MIB type: : Gauge (32 bit)
sumofnegads Integer Not Null See MIB object: rttMonLatestJitterOperSumOfNegativesDS
MIB type: : Gauge (32 bit)
Table 52 Jitter_Minute_Stats Table (continued)
Column Name Type Constraints Description
70Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
sum2negads Double Not Null See MIB object: rttMonLatestJitterOperSum2NegativesDS
MIB type: : Gauge (32 bit)
numpacketlosssd Integer Not Null See MIB object: rttMonLatestJitterOperPacketLossSD
MIB type: : Gauge (32 bit)
numpacketlossds Integer Not Null See MIB object: rttMonLatestJitterOperPacketLossDS
MIB type: : Gauge (32 bit)
numpacketseqerr Integer Not Null See MIB object: rttMonLatestJitterOperPacketOutOfSequence
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: rttMonLatestJitterOperPacketLateArrival
MIB type: : Gauge (32 bit)
AvgRTT Numeric(30) Null Average of RTT
AvgPosSD Numeric(30) Null Average of positive from Source to Destination (SD)
StdDevPosSD Numeric(30) Null Standard deviation of positive SD
AvgNegSD Numeric(30) Null Average of negative SD
StdDevNegSD Numeric(30) Null Standard deviation of negative SD
AvgPosDS Numeric(30) Null Average of positive DS
StdDevPosDS Numeric(30) Null Standard deviation of positive DS
AvgNegDS Numeric(30) Null Average of negative DS
StdDevNegDS Numeric(30) Null Standard deviation of negative DS
StdDevRTT Numeric(30) Null Standard deviation of RTT
Table 52 Jitter_Minute_Stats Table (continued)
Column Name Type Constraints Description
71Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
mos Integer Not Null See MIB object: rttMonLatestJitterOperNumOfOW
MIB type: Gauge (32 bit)
icpif Integer Not Null See MIB object:
rttMonLatestJitterOperICPIF
MIB type: : Gauge (32 bit)
NumOfOW integer Not Null See MIB object: rttMonLatestJitterOperNumOfOW
MIB type: Gauge (32 bit)
SumOWSD integer Not Null See MIB object: rttMonLatestJitterOperOWSumSD
MIB type: Gauge (32 bit)
Sum2OWSD double Not Null See MIB object: rttMonLatestJitterOperOWSum2SD
MIB type: Gauge (32 bit)
StddevOWSD numeric(30,6) Null Standard deviation of one way latency SD
AvgOWSD numeric(30,6 Null Average of positive one way SD
MinOWSD integer Not Null See MIB object: rttMonLatestJitterOperOWMinSD
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonLatestJitterOperOWMaxSD
MIB type: Gauge (32 bit)
SumOWDS integer Not Null See MIB object: rttMonLatestJitterOperOWSumDS
MIB type: Gauge (32 bit)
Sum2OWDS double Not Null See MIB object: rttMonLatestJitterOperOWSum2DS
MIB type: Gauge (32 bit)
Table 52 Jitter_Minute_Stats Table (continued)
Column Name Type Constraints Description
72Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Jitter_Hourly_Stats Table
The Jitter Hourly Statistics table is given in Table 53.
Table 53 Jitter_Hourly_Stats Table
Column Name Type Constraints Description
rowID Bigint Not Null Unique identifier
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID)
starttime Timestamp Not Null Start time for this hourly bucket
MinRTT Integer Not Null See MIB object: rttMonJitterStatsRTTMin
MIB type: Gauge (32 bit)
MaxRTT Integer Not Null See MIB object: rttMonJitterStatsRTTMax
MIB type: Gauge (32 bit)
NumRTT Integer Not Null See MIB object: rttMonJitterStatsNumOfRTT
MIB type: Gauge (32 bit)
SumRTT Integer Not Null See MIB object: rttMonJitterStatsRTTSum
MIB type: Gauge (32 bit)
SumRTT2 Double Not Null See MIB object:
rttMonJitterStatsRTTSum2Low
and MIB object:
rttMonJitterStatsRTTSum2High
Accumulated RTT Squares
minofposids Integer Not Null Refer to MIB object:
rttMonJitterStatsMinOfPositivesSD
MIB type:
Gauge32
The minimum of absolute values
of all positive jitter values for
packets sent from destination to source.
73Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
maxofposisd Integer Not Null Refer to MIB object:
rttMonJitterStatsMaxOfPositivesSD
MIB type:
Gauge32
The maximum of absolute values of all positive jitter values of packets sent from destination to source.
numofposisd Integer Not Null Refer to MIB object:
rttMonJitterStatsNumOfPositivesSD
MIB type:
Gauge32
The sum of all positive jitter values from packets sent from destination to source.
sumofposisd Integer Not Null Refer to MIB object:
rttMonJitterStatsSumOfPositivesSD
MIB type:
Counter32
The sum of all positive jitter values
from packets sent from
destination to source.
sum2posisd Double Not Null Refer to MIB object:
rttMonJitterStatsSum2PositivesS
D2Low
and MIB object:
rttMonJitterStatsSum2PositivesS
D2High
The sum of square of RTT’s of
all positive jitter values from
packets sent from destination to source.
Table 53 Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
74Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
minofnegasd Integer Not Null Refer to MIB object:
rttMonJitterStatsMinOfNegativesSD
MIB type:
Gauge32
The minimum of absolute values
of all negative jitter values from
packets sent from destination to source.
maxofnegasd Integer Not Null Refer to MIB object:
rttMonJitterStatsMaxOfNegativesSD
MIB type:
Gauge32
The maximum of absolute values
of all negative jitter values of packets sent from destination to source.
numofnegasd Integer Not Null Refer to MIB object:
rttMonJitterStatsNumOfNegativesSD
MIB type:
Gauge32
The sum of number of all negative
jitter values from packets
sent from destination to source.
sumofnegasd Integer Not Null Refer to MIB object:
rttMonJitterStatsSumOfNegativesSD
MIB type:
Counter32
The sum of all negative jitter
values of packets sent from
source to destination
Table 53 Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
75Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
sum2negasd Double Not Null Refer to MIB object:
rttMonJitterStatsSum2Negatives
SD2Low
and MIB object:
rttMonJitterStatsSum2Negatives
SD2High
The sum of the squares of RTT’s of
all negative jitter values of packets sent from destination to source.
minofposids Integer Not Null Refer to MIB object:
rttMonJitterStatsMinOfPositivesDS
MIB type:
Gauge32
The minimum of absolute values of all positive jitter values of packets sent from destination to source.
maxofposids Integer Not Null Refer to MIB object:
rttMonJitterStatsMaxOfPositivesDS
MIB type:
Gauge32
The maximum of absolute values of all positive jitter values of packets sent from destination to source.
numofposids Integer Not Null Refer to MIB object:
rttMonJitterStatsNumOfPositivesDS
MIB type:
Gauge32
The sum of number of all positive jitter values from packets sent from destination to source.
sumofposids Integer Not Null Refer to MIB object:
rttMonJitterStatsSumOfPositivesDS
MIB type:
Counter32
The sum of all positive jitter values from packets sent from destination to source.
Table 53 Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
76Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
sum2posids Double Not Null Refer to MIB object:
rttMonJitterStatsSum2Positives
DS2Low
and MIB object:
rttMonJitterStatsSum2Positives
DS2High
The sum of square of RTTs of all positive jitter values for packets sent from destination to source.
minofnegads Integer Not Null Refer to MIB object:
rttMonJitterStatsMinOfNegativesDS
MIB type:
Gauge32
The minimum of absolute values of all negative jitter values for packets sent from source to destination
maxofnegads Integer Not Null Refer to MIB object:
rttMonJitterStatsMaxOfNegativesDS
MIB type:
Gauge32
The maximum of absolute values of all negative jitter values for packets sent from source to destination
numofnegads Integer Not Null Refer to MIB object:
rttMonJitterStatsNumOfNegativesDS
MIB type:
Gauge32
The sum of all negative jitter values for packets sent of destination to source.
sumofnegads Integer Not Null Refer to MIB object:
rttMonJitterStatsSumOfNegativesDS
MIB type:
Counter32
The sum of all negative jitter values for packets sent from destination to source
Table 53 Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
77Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
sum2negads Double Not Null Refer to MIB object:
rttMonJitterStatsSum2Negatives
DS2Low
and MIB object:
rttMonJitterStatsSum2Negatives
DS2High
The sum of the squares of RTTs of
all negative jitter values for packets sent from destination to source
numcomplete Integer Not Null Refer to MIB object:
rttMonJitterStatsCompletions
MIB type:
Counter32
Number of RTTs completed
numoverthresh Integer Not Null Refer to MIB object:
rttMonJitterStatsOverThresholds
MIB type:
Counter32
Number of OverThresholds
numpacketlossds Integer Not Null Refer to MIB object:
rttMonJitterStatsPacketLossSD
MIB type:
Counter32
The number of packets lost when
sent from destination to source.
numpacketlossds Integer Not Null Refer to MIB object:
rttMonJitterStatsPacketLossDS
MIB type:
Counter32
The number of packets lost when
sent from destination to source.
Table 53 Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
78Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
numpacketseqerr Integer Not Null Refer to MIB object:
rttMonJitterStatsPacketOutOf-
Sequence
MIB type:
Counter32
The number of packets thet arrived out of sequence
numpacketmia Integer Not Null Refer to MIB object:
rttMonJitterStatsPacketMIA
MIB type:
Counter32
The number of packets that are
lost for which we cannot determine
the direction
numpacketlate Integer Not Null Refer to MIB object:
rttMonJitterStatsPacketLateArrival
MIB type:
Counter32
The number of packets that
arrived after the timeout
NumJitterStatsErrors Integer Not Null Refer mib object : rttMonJitterStatsError
Mib type : Counter (32 bit)
numerror Integer Not Null Refer to MIB object:
rttMonJitterStatsError
MIB type:
Counter32
The number of occasions when a
jitter operation could not be initiated
because of an internal error
Table 53 Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
79Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
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
Table 53 Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
80Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Jitter_Daily_Stats Table
All the column values other than the Collector ID and Start Time are average values from the hourly table. See Table 54.
Table 54 Jitter_Daily_Stats Table
Column Name Type Constraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID)
starttime date Not Null Start time of the day
MinRTT Integer Not Null Average of all Min RTT
MaxRTT Integer Not Null Average of all Max RTT
NumRTT Integer Not Null Number of RTTs that are successfullymeasured
SumRTT Integer Not Null Accumulated RTTs
SumRTT2 Double Not Null Accumulated RTT Squares
minofposisd Integer Not Null Minimum of positive SD
maxofposisd Integer Not Null Maximum of positive SD
numofposisd Integer Not Null Number of positve SD
sumofposisd Integer Not Null Sum of positive SD
sum2posisd Double Not Null Sum squared of positive SD
minofnegasd Integer Not Null Minimum of negative SD
maxofnegasd Integer Not Null Maximum of negative SD
numofnegasd Integer Not Null Number of negative SD
sumofnegasd Integer Not Null Sum of negative SD
sum2negasd Double Not Null Sum squared of negative SD
minofposids Integer Not Null Minimum of positive DS
maxofposids Integer Not Null Maximum of positive DS
numofposids Integer Not Null Number of positive DS
sumofposids Integer Not Null Sum of positive DS
sum2posids Double Not Null Sum squared of positive DS
minofnegads Integer Not Null Minimum of nagative DS
maxofnegads Integer Not Null Maximum of negative DS
numofnegads Integer Not Null Number of negative DS
sumofnegads Integer Not Null Sum of negative DS
sum2negads Double Not Null Sum squared of negative DS
numcomplete Integer Not Null Number of completions
numoverthresh Integer Not Null Number of overthreshold
numpacketlosssd Integer Not Null Number of packet loss SD
81Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
numpacketlossds Integer Not Null Number of packet loss DS
numpacketseqerr Integer Not Null Number of error packets
numpacketmia Integer Not Null Number of packet MIA
numpacketlate Integer Not Null Number of late packets
NumJitterStatsErrors Integer Not Null Number of JitterStatsErrors
numerror Integer Not Null Numerror
numbusy Integer Not Null Numbusy
AvgRtt Numeric(30) Not Null Average RTT
Error_Percent Numeric(30) Not Null Error percentage
NumTries Integer Not Null Number of tries
AvgPosSD Numeric(30) Not Null Average of positive SD
StdDevPosSD Numeric(30) Not Null Standared deviation of positive SD
AvgNegSD Numeric(30) Not Null Average of negative SD
StdDevNegSD Numeric(30) Not Null Standared deviation of negative SD
AvgPosDS Numeric(30) Not Null Average of positive DS
StdDevPosDS Numeric(30) Not Null Standared deviation of positive DS
AvgNegDS Numeric(30) Not Null Average of negative DS
StdDevNegDS Numeric(30) Not Null Standared deviation of negative DS
PacketErrorPercent Numeric(30) Null PacketErrorPercent
OverThresholdPercent Numeric(30) Null OverThresholdPercent
StdDevRTT Numeric(30) Null Standared deviation of RTT
TotalPackets Integer Null TotalPackets
minmos Integer Not Null Min MOS
maxmos Integer Not Null Max MOS
minicpif Integer Not Null Min ICPIF
maxicpif Integer Not Null Max ICPIF
NumOfOW integer Not Null See MIB object: rttMonJitterStatsNumOfOW
MIB type: Gauge (32 bit)
SumOWSD integer Not Null See MIB object: rttMonJitterStatsOWSumSD
MIB type: Gauge (32 bit)
Sum2OWSD double Not Null See MIB object: rttMonJitterStatsOWSumSDHigh
MIB type: Gauge (32 bit)
StddevOWSD numeric(30,6) Null Standard deviation of one way latency SD
Table 54 Jitter_Daily_Stats Table (continued)
Column Name Type Constraints Description
82Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
AvgOWSD numeric(30,6 Null Average of positive one way SD
MinOWSD integer Not Null See MIB object: rttMonJitterStatsOWMinSDNew
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonJitterStatsOWMaxSDNew
MIB type: Gauge (32 bit)
SumOWDS integer Not Null See MIB object: rttMonJitterStatsOWSumDS
MIB type: Gauge (32 bit)
Sum2OWDS double Not Null See MIB object: rttMonJitterStatsOWSumDSHigh
MIB type: Gauge (32 bit)
StddevOWDS numeric(30,6) Null Standard deviation of one way latency DS
AvgOWDS numeric(30,6) Null Average of positive one way DS
MinOWDS integer Not Null See MIB object: rttMonJitterStatsOWMinDSNew
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonJitterStatsOWMinDSNew
MIB type: Gauge (32 bit)
See MIB object: rttMonJitterStatsOWMaxDSNew
MIB type: Gauge (32 bit)
Table 54 Jitter_Daily_Stats Table (continued)
Column Name Type Constraints Description
83Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Jitter_Weekly_Stats Table
All the column values other than the collector ID and Start Time are average values from Daily table. See Table 55..
Table 55 Jitter_Weekly_Stats Table
Column Name Type Constraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID)
starttime date Not Null Start time of the week
MinRTT Integer Not Null Average of all Min RTT
MaxRTT Integer Not Null Average of all Max RTT
NumRTT Integer Not Null Number of RTTs that are successfully measured
SumRTT Integer Not Null Accumulated RTTs
SumRTT2 Double Not Null Accumulated RTT Squares
minofposisd Integer Not Null Minimum of positive SD
maxofposisd Integer Not Null Maximum of positive SD
numofposisd Integer Not Null Number of positive SD
sumofposisd Integer Not Null Sum of positive SD
sum2posisd Double Not Null Sum squared of positive SD
minofnegasd Integer Not Null Minimum of negative SD
maxofnegasd Integer Not Null Maximum of negative SD
numofnegasd Integer Not Null Number of negative SD
sumofnegasd Integer Not Null Sum of negative SD
sum2negasd Double Not Null Sum squared of negative SD
minofposids Integer Not Null Minimum of positive DS
maxofposids Integer Not Null Maximum of positive DS
numofposids Integer Not Null Number of positive DS
sumofposids Integer Not Null Sum of positive DS
sum2posids Double Not Null Sum squared of positive DS
minofnegads Integer Not Null Minimum of negative DS
maxofnegads Integer Not Null Maximum of negative DS
numofnegads Integer Not Null Number of negative DS
sumofnegads Integer Not Null Sum of negative DS
sum2negads Double Not Null Sum squared of negative DS
numcomplete Integer Not Null Number of completions
numoverthresh Integer Not Null Number of overthreshold
numpacketlosssd Integer Not Null Number of packet loss SD
numpacketlossds Integer Not Null Number of packet loss DS
84Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
numpacketseqerr Integer Not Null Number of error packets
numpacketmia Integer Not Null Number of packet MIA
numpacketlate Integer Not Null Number of late packets
NumJitterStatsErrors Integer Not Null Number of JitterStatsErrors
numerror Integer Not Null Numerror
numbusy Integer Not Null Numbusy
AvgRtt Numeric(30) Not Null Average RTT
Error_Percent Numeric(30) Not Null Error percentage
NumTries Integer Not Null Number of tries
AvgPosSD Numeric(30) Not Null Average of positive SD
StdDevPosSD Numeric(30) Not Null Standard deviation of positive SD
AvgNegSD Numeric(30) Not Null Average of negative SD
StdDevNegSD Numeric(30) Not Null Standard deviation of negative SD
AvgPosDS Numeric(30) Not Null Average of positive DS
StdDevPosDS Numeric(30) Not Null Standard deviation of positive DS
AvgNegDS Numeric(30) Not Null Average of negative DS
StdDevNegDS Numeric(30) Not Null Standard deviation of negative DS
PacketErrorPercent Numeric(30) Null PacketErrorPercent
OverThresholdPercent Numeric(30) Null OverThresholdPercent
StdDevRTT Numeric(30) Null Standard deviation of RTT
TotalPackets Integer Null Total Packets
minmos Integer Not Null Minimum MOS
maxmos Integer Not Null Maximum MOS
minicpif Integer Not Null Minimum ICPIF
maxicpif Integer Not Null Maximum ICPIF
NumOfOW integer Not Null See MIB object: rttMonJitterStatsNumOfOW
MIB type: Gauge (32 bit)
SumOWSD integer Not Null See MIB object: rttMonJitterStatsOWSumSD
MIB type: Gauge (32 bit)
Sum2OWSD double Not Null See MIB object: rttMonJitterStatsOWSumSDHigh
MIB type: Gauge (32 bit)
StddevOWSD numeric(30,6) Null Standard deviation of one way latency SD
Table 55 Jitter_Weekly_Stats Table (continued)
Column Name Type Constraints Description
85Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
AvgOWSD numeric(30,6 Null Average of positive one way SD
MinOWSD integer Not Null See MIB object: rttMonJitterStatsOWMinSDNew
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonJitterStatsOWMaxSDNew
MIB type: Gauge (32 bit)
SumOWDS integer Not Null See MIB object: rttMonJitterStatsOWSumDS
MIB type: Gauge (32 bit)
Sum2OWDS double Not Null See MIB object: rttMonJitterStatsOWSumDSHigh
MIB type: Gauge (32 bit)
StddevOWDS numeric(30,6) Null Standard deviation of one way latency DS
AvgOWDS numeric(30,6) Null Average of positive one way DS
MinOWDS integer Not Null See MIB object: rttMonJitterStatsOWMinDSNew
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonJitterStatsOWMinDSNew
MIB type: Gauge (32 bit)
See MIB object: rttMonJitterStatsOWMaxDSNew
MIB type: Gauge (32 bit)
Table 55 Jitter_Weekly_Stats Table (continued)
Column Name Type Constraints Description
86Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Jitter_Monthly_Stats Table
All the column values other than the collector ID and Start Time are average values from the weekly table. See Table 56.
Table 56 Jitter_Monthly_Stats Table
Column Name Type Constraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector (ID)
starttime date Not Null Start time of the month
MinRTT Integer Not Null Average of all Min RTT
MaxRTT Integer Not Null Average of all Max RTT
NumRTT Integer Not Null Number of RTTs that are successfully
measured
SumRTT Integer Not Null Delay in the polling interval of collectors.
SumRTT2 Double Not Null Accumulated RTT Squares
minofposisd Integer Not Null Minimum of positive SD
maxofposisd Integer Not Null Maximum of positive SD
numofposisd Integer Not Null Number of positive SD
sumofposisd Integer Not Null Sum of positive SD
sum2posisd Double Not Null Sum squared of positive SD
minofnegasd Integer Not Null Minimum of negative SD
maxofnegasd Integer Not Null Maximum of negative SD
numofnegasd Integer Not Null Number of negative SD
sumofnegasd Integer Not Null Sum of negative SD
sum2negasd Double Not Null Sum squared of negative SD
minofposids Integer Not Null Minimum of positive DS
maxofposids Integer Not Null Maximum of positive DS
numofposids Integer Not Null Number of positive DS
sumofposids Integer Not Null Sum of positive DS
sum2posids Double Not Null Sum squared of positive DS
minofnegads Integer Not Null Minimum of negative DS
maxofnegads Integer Not Null Maximum of negative DS
numofnegads Integer Not Null Number of negative DS
sumofnegads Integer Not Null Sum of negative DS
sum2negads Double Not Null Sum squared of negative DS
numcomplete Integer Not Null Number of completions
87Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
numoverthresh Integer Not Null Number of overthreshold
numpacketlosssd Integer Not Null Number of packet loss SD
numpacketlossds Integer Not Null Number of packet loss DS
numpacketseqerr Integer Not Null Number of error packets
numpacketmia Integer Not Null Number of packet MIA
numpacketlate Integer Not Null Number of late packets
NumJitterStatsErrors Integer Not Null Number of JitterStatsErrors
numerror Integer Not Null Numerror
numbusy Integer Not Null Numbusy
AvgRtt Numeric(30) Not Null Average RTT
Error_Percent Numeric(30) Not Null Error percentage
NumTries Integer Not Null Number of tries
AvgPosSD Numeric(30) Not Null Average of positive SD
StdDevPosSD Numeric(30) Not Null Standard deviation of positive SD
AvgNegSD Numeric(30) Not Null Average of negative SD
StdDevNegSD Numeric(30) Not Null Standard deviation of negative SD
AvgPosDS Numeric(30) Not Null Average of positive DS
StdDevPosDS Numeric(30) Not Null Standard deviation of positive DS
AvgNegDS Numeric(30) Not Null Average of negative DS
StdDevNegDS Numeric(30) Not Null Standard deviation of negative DS
PacketErrorPercent Numeric(30) Null PacketErrorPercent
OverThresholdPercent Numeric(30) Null OverThresholdPercent
StdDevRTT Numeric(30) Null Standared deviation of RTT
TotalPackets Integer Null Total Packets
minmos Integer Not Null Min MOS
maxmos Integer Not Null Max MOS
minicpif Integer Not Null Min ICPIF
maxicpif Integer Not Null Max ICPIF
NumOfOW integer Not Null See MIB object: rttMonJitterStatsNumOfOW
MIB type: Gauge (32 bit)
SumOWSD integer Not Null See MIB object: rttMonJitterStatsOWSumSD
MIB type: Gauge (32 bit)
Table 56 Jitter_Monthly_Stats Table (continued)
Column Name Type Constraints Description
88Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Sum2OWSD double Not Null See MIB object: rttMonJitterStatsOWSumSDHigh
MIB type: Gauge (32 bit)
StddevOWSD numeric(30,6) Null Standard deviation of one way latency SD
AvgOWSD numeric(30,6 Null Average of positive one way SD
MinOWSD integer Not Null See MIB object: rttMonJitterStatsOWMinSDNew
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonJitterStatsOWMaxSDNew
MIB type: Gauge (32 bit)
SumOWDS integer Not Null See MIB object: rttMonJitterStatsOWSumDS
MIB type: Gauge (32 bit)
Sum2OWDS double Not Null See MIB object: rttMonJitterStatsOWSumDSHigh
MIB type: Gauge (32 bit)
StddevOWDS numeric(30,6) Null Standard deviation of one way latency DS
AvgOWDS numeric(30,6) Null Average of positive one way DS
MinOWDS integer Not Null See MIB object: rttMonJitterStatsOWMinDSNew
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonJitterStatsOWMinDSNew
MIB type: Gauge (32 bit)
See MIB object: rttMonJitterStatsOWMaxDSNew
MIB type: Gauge (32 bit)
Table 56 Jitter_Monthly_Stats Table (continued)
Column Name Type Constraints Description
89Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
ICMP_Jitter_Minute_Stats Table
The ICMP Jitter Minute Statistics table is given in Table 57.
Table 57 ICMP_Jitter_Minute_Stats Table
Column Name Type Constraints Description
rowID Bigint IDENTITY,
primary key
Unique identifier
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID)
starttime Timestamp Not Null Start time
MinRTT Integer Not Null See MIB object:
rttMonLatestIcmpJitterRTTMin
MIB type: Gauge (32 bit)
MaxRTT Integer Not Null See MIB object:
rttMonLatestIcmpJitterRTTMax
MIB type: Gauge (32 bit)
NumRTT Integer Not Null See MIB object:
rttMonLatestIcmpJitterNumRTT
MIB type: Gauge (32 bit)
SumRTT Integer Not Null See MIB object:
rttMonLatestIcmpJitterRTTSum
MIB type: Gauge (32 bit)
SumRTT2 Double Not Null See MIB object:
rttMonLatestIcmpJitterRTTSum2
MIB type: Gauge (32 bit)
minofposisd Integer Not Null See MIB object:
rttMonLatestIcmpJitterMinPosSD
MIB type: Gauge (32 bit)
maxofposisd Integer Not Null See MIB object:
rttMonLatestIcmpJitterMaxPosSD
MIB type: Gauge (32 bit)
numofposisd Integer Not Null See MIB object:
rttMonLatestIcmpJitterNumPosSD
MIB type: Gauge (32 bit)
sumofposisd Integer Not Null See MIB object:
rttMonLatestIcmpJitterSumPosSD
MIB type: Gauge (32 bit)
90Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
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)
Table 57 ICMP_Jitter_Minute_Stats Table (continued)
Column Name Type Constraints Description
91Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
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)
Table 57 ICMP_Jitter_Minute_Stats Table (continued)
Column Name Type Constraints Description
92Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
maxSuccPktLoss Integer Not Null See MIB object:
rttMonLatestIcmpJitterMaxSucPktL
MIB type: Gauge (32 bit)
AvgRTT Numeric(30,6) Null Average of RTT
AvgPosSD Numeric(30,6) Null Average of positive SD
StdDevPosSD Numeric(30,6) Null Standard deviation of positive SD
AvgNegSD Numeric(30,6) Null Average of negative SD
StdDevNegSD Numeric(30,6) Null Standard deviation of negative SD
AvgPosDS Numeric(30,6) Null Average of positive DS
StdDevPosDS Numeric(30,6) Null Standard deviation of positive DS
AvgNegDS Numeric(30,6) Null Average of negative DS
StdDevNegDS Numeric(30,6) Null Standard deviation of negative DS
StdDevRTT Numeric(30,6) Null Standard deviation of RTT
NumOfOW integer Not Null See MIB object: rttMonLatestJitterOperNumOfOW
MIB type: Gauge (32 bit)
SumOWSD integer Not Null See MIB object: rttMonLatestJitterOperNumOfOW
MIB type: Gauge (32 bit)
See MIB object: rttMonLatestIcmpJitterOWSumSD
MIB type: Gauge (32 bit)
Sum2OWSD double Not Null See MIB object: rttMonLatestIcmpJitterOWSum2SD
MIB type: Gauge (32 bit)
StddevOWSD numeric(30,6) Null Standard deviation of one way latency SD
AvgOWSD numeric(30,6 Null See MIB object: rttMonLatestIcmpJitterOWAvgSD
MinOWSD integer Not Null See MIB object: rttMonLatestIcmpJitterOWMinSD
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonLatestIcmpJitterOWMaxSD
MIB type: Gauge (32 bit)
SumOWDS integer Not Null See MIB object: rttMonLatestIcmpJitterOWSumDS
MIB type: Gauge (32 bit)
Table 57 ICMP_Jitter_Minute_Stats Table (continued)
Column Name Type Constraints Description
93Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
ICMP_Jitter_Hourly_Stats Table
The ICMP Jitter Hourly Statistics table is given in Table 58
Sum2OWDS double Not Null See MIB object: rttMonLatestIcmpJitterOWSum2DS
MIB type: Gauge (32 bit)
StddevOWDS numeric(30,6) Null Standard deviation of one way latency
AvgOWDS numeric(30,6) Null See MIB object: rttMonLatestIcmpJitterOWAvgDS
MinOWDS integer Not Null See MIB object: rttMonLatestIcmpJitterOWMinDS
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonLatestIcmpJitterOWMaxDS
MIB type: Gauge (32 bit)
Table 57 ICMP_Jitter_Minute_Stats Table (continued)
Column Name Type Constraints Description
Table 58 ICMP_Jitter_Hourly_Stats Table
Column Name Type Constraints Description
rowID Bigint IDENTITY,
primary key
Unique identifier
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID).
starttime Timestamp Not Null Start time of the hourly bucket
MinRTT Integer Not Null See MIB object:
rttMonIcmpJitterStatsRTTMin
MIB type: Gauge (32 bit)
MaxRTT Integer Not Null See MIB object:
rttMonIcmpJitterStatsRTTMax
MIB type: Gauge (32 bit)
NumRTT Integer Not Null See MIB object:
rttMonIcmpJitterStatsNumRTTs
MIB type: Gauge (32 bit)
SumRTT Integer Not Null See MIB object:
rttMonIcmpJitterStatsRTTSums
MIB type: Gauge (32 bit)
94Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
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:
rttMonIcmpJitterStatsNumPosSDs
MIB type: Gauge (32 bit)
sumofposisd Integer Not Null See MIB object:
rttMonIcmpJitterStatsSumPosSDs
MIB type: Gauge (32 bit)
sum2posisd Double Not Null See MIB object:
Sum2PosSDLows,rttMonIcmpJStatsSum2PosSDHighs.
The sum of the squares of RTTs of all positive jitter values for packets sent from source to destination
(Low and higher order 32 bits).
minofnegasd Integer Not Null See MIB object:
rttMonIcmpJitterStatsMinNegSD
MIB type: Gauge (32 bit)
maxofnegasd Integer Not Null See MIB object:
rttMonIcmpJitterStatsMaxNegSD
MIB type: Gauge (32 bit)
numofnegasd Integer Not Null See MIB object:
rttMonIcmpJitterStatsNumNegSDs
MIB type: Gauge (32 bit)
Table 58 ICMP_Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
95Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
sumofnegasd Integer Not Null See MIB object:
rttMonIcmpJitterStatsSumNegSDs
MIB type: Gauge (32 bit)
sum2negasd Double Not Null See MIB object:
rttMonIcmpJStatsSum2NegSDLows,rttMonIcmpJStatsSum2NegSDHighs.
The sum of the squares of RTTs of all negative jitter values for packets sent from source to destination.
(Low and higher order 32 bits
minofposids Integer Not Null See MIB object:
rttMonIcmpJitterStatsMinPosDS
MIB type: Gauge (32 bit)
maxofposids Integer Not Null See MIB object:
rttMonIcmpJitterStatsMaxPosDS
MIB type: Gauge (32 bit)
numofposids Integer Not Null See MIB object:
rttMonIcmpJitterStatsNumPosDSes
MIB type: Gauge (32 bit)
sumofposids Integer Not Null See MIB object:
rttMonIcmpJitterStatsSumPosDSes
MIB type: Gauge (32 bit)
sum2posids Double Not Null See MIB object:
minofnegads Integer Not Null See MIB object:
rttMonIcmpJitterStatsMinNegDS
MIB type: Gauge (32 bit)
maxofnegads Integer Not Null See MIB object:
rttMonIcmpJitterStatsMaxNegDS
MIB type: Gauge (32 bit)
numofnegads Integer Not Null See MIB object:
rttMonIcmpJitterStatsNumNegDSes
MIB type: Gauge (32 bit)
sumofnegads Integer Not Null See MIB object:
rttMonIcmpJitterStatsSumNegDSes
MIB type: Gauge (32 bit)
Table 58 ICMP_Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
96Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
sum2negads Double Not Null See MIB object:
rttMonIcmpJitterStatsSumNegDSes
MIB type: Gauge (32 bit)
numcomplete Integer Not Null See MIB object:
rttMonIcmpJitterStatsCompletions
MIB type: Counter (32 bit)
numoverthresh Integer Not Null See MIB object:
rttMonIcmpJStatsOverThresholds
MIB type: Counter (32 bit)
numPktLoss Integer Not Null See MIB object:
rttMonIcmpJitterStatsPktLosses
MIB type: Counter (32 bit)
numPktOutSeqBoth Integer Not Null See MIB object:
rttMonIcmpJStatsPktOutSeqBoth
MIB type: Counter (32 bit)
numPktOutSeqSDes Integer Not Null See MIB object:
rttMonIcmpJStatsPktOutSeqSDs
MIB type: Counter (32 bit)
numPktOutSeqDSes Integer Not Null See MIB object:
rttMonIcmpJStatsPktOutSeqDSes
MIB type: Counter (32 bit)
numPktSkippeds Integer Not Null See MIB object:
rttMonIcmpJitterStatsPktSkippeds
MIB type: Counter (32 bit)
numPktLateAs Integer Not Null See MIB object:
rttMonIcmpJitterStatsPktLateAs
MIB type: Counter (32 bit)
minSuccPktLoss Integer Not Null See MIB object:
rttMonIcmpJitterMinSucPktLoss
MIB type:gauge(32)
maxSuccPktLoss Integer Not Null See MIB object:
rttMonIcmpJitterMaxSucPktLoss
MIB type:gauge(32)
Table 58 ICMP_Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
97Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
numerror Integer Not Null See MIB object:
rttMonIcmpJitterStatsErrors
MIB type: Counter (32 bit)
numbusy Integer Not Null See MIB object:
rttMonIcmpJitterStatsBusies
MIB type: Counter (32 bit)
AvgRtt Numeric(30) Not Null Average RTT
Error_Percent Numeric(30) Not Null Error percentage
NumTries Integer Not Null Number of tries
AvgPosSD Numeric(30) Not Null Average positive SD
StdDevPosSD Numeric(30) Not Null Standard deviation positive SD
AvgNegSD Numeric(30) Not Null Average negative SD
StdDevNegSD Numeric(30) Not Null Standard deviation negative SD
AvgPosDS Numeric(30) Not Null Average of positive SD
StdDevPosDS Numeric(30) Not Null Standard deviation positive DS
AvgNegDS Numeric(30) Not Null Average negative DS
StdDevNegDS Numeric(30) Not Null Standard deviation negative DS
PacketErrorPercent Numeric(30) Null Packet error percentage
OverThresholdPercent Numeric(30) Null Over threshold percentage
StdDevRTT Numeric(30) Null Standard deviation RTT
TotalPackets Integer Null Total packets
NumOfOW integer Not Null See MIB object: rttMonIcmpJitterStatsNumOWs
MIB type: Gauge (32 bit)
SumOWSD integer Not Null See MIB object: rttMonIcmpJitterStatsOWSumSDs
MIB type: Gauge (32 bit)
Sum2OWSD double Not Null See MIB object: rttMonIcmpJStatsOWSum2SDHighs
MIB type: Gauge (32 bit)
StddevOWSD numeric(30,6) Null Standard deviation of one way latency SD
AvgOWSD numeric(30,6) Null Average of positive one way SD
MinOWSD integer Not Null See MIB object: rttMonIcmpJitterStatsOWMinSD
MIB type: Gauge (32 bit)
Table 58 ICMP_Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
98Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
ICMP_Jitter_Daily_Stats Table
All the column values other than the Collector ID and Start Time are average values from the hourly table. See Table 59.
MaxOWSD integer Not Null See MIB object: rttMonIcmpJitterStatsOWMaxSD
MIB type: Gauge (32 bit)
SumOWDS integer Not Null See MIB object: rttMonIcmpJitterStatsOWSumDSes
MIB type: Gauge (32 bit)
Sum2OWDS double Not Null See MIB object: rttMonIcmpJStatsOWSum2DSHighs
MIB type: Gauge (32 bit)
StddevOWDS numeric(30,6) Null Standard deviation of one way latency DS
AvgOWDS numeric(30,6) Null Average of positive one way DS
MinOWDS integer Not Null See MIB object: rttMonIcmpJitterStatsOWMinDS
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonIcmpJitterStatsOWMaxDS
MIB type: Gauge (32 bit)
Table 58 ICMP_Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
Table 59 ICMP_Jitter_Daily_Stats Table
Column Name Type Constraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID)
starttime date Not Null Start time of the day
MinRTT Integer Not Null Average of all MinRTT
MaxRTT Integer Not Null Average of all MaxRTT.
NumRTT Integer Not Null Number of total RTT
SumRTT Integer Not Null Sum of all RTT
SumRTT2 Double Not Null Sum of all RTT squares
minofposisd Integer Not Null Minimum of all positive SD
maxofposisd Integer Not Null Maximum of all positive SD
numofposisd Integer Not Null Number of all positive SD
sumofposisd Integer Not Null Sum of all positive SD
99Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
sum2posisd Double Not Null Sum of the squares of all positive SD square
minofnegasd Integer Not Null Minimum of all negative SD
maxofnegasd Integer Not Null Maximum of all negative SD
numofnegasd Integer Not Null Number of all negative SD
sumofnegasd Integer Not Null Sum of all negative SD
sum2negasd Double Not Null Sum of the squares of all negative SD
minofposids Integer Not Null Minimum of all positive DS
maxofposids Integer Not Null Maximum of all positive DS
numofposids Integer Not Null Number of all positive DS
sumofposids Integer Not Null Sum of all positive DS
sum2posids Double Not Null Sum of the squares of all positive DS
minofnegads Integer Not Null Minimum of all negative DS
maxofnegads Integer Not Null Maximum of all negative DS
numofnegads Integer Not Null Number of all negative DS
sumofnegads Integer Not Null Sum of all negative DS
sum2negads Double Not Null Sum of the squares of all negative DS
numcomplete Integer Not Null Number of total RTT completions
numoverthresh Integer Not Null Number of overthreshold
numPktLoss Integer Not Null Number of packet loss
numPktOutSeqBoth Integer Not Null Number of packet out sequence for both DS, SD
numPktOutSeqSDes Integer Not Null Number of packet out sequence for SD
numPktOutSeqDSes Integer Not Null Number of packet out sequence for DS
numPktSkippeds Integer Not Null Number of packets skipped
numPktLateAs Integer Not Null Number of late packets
minSuccPktLoss Integer Not Null Minimum of successful packet loss
maxSuccPktLoss Integer Not Null Maximum of successful packet loss
numerror Integer Not Null Number of errors
numbusy Integer Not Null Number of busies
AvgRtt Numeric(30) Not Null Average of all RTT
Error_Percent Numeric(30) Not Null Error percentage
NumTries Integer Not Null Number of all tries
AvgPosSD Numeric(30) Not Null Average of positive SD
StdDevPosSD Numeric(30) Not Null Standard deviation of positive SD
AvgNegSD Numeric(30) Not Null Average negative SD
StdDevNegSD Numeric(30) Not Null Standard deviation negative SD
Table 59 ICMP_Jitter_Daily_Stats Table (continued)
Column Name Type Constraints Description
100Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
AvgPosDS Numeric(30) Not Null Average of positive DS
StdDevPosDS Numeric(30) Not Null Standard deviation positive DS
AvgNegDS Numeric(30) Not Null Average negative DS
StdDevNegDS Numeric(30) Not Null Standard deviation negative DS
PacketErrorPercent Numeric(30) Null Packet error percentage
OverThresholdPercent
Numeric(30) Not Null Over threshold percentage
StdDevRTT Numeric(30) Not Null Standard deviation RTT
TotalPackets Integer Not Null Total packets
NumOfOW integer Not Null See MIB object: rttMonIcmpJitterStatsNumOWs
MIB type: Gauge (32 bit)
SumOWSD integer Not Null See MIB object: rttMonIcmpJitterStatsOWSumSDs
MIB type: Gauge (32 bit)
Sum2OWSD double Not Null See MIB object: rttMonIcmpJStatsOWSum2SDHighs
MIB type: Gauge (32 bit)
StddevOWSD numeric(30,6) Null Standard deviation of one way latency SD
AvgOWSD numeric(30,6 Null Average of positive one way SD
MinOWSD integer Not Null See MIB object: rttMonIcmpJitterStatsOWMinSD
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonIcmpJitterStatsOWMaxSD
MIB type: Gauge (32 bit)
SumOWDS integer Not Null See MIB object: rttMonIcmpJitterStatsOWSumDSes
MIB type: Gauge (32 bit)
Sum2OWDS double Not Null See MIB object: rttMonIcmpJStatsOWSum2DSHighs
MIB type: Gauge (32 bit)
StddevOWDS numeric(30,6) Null Standard deviation of one way latency DS
AvgOWDS numeric(30,6) Null Average of positive one way DS
Table 59 ICMP_Jitter_Daily_Stats Table (continued)
Column Name Type Constraints Description
101Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
ICMP_Jitter_Weekly_Stats Table
All the column values other than the collector ID and Start Time are average values from Daily table. See Table 60.
MinOWDS integer Not Null See MIB object: rttMonIcmpJitterStatsOWMinDS
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonIcmpJitterStatsOWMaxDS
MIB type: Gauge (32 bit)
Table 59 ICMP_Jitter_Daily_Stats Table (continued)
Column Name Type Constraints Description
Table 60 ICMP_Jitter_Weekly_Stats Table
Column Name Type Constraints Description
CollectorID BIGINT Not Null Collector (Running Instance) ID.
Reference to collector(ID)
starttime date Not Null Start time of the week.
MinRTT Integer Not Null Average of all MinRTT
MaxRTT Integer Not Null Average of all MaxRTT.
NumRTT Integer Not Null Number of total RTT
SumRTT Integer Not Null Sum of all RTT
SumRTT2 Double Not Null Sum of all RTT square
minofposisd Integer Not Null Minimum of all positive SD
maxofposisd Integer Not Null Maximum of all positive SD
numofposisd Integer Not Null Number of all positive SD
sumofposisd Integer Not Null Sum of all positive SD
sum2posisd Double Not Null Sum square of all positive SD square
minofnegasd Integer Not Null Minimum of all negative SD
maxofnegasd Integer Not Null Maximum of all negative SD
numofnegasd Integer Not Null Number of all negative SD
sumofnegasd Integer Not Null Sum of all negative SD
sum2negasd Double Not Null Sum square of all negative SD
minofposids Integer Not Null Minimum of all positive DS
maxofposids Integer Not Null Maximum of all positive DS
numofposids Integer Not Null Number of all positive DS
sumofposids Integer Not Null Sum of all positive DS
sum2posids Double Not Null Sum square of all positive DS
102Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
minofnegads Integer Not Null Minimum of all negative DS
maxofnegads Integer Not Null Maximum of all negative DS
numofnegads Integer Not Null Number of all negative DS
sumofnegads Integer Not Null Sum of all negative DS
sum2negads Double Not Null Sum square of all negative DS
numcomplete Integer Not Null Number of total RTT completions
numoverthresh Integer Not Null Number of overthreshold
numPktLoss Integer Not Null Number of packet loss
numPktOutSeqBoth Integer Not Null Number of packet out sequence for both DS, SD
numPktOutSeqSDes Integer Not Null Number of packet out sequence for SD
numPktOutSeqDSes Integer Not Null Number of packet out sequence for DS
numPktSkippeds Integer Not Null Number of packets skipped
numPktLateAs Integer Not Null Number of late packets
minSuccPktLoss Integer Not Null Minimum of successful packet loss
maxSuccPktLoss Integer Not Null Maximum of successful packet loss
numerror Integer Not Null Number of errors
numbusy Integer Not Null Number of busies
AvgRtt Numeric(30) Not Null Average of all RTT
Error_Percent Numeric(30) Not Null Error percentage
NumTries Integer Not Null Number of all tries
AvgPosSD Numeric(30) Not Null Average of positive SD
StdDevPosSD Numeric(30) Not Null Standard deviation of positive SD
AvgNegSD Numeric(30) Not Null Average negative SD
StdDevNegSD Numeric(30) Not Null Standard deviation negative SD
AvgPosDS Numeric(30) Not Null Average of positive DS
StdDevPosDS Numeric(30) Not Null Standard deviation of positive DS
AvgNegDS Numeric(30) Not Null Average negative DS
StdDevNegDS Numeric(30) Not Null Standard deviation negative DS
PacketErrorPercent Numeric(30) Null PacketErrorPercent
OverThresholdPercent Numeric(30) Null OverThresholdPercent
StdDevRTT Numeric(30) Null StdDevRTT
TotalPackets Integer Null TotalPackets
Table 60 ICMP_Jitter_Weekly_Stats Table (continued)
Column Name Type Constraints Description
103Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
ICMP_Jitter_Monthly_Stats Table
All the column values other than the collector ID and Start Time are average values from the weekly table. See Table 61.
NumOfOW integer Not Null See MIB object: rttMonIcmpJitterStatsNumOWs
MIB type: Gauge (32 bit)
SumOWSD integer Not Null See MIB object: rttMonIcmpJitterStatsOWSumSDs
MIB type: Gauge (32 bit)
Sum2OWSD double Not Null See MIB object: rttMonIcmpJStatsOWSum2SDHighs
MIB type: Gauge (32 bit)
StddevOWSD numeric(30,6) Null Standard deviation of one way latency SD
AvgOWSD numeric(30,6 Null Average of positive one way SD
MinOWSD integer Not Null See MIB object: rttMonIcmpJitterStatsOWMinSD
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonIcmpJitterStatsOWMaxSD
MIB type: Gauge (32 bit)
SumOWDS integer Not Null See MIB object: rttMonIcmpJitterStatsOWSumDSes
MIB type: Gauge (32 bit)
Sum2OWDS double Not Null See MIB object: rttMonIcmpJStatsOWSum2DSHighs
MIB type: Gauge (32 bit)
StddevOWDS numeric(30,6) Null Standard deviation of one way latency DS
AvgOWDS numeric(30,6) Null Average of positive one way DS
MinOWDS integer Not Null See MIB object: rttMonIcmpJitterStatsOWMinDS
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonIcmpJitterStatsOWMaxDS
MIB type: Gauge (32 bit)
Table 60 ICMP_Jitter_Weekly_Stats Table (continued)
Column Name Type Constraints Description
104Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Table 61 ICMP_Jitter_Monthly_Stats Table
Column Name Type Constraints Description
CollectorID BIGINT Not Null Collector (Running Instance) ID.
Reference to collector(ID)
starttime date Not Null Start time of the month
MinRTT Integer Not Null Average of all MinRTT
MaxRTT Integer Not Null Average of all MaxRTT.
NumRTT Integer Not Null Number of total RTT
SumRTT Integer Not Null Sum of all RTT
SumRTT2 Double Not Null Sum of all RTT square
minofposisd Integer Not Null Minimum of all positive SD
maxofposisd Integer Not Null Maximum of all positive SD
numofposisd Integer Not Null Number of all positive SD
sumofposisd Integer Not Null Sum of all positive SD
sum2posisd Double Not Null Sum square of all positive SD
minofnegasd Integer Not Null Minimum of all negative SD
maxofnegasd Integer Not Null Maximum of all negative SD
numofnegasd Integer Not Null Number of all negative SD
sumofnegasd Integer Not Null Sum of all negative SD
sum2negasd Double Not Null Sum square of all negative SD
minofposids Integer Not Null Minimum of all positive DS
maxofposids Integer Not Null Maximum of all positive DS
numofposids Integer Not Null Number of all positive DS
sumofposids Integer Not Null Sum of all positive DS
sum2posids Double Not Null Sum square of all positive DS
minofnegads Integer Not Null Minimum of all negative DS
maxofnegads Integer Not Null Maximum of all negative DS
numofnegads Integer Not Null Number of all negative DS
sumofnegads Integer Not Null Sum of all negative DS
sum2negads Double Not Null Sum square of all negative DS
numcomplete Integer Not Null Number of total RTT completions
numoverthresh Integer Not Null Number of overthreshold
numPktLoss Integer Not Null Number of packet loss
numPktOutSeqBoth Integer Not Null Number of packet out sequence for both DS, SD
numPktOutSeqSDes Integer Not Null Number of packet out sequence for SD
105Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
numPktOutSeqDSes Integer Not Null Number of packet out sequence for DS
numPktSkippeds Integer Not Null Number of packets skipped
numPktLateAs Integer Not Null Number of late packets
minSuccPktLoss Integer Not Null Minimum of successful packet loss
maxSuccPktLoss Integer Not Null Maximum of successful packet loss
numerror Integer Not Null Number of errors
numbusy Integer Not Null Number of busies
AvgRtt Numeric(30) Not Null Average of all RTT
Error_Percent Numeric(30) Not Null Error percentage
NumTries Integer Not Null Number of all tries
AvgPosSD Numeric(30) Not Null Average of positive SD
StdDevPosSD Numeric(30) Not Null Standard deviation of positive SD
AvgNegSD Numeric(30) Not Null Average negative SD
StdDevNegSD Numeric(30) Not Null Standard deviation negative SD
AvgPosDS Numeric(30) Not Null Average of positive DS
StdDevPosDS Numeric(30) Not Null Standard deviation of positive DS
AvgNegDS Numeric(30) Not Null Average negative DS
StdDevNegDS Numeric(30) Not Null Standard deviation negative DS
PacketErrorPercent Numeric(30) Null PacketErrorPercent
OverThresholdPercent Numeric(30) Null OverThresholdPercent
StdDevRTT Numeric(30) Null StdDevRTT
TotalPackets Integer Null TotalPackets
NumOfOW integer Not Null See MIB object: rttMonIcmpJitterStatsNumOWs
MIB type: Gauge (32 bit)
SumOWSD integer Not Null See MIB object: rttMonIcmpJitterStatsOWSumSDs
MIB type: Gauge (32 bit)
Sum2OWSD double Not Null See MIB object: rttMonIcmpJStatsOWSum2SDHighs
MIB type: Gauge (32 bit)
Table 61 ICMP_Jitter_Monthly_Stats Table (continued)
Column Name Type Constraints Description
106Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
StddevOWSD numeric(30,6) Null Standard deviation of one way latency SD
AvgOWSD numeric(30,6 Null Average of positive one way SD
MinOWSD integer Not Null See MIB object: rttMonIcmpJitterStatsOWMinSD
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonIcmpJitterStatsOWMaxSD
MIB type: Gauge (32 bit)
SumOWDS integer Not Null See MIB object: rttMonIcmpJitterStatsOWSumDSes
MIB type: Gauge (32 bit)
Sum2OWDS double Not Null See MIB object: rttMonIcmpJStatsOWSum2DSHighs
MIB type: Gauge (32 bit)
StddevOWDS numeric(30,6) Null Standard deviation of one way latency DS
AvgOWDS numeric(30,6) Null Average of positive one way DS
MinOWDS integer Not Null See MIB object: rttMonIcmpJitterStatsOWMinDS
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonIcmpJitterStatsOWMaxDS
MIB type: Gauge (32 bit)
Table 61 ICMP_Jitter_Monthly_Stats Table (continued)
Column Name Type Constraints Description
107Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Ethernet_Jitter_Minute_Stats Table
The Ethernet_Jitter_Minute_Stats table is given in Table 62.
Table 62 Ethernet Jitter Minute Statistics Table
Column Name Type Constraints Description
rowID Bigint IDENTITY, primary key
Identifier
CollectorID Bigint Not null Collector (Running Instance) ID
Reference to collector(ID)
starttime Timestamp Not null Start time
MinRTT Integer Not null See MIB object:
ipslaEtherJitterLatestRTTMin
MaxRTT Integer Not null See MIB object:
ipslaEtherJitterLatestRTTMax
NumRTT Integer Not null See MIB object:
ipslaEtherJitterLatestNumRTT
SumRTT Integer Not null See MIB object:
ipslaEtherJitterLatestRTTSum
SumRTT2 Double Not null See MIB object:
ipslaEtherJitterLatestRTTSum2
minofposisd Integer Not null See MIB object:
ipslaEtherJitterLatestMinPosSD
maxofposisd Integer Not null See MIB object:
ipslaEtherJitterLatestMaxPosSD
numofposisd Integer Not null See MIB object:
ipslaEtherJitterLatestNumPosSD
sumofposisd Integer Not null See MIB object:
ipslaEtherJitterLatestSumPosSD
sum2posisd Double Not null See MIB object:
ipslaEtherJitterLatestSum2PosSD
minofnegasd Integer Not null See MIB object:
ipslaEtherJitterLatestMinNegSD
maxofnegasd Integer Not null See MIB object:
ipslaEtherJitterLatestMaxNegSD
numofnegasd Integer Not null See MIB object:
ipslaEtherJitterLatestNumNegSD
sumofnegasd Integer Not null See MIB object:
ipslaEtherJitterLatestSumNegSD
108Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
sum2negasd Double Not null See MIB object:
ipslaEtherJitterLatestSum2NegSD
minofposids Integer Not null See MIB object:
ipslaEtherJitterLatestMinPosDS
maxofposids Integer Not null See MIB object:
ipslaEtherJitterLatestMaxPosDS
numofposids Integer Not null See MIB object:
ipslaEtherJitterLatestNumPosDS
sumofposids Integer Not null See MIB object:
ipslaEtherJitterLatestSumPosDS
sum2posids Double Not null See MIB object:
ipslaEtherJitterLatestSum2PosDS
minofnegads Double Not null See MIB object:
ipslaEtherJitterLatestMinNegDS
maxofnegads Double Not null See MIB object:
ipslaEtherJitterLatestMaxNegDS
numofnegads Double Not null See MIB object:
ipslaEtherJitterLatestNumNegDS
sumofnegads Double Not null See MIB object:
ipslaEtherJitterLatestSumNegDS
sum2negads Double Not null See MIB object:
ipslaEtherJitterLatestSum2NegDS
numframeLossSD Integer Not null See MIB object:
ipslaEtherJitterLatestFrmLossSD
numframeLossDS Integer Not null See MIB object:
ipslaEtherJitterLatestFrmLossDS
minSuccframeLoss Integer Not null See MIB object:
ipslaEtherJitterLatestMinSucFrmL
maxSuccframeLoss Integer Not null See MIB object:
ipslaEtherJitterLatestMaxSucFrmL
IAJitterOut Integer Null See MIB object:
ipslaEtherJitterLatestIAJOut
IAJitterIn Integer Null See MIB object:
ipslaEtherJitterLatestIAJIn
Table 62 Ethernet Jitter Minute Statistics Table (continued)
Column Name Type Constraints Description
109Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
numframeoutOfSeq Double Not Null See MIB object:
ipslaEtherJitterLatestFrmOutSeq
numframeSkips Integer Not Null See MIB object:
ipslaEtherJitterLatestFrmSkipped
numframeUnpro Integer Not Null See MIB object:
ipslaEtherJLatestFrmUnProcessed
numframelate Integer Not Null See MIB object:
ipslaEtherJitterLatestFrmLateA
numframemia Integer Not Null See MIB object:
ipslaEtherJitterLatestFrmMIA
AvgRTT Numeric(30,6) Null Average of RTT
AvgPosSD Numeric(30,6) Null Average of positive SD
StdDevPosSD Numeric(30,6) Null Standard deviation of positive SD
AvgNegSD Numeric(30,6) Null Average of negative SD
StdDevNegSD Numeric(30,6) Null Standard deviation of negative SD
AvgPosDS Numeric(30,6) Null Average of positive DS
StdDevPosDS Numeric(30,6) Null Standard deviation of positive DS
AvgNegDS Numeric(30,6) Null Average of negative DS
StdDevNegDS Numeric(30,6) Null Standard deviation of negative DS
StdDevRTT Numeric(30,6) Null Standard deviation of RTT
Table 62 Ethernet Jitter Minute Statistics Table (continued)
Column Name Type Constraints Description
110Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Ethernet_Jitter_Hourly_Stats Table
The Ethernet Jitter Hourly Statistics table is given in Table 63.
Table 63 Ethernet_Jitter_Hourly_Stats Table
Column Name Type Constraints Description
RowID Bigint IDENTITY,
primary key
Identifier
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID)
starttime Timestamp Not Null Start time of the hourly bucket
MinRTT Integer Not Null See MIB object:
ipslaEtherJAggMeasuredRTTMin
MaxRTT Integer Not Null See MIB object:
ipslaEtherJAggMeasuredRTTMax
NumRTT Integer Not Null See MIB object:
ipslaEtherJAggMeasuredNumRTTs
SumRTT Integer Not Null See MIB object:
ipslaEtherJAggMeasuredRTTSums
SumRTT2 Double Not Null Sum square of RTT
See MIB object:
ipslaEtherJAggMeasuredRTTSum2Ls, ipslaEtherJAggMeasuredRTTSum2Hs.
minofposisd Integer Not Null See MIB object:
ipslaEtherJAggMeasuredMinPosSD
maxofposisd Integer Not Null See MIB object:
ipslaEtherJAggMeasuredMaxPosSD
numofposisd Integer Not Null See MIB object:
ipslaEtherJAggMeasuredNumPosSDs
sumofposisd Integer Not Null See MIB object:
ipslaEtherJAggMeasuredSumPosSDs
sum2posisd Double Not Null Sum square of positive SD
See MIB object:
ipslaEtherJAggMeasuredSum2PSDLs, ipslaEtherJAggMeasuredSum2PSDHs
minofnegasd Integer Not Null See MIB object:
ipslaEtherJAggMeasuredMinNegSD
111Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
maxofnegasd Integer Not Null See MIB object:
ipslaEtherJAggMeasuredMaxNegSD
numofnegasd Integer Not Null See MIB object:
ipslaEtherJAggMeasuredNumNegSDs
sumofnegasd Integer Not Null See MIB object:
ipslaEtherJAggMeasuredSumNegSDs
sum2negasd Double Not Null Sum square of negative SD
See MIB object:
ipslaEtherJAggMeasuredSum2NSDLs, ipslaEtherJAggMeasuredSum2NSDHs
minofposids Integer Not Null See MIB object:
ipslaEtherJAggMeasuredMinPosDS
maxofposids Integer Not Null See MIB object:
ipslaEtherJAggMeasuredMaxPosDS
numofposids Integer Not Null See MIB object:
ipslaEtherJAggMeasuredNumPosDSes
sumofposids Integer Not Null See MIB object:
ipslaEtherJAggMeasuredSumPosDSes
sum2posids Double Not Null Sum square of positive DS
See MIB object:
ipslaEtherJAggMeasuredSum2PDSLs, ipslaEtherJAggMeasuredSum2PDSHs
minofnegads Integer Not Null See MIB object:
ipslaEtherJAggMeasuredMinNegDS
maxofnegads Integer Not Null See MIB object:
ipslaEtherJAggMeasuredMaxNegDS
numofnegads Integer Not Null See MIB object:
ipslaEtherJAggMeasuredNumNegDSes
sumofnegads Integer Not Null See MIB object:
ipslaEtherJAggMeasuredSumNegDSes
Table 63 Ethernet_Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
112Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
sum2negads Double Not Null Sum square of negative DS
See MIB object:
ipslaEtherJAggMeasuredSum2NDSLs, ipslaEtherJAggMeasuredSum2NDSLs
numcomplete Integer Not Null See MIB object:
ipslaEtherJAggMeasured
Cmpletions
numoverthresh Integer Not Null See MIB object:
ipslaEtherJAggMeasuredOvThrshlds
numframeLossSD Integer Not Null See MIB object:
ipslaEtherJAggMeasuredFrmLossSDs
numframeLossDS Integer Not Null See MIB object:
ipslaEtherJAggMeasuredFrmLssDSes
minSuccframeLoss Integer Not Null See MIB object:
ipslaEtherJAggMinSucFrmLoss
maxSuccframeLoss Integer Not Null See MIB object:
pslaEtherJAggMaxSucFrmLoss
IAJitterOut Integer Null See MIB object:
ipslaEtherJAggMeasuredIAJOut
IAJitterIn Integer Null See MIB object:
ipslaEtherJAggMeasuredIAJIn
numerror Integer Not Null See MIB object:
ipslaEtherJAggMeasuredErrors
numbusy Integer Not Null See MIB object:
ipslaEtherJAggMeasured
Busies
numframeoutOfSeq Double Not Null See MIB object:
ipslaEtherJAggMeasuredrmOutSeqs
numframeSkips Integer Not Null See MIB object:
ipslaEtherJAggMeasuredFrmSkippds
numframeUnpro Integer Not Null See MIB object:
ipslaEtherJAggMeasuredFrmUnPrcds
Table 63 Ethernet_Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
113Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Ethernet_Jitter_Daily_Stats Table
All the column values other than the Collector ID and Start Time are average values from the hourly table. Table 64.
numframelate Integer Not Null See MIB object:
ipslaEtherJAggMeasuredFrmLateAs
numframemia Integer Not Null See MIB object:
ipslaEtherJAggMeasuredFrmMIAes
AvgRtt Numeric(30,6) Not Null Average of RTT
Error_Percent Numeric(30,6) Not Null Error percentage
NumTries Integer Not Null Number of tries
AvgPosSD Numeric(30,6) Not Null Average of positive SD
StdDevPosSD Numeric(30,6) Not Null Standard deviation of positive SD
AvgNegSD Numeric(30,6) Not Null Average of negative SD
StdDevNegSD Numeric(30,6) Not Null Standard deviation of negative SD
AvgPosDS Numeric(30,6) Not Null Average of positive DS
StdDevPosDS Numeric(30,6) Not Null Standard deviation of positive DS
AvgNegDS Numeric(30,6) Not Null Average of negative DS
StdDevNegDS Numeric(30,6) Not Null Standard deviation of negative DS
PacketErrorPercent Numeric(30,6) Null Packet error percentage
OverThresholdPercent Numeric(30,6) Null Overthreshold percentage
StdDevRTT Numeric(30,6) Null Standard deviation of RTT
TotalPackets Integer Null Total packets
Table 63 Ethernet_Jitter_Hourly_Stats Table (continued)
Column Name Type Constraints Description
Table 64 Ethernet_Jitter_Daily_Stats Table
Column Name Type Constraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID)
starttime Timestamp Not Null Start time of the day
rttmin Integer Not Null Average of all MinRTT
rttmax Integer Not Null Average of all MaxRTT
numrtt Integer Not Null Number of RTT
sumrtt Integer Not Null Sum of RTT
sumrtt2 Double Not Null Sum of the squares of RTT
minofposisd Integer Not Null Minimum of positive SD
maxofposisd Integer Not Null Maximum of positive SD
114Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
numofposisd Integer Not Null Number of positive SD
sumofposisd Integer Not Null Sum of positive SD
sum2posisd Double Not Null Sum square of positive SD
minofnegasd Integer Not Null Minimum of negative SD
maxofnegasd Integer Not Null Maximum of negative SD
numofnegasd Integer Not Null Number of negative SD
sumofnegasd Integer Not Null Sum of negative SD
sum2negasd Double Not Null Sum square of negative SD
minofposids Integer Not Null Minimum of positive DS
maxofposids Integer Not Null Maximum of positive DS
numofposids Integer Not Null Number of positive DS
sumofposids Integer Not Null Sum of positive DS
sum2posids Double Not Null Sum square of positive DS
minofnegads Integer Not Null Minimum of negative DS
maxofnegads Integer Not Null Maximum of negative Ds
numofnegads Integer Not Null Number of negative DS
sumofnegads Integer Not Null Sum of negative DS
sum2negads Double Not Null Sum square of negative DS
numcomplete Integer Not Null Number of completions
numoverthresh Integer Not Null Number of over threshold
numframeLossSD Integer Not Null Number of frame loss SD
numframeLossDS Integer Not Null Number of frame loss DS
minSuccframeLoss Integer Not Null Minimum of successful frame loss
maxSuccframeLoss Integer Not Null Maximum of successful frame loss
IAJitterOut Integer Null IA jitter out
IAJitterIn Integer Null IA jitter In
numerror Integer Not Null Number of errors
numbusy Integer Not Null Number of busies
numframeoutOfSeq Double Not Null Number of frame out of sequence
numframeSkips Integer Not Null Number of frame skips
numframeUnpro Integer Not Null Number of unprocessed frames
numframelate Integer Not Null Number of late frames
numframemia Integer Not Null Number of frame MIA
AvgRtt Numeric(30,6) Not Null Average of RTT
Error_Percent Numeric(30,6) Not Null Error percentage
Table 64 Ethernet_Jitter_Daily_Stats Table (continued)
Column Name Type Constraints Description
115Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Ethernet_Jitter_Weekly_Stats Table
All the column values other than the collector ID and Start Time are average values from Daily table. See Table 65.
NumTries Integer Not Null Number of tries
AvgPosSD Numeric(30,6) Not Null Average of positive SD
StdDevPosSD Numeric(30,6) Not Null Standard deviation of positive SD
AvgNegSD Numeric(30,6) Not Null Average of negative SD
StdDevNegSD Numeric(30,6) Not Null Standard deviation of negative SD
AvgPosDS Numeric(30,6) Not Null Avergae of positve DS
StdDevPosDS Numeric(30,6) Not Null Standared deviation of positive DS
AvgNegDS Numeric(30,6) Not Null Average of negative DS
StdDevNegDS Numeric(30,6) Not Null Standard deviation of negative DS
PacketErrorPercent Numeric(30,6) Null Packet error percenatge
OverThresholdPercent Numeric(30,6) Null Overthershold percentage
StdDevRTT Numeric(30,6) Null Standard devaition of RTT
TotalPackets Integer Null Total packets
Table 64 Ethernet_Jitter_Daily_Stats Table (continued)
Column Name Type Constraints Description
Table 65 Ethernet_Jitter_Weekly_Stats Table
Column Name Type Constraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID)
starttime Timestamp Not Null Start time of the day
MinRTT Integer Not Null Average of all MinRTT
MaxRTT Integer Not Null Average of all MaxRTT
NumRTT Integer Not Null Number of RTT
SumRTT Integer Not Null Sum of RTT
SumRTT2 Double Not Null Sum of the square of RTT
minofposisd Integer Not Null Minimum of positive SD
maxofposisd Integer Not Null Maximum of positive SD
numofposisd Integer Not Null Number of positive SD
sumofposisd Integer Not Null Sum of positive SD
sum2posisd Double Not Null Sum square of positive SD
minofnegasd Integer Not Null Minimum of negative SD
maxofnegasd Integer Not Null Maximum of negative SD
numofnegasd Integer Not Null Number of negative SD
116Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
sumofnegasd Integer Not Null Sum of negative SD
sum2negasd Double Not Null Sum of the square of negative SD
minofposids Integer Not Null Minimum of positive DS
maxofposids Integer Not Null Maximum of positive DS
numofposids Integer Not Null Number of positive DS
sumofposids Integer Not Null Sum of positive DS
sum2posids Double Not Null Sum of the square of positive DS
minofnegads Integer Not Null Minimum of negative DS
maxofnegads Integer Not Null Maximum of negative Ds
numofnegads Integer Not Null Number of negative DS
sumofnegads Integer Not Null Sum of negative DS
sum2negads Double Not Null Sum of the square of negative DS
numcomplete Integer Not Null Number of completions
numoverthresh Integer Not Null Number of overthreshold
numframeLossSD Integer Not Null Number of frame loss SD
numframeLossDS Integer Not Null Number of frame loss DS
minSuccframeLoss Integer Not Null Minimum of successful frame loss
maxSuccframeLoss Integer Not Null Maximum of successful frame loss
IAJitterOut Integer Null IA jitter out
IAJitterIn Integer Null IA jitter In
numerror Integer Not Null Number of errors
numbusy Integer Not Null Number of busies
numframeoutOfSeq Double Not Null Number of frame out of sequence
numframeSkips Integer Not Null Number of frame skips
numframeUnpro Integer Not Null Number of frames un processed
numframelate Integer Not Null Number of late frames
numframemia Integer Not Null Number of frame MIA
AvgRtt Numeric(30,6) Not Null Average of RTT
Error_Percent Numeric(30,6) Not Null Error percentage
NumTries Integer Not Null Number of tries
AvgPosSD Numeric(30,6) Not Null Average of positive SD
StdDevPosSD Numeric(30,6) Not Null Standard deviation of positive SD
AvgNegSD Numeric(30,6) Not Null Average of negative SD
StdDevNegSD Numeric(30,6) Not Null Standard deviation of negative SD
AvgPosDS Numeric(30,6) Not Null Avergae of positve DS
StdDevPosDS Numeric(30,6) Not Null Standared deviation of positive DS
Table 65 Ethernet_Jitter_Weekly_Stats Table (continued)
Column Name Type Constraints Description
117Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Ethernet_Jitter_Monthly_Stats Table
All the column values other than the collector ID and Start Time are average values from the weekly table. See Table 66.
AvgNegDS Numeric(30,6) Not Null Average of negative DS
StdDevNegDS Numeric(30,6) Not Null Standard deviation of negative DS
PacketErrorPercent Numeric(30,6) Null Packet error percentage
OverThresholdPercent Numeric(30,6) Null Overthershold percentage
StdDevRTT Numeric(30,6) Null Standard deviation of RTT
TotalPackets Integer Null Total packets
Table 65 Ethernet_Jitter_Weekly_Stats Table (continued)
Column Name Type Constraints Description
Table 66 Ethernet_Jitter_Monthly_Stats Table
Column Name Type Constraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID.
Reference to collector(ID)
starttime Timestamp Not Null Start time of the month
MinRTT Integer Not Null Average of all MinRTT
MaxRTT Integer Not Null Average of all MaxRTT
NumRTT Integer Not Null Number of RTT
SumRTT Integer Not Null Sum of RTT
SumRTT2 Double Not Null Sum of the square of RTT
minofposisd Integer Not Null Minimum of positive SD
maxofposisd Integer Not Null Maximum of positive SD
numofposisd Integer Not Null Number of positive SD
sumofposisd Integer Not Null Sum of positive SD
sum2posisd Double Not Null Sum of the square of positive SD
minofnegasd Integer Not Null Minimum of negative SD
maxofnegasd Integer Not Null Maximum of negative SD
numofnegasd Integer Not Null Number of negative SD
sumofnegasd Integer Not Null Sum of negative SD
sum2negasd Double Not Null Sum of the square of negative SD
minofposids Integer Not Null Minimum of positive DS
maxofposids Integer Not Null Maximum of positive DS
numofposids Integer Not Null Number of positive DS
sumofposids Integer Not Null Sum of positive DS
sum2posids Double Not Null Sum of the square of positive DS
118Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
minofnegads Integer Not Null Minimum of negative DS
maxofnegads Integer Not Null Maximum of negative Ds
numofnegads Integer Not Null Number of negative DS
sumofnegads Integer Not Null Sum of negative DS
sum2negads Double Not Null Sum of the square of negative DS
numcomplete Integer Not Null Number of completions
numoverthresh Integer Not Null Number of over threshold
numframeLossSD Integer Not Null Number of frame loss SD
numframeLossDS Integer Not Null Number of frame loss DS
minSuccframeLoss Integer Not Null Minimum of successful frame loss
maxSuccframeLoss Integer Not Null Maximum of successful frame loss
IAJitterOut Integer Null IA jitter out
IAJitterIn Integer Null IA jitter In
numerror Integer Not Null Number of errors
numbusy Integer Not Null Number of busies
numframeoutOfSeq Double Not Null Number of frame out of sequence
numframeSkips Integer Not Null Number of frame skips
numframeUnpro Integer Not Null Number of frames un processed
numframelate Integer Not Null Number of late frames
numframemia Integer Not Null Number of frame MIA
AvgRtt Numeric(30,6) Not Null Average of RTT
Error_Percent Numeric(30,6) Not Null Error percentage
NumTries Integer Not Null Number of tries
AvgPosSD Numeric(30,6) Not Null Average of positive SD
StdDevPosSD Numeric(30,6) Not Null Standard deviation of positive SD
AvgNegSD Numeric(30,6) Not Null Average of negative SD
StdDevNegSD Numeric(30,6) Not Null Standard deviation of negative SD
AvgPosDS Numeric(30,6) Not Null Average of positive DS
StdDevPosDS Numeric(30,6) Not Null Standard deviation of positive DS
AvgNegDS Numeric(30,6) Not Null Average of negative DS
StdDevNegDS Numeric(30,6) Not Null Standard deviation of negative DS
PacketErrorPercent Numeric(30,6) Null Packet error percentage
OverThresholdPercent
Numeric(30,6) Null Over threshold percentage
StdDevRTT Numeric(30,6) Null Standard deviation of RTT
TotalPackets Integer Null Total packets
Table 66 Ethernet_Jitter_Monthly_Stats Table (continued)
Column Name Type Constraints Description
119Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Http_Minute_Stats Table
The HTTP Minute Statistics table is given in Table 67.
Table 67 Http_Minute_Stats Table
Column Name Type Constraints Description
rowID Numeric(10) IDENTITY,
primary key
Unique Identifier
CollectorID Bigint IDENTITY,
Primary Key
Collector (Running Instance) ID
Reference to collector(ID)
starttime Timestamp Not null Start time
RTT Integer Not null See MIB object:
rttMonLatestHTTPOperRTT
MIB type: Gauge (32 bit)
DNSRTT Integer Not null See MIB object:
rttMonLatestHTTPOperDNSRTT
MIB type: Gauge (32 bit)
TCPConnectRTT Integer Not null See MIB object:
rttMonLatestHTTPOperCPConnectRTT
MIB type: Gauge (32 bit)
TransactionRTT Integer Not null See MIB object:
rttMonLatestHTTPOperTransactionRTT
MIB type: Gauge (32 bit)
MessageBodyOctets Integer Not null See MIB object:
rttMonLatestHTTPOperMessageBodyOctets
MIB type: Gauge (32 bit)
120Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Http_Hourly_Stats Table
The HTTP Hourly Statistics table is given in Table 68.
Table 68 Http_Hourly_Stats Table
Column Name Type Constraints Description
rowID Numeric(10) IDENTITY,
primary key
Unique identifier
CollectorID Bigint IDENTITY,
Primary Key
Collector (Running Instance) ID
Reference to collector(ID)
starttime Timestamp Not Null Start time of the hourly bucket
MinRTT Integer Not Null See MIB object:
rttMonHTTPStatsRTTMin
MIB type: Gauge (32 bit)
MaxRTT Integer Not Null See MIB object:
rttMonHTTPStatsRTTMax
MIB type: Gauge (32 bit)
SumRTT Integer Not Null See MIB object:
rttMonHTTPStatsRTTSum
MIB type: Counter (32 bit)
SumOfSquaredRTT Double Not Null Sum of the square of all RTT.
See MIB object:
rttMonHTTPStatsRTTSum2Low, rttMonHTTPStatsRTTSum2High
DNSRTTSum Integer Not Null See MIB object:
rttMonHTTPStatsDNSRTTSum
MIB type: Counter (32 bit)
TCPConnectRTTSum Integer Not Null See MIB object:
rttMonHTTPStatsTCPConnectRTTSum
MIB type: Counter (32 bit)
TransactionRTTSum Integer Not Null See MIB object:
rttMonHTTPStatsTransactionRTTSum
MIB type: Counter (32 bit)
121Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
MessageBodyOctetsSum Integer Not Null See MIB object:
rttMonHTTPStatsMessageBodyOctetsSum
MIB type: Counter (32 bit)
DNSServerTimeouts Integer Not Null See MIB object:
rttMonHTTPStatsDNSServerTimeout
MIB type: Counter (32 bit)
TCPConnectTimeouts Integer Not Null See MIB object:
rttMonHTTPStatsTCPConnectTimeout
MIB type: Counter (32 bit)
TransactionTimeouts Integer Not Null See MIB object:
rttMonHTTPStatsTransactionTimeout
MIB type: Counter (32 bit)
DNSQueryErrors Integer Not Null See MIB object:
rttMonHTTPStatsDNSQueryError
MIB type: Counter (32 bit)
HttpErrors Integer Not Null See MIB object:
rttMonHTTPStatsHTTPError
MIB type: Counter (32 bit)
InternalErrors Integer Not Null See MIB object:
rttMonHTTPStatsError
MIB type: Counter (32 bit)
NumBusies Integer Not Null Number of busies.
See MIB object:
rttMonHTTPStatsBusies
MIB type: Counter (32 bit)
NumCompletions Integer Not Null Number of completions.
See MIB object:
rttMonHTTPStatsCompletions
MIB type: Counter (32 bit)
Table 68 Http_Hourly_Stats Table (continued)
Column Name Type Constraints Description
122Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Http_Daily_Stats Table
All the column values other than the Collector ID and Start Time are average values from the hourly table. Table 69.
NumOverThresholds Integer Not Null Number of overthresholds.
See MIB object:
rttMonHTTPStatsOverThresholds
MIB type: Counter (32 bit)
AvgRtt Numeric(30) Not Null Average of RTT
StdDevRTT Numeric(30) Null Standard deviation of RTT
NumTries Integer Not Null Number of tries
OverThresholdPercent Numeric(30) Null Over threshold percentage
Error_Percent Numeric(30) Not Null Error percentage
AvgDNSRTT Numeric(30) Not Null Average DNS RTT
AvgTCPConnectRTT Numeric(30) Not Null Average of TCP connect RTT
AvgTransactionRTT Numeric(30) Not Null Average of transaction RTT
AvgMessageBodyOctets Numeric(30) Not Null Average of messagebodyoctets
Table 68 Http_Hourly_Stats Table (continued)
Column Name Type Constraints Description
Table 69 Http_Daily_Stats Table
Column Name Type Constraints Description
CollectorID Bigint IDENTITY, Primary Key
Collector (Running Instance) ID.
Reference to collector(ID)
Start Time date Not Null Start time of the day
MinRTT Integer Not Null Average of all MinRTT.
MaxRTT Integer Not Null Average of all MaxRTT.
SumRTT Integer Not Null Sum of all RTT
SumOfSquaredRTT Double Not Null Sum of the square of all RTT
DNSRTTSum Integer Not Null Sum of DNSRTT
TCPConnectRTTSum Integer Not Null Sum of TCPConnectRTT
TransactionRTTSum Integer Not Null Sum of TransactionRTT
MessageBodyOctetsSum Integer Not Null Sum of MessageBodyOctets
DNSServerTimeouts Integer Not Null DNSServer Timeouts
TCPConnectTimeouts Integer Not Null TCPConnect Timeouts
TransactionTimeouts Integer Not Null Transaction Timeouts
123Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Http_Weekly_Stats Table
All the column values other than the collector ID and Start Time are average values from Daily table. See Table 70.
DNSQueryErrors Integer Not Null DNSQuery Errors
HttpErrors Integer Not Null Http Errors
InternalErrors Integer Not Null Internal Errors
NumBusies Integer Not Null Number of busies
NumCompletions Integer Not Null Number of completions.
NumOverThresholds Integer Not Null Number of over thresholds.
AvgRtt Numeric(30) Not Null Average of RTT
StdDevRTT Numeric(30 Null Standard deviation of RTT
NumTries Integer Not Null Number of tries
OverThresholdPercent Numeric(30) Null Overthreshold percentage
Error_Percent Numeric(30 Not Null Error percentage
AvgDNSRTT Numeric(30 Not Null Average DNS RTT
AvgTCPConnectRTT Numeric(30 Not Null Average of TCP connect RTT
AvgTransactionRTT Numeric(30 Not Null Average of transaction RTT
AvgMessageBodyOctets Numeric(30 Not Null Average of messagebodyoctets
Table 69 Http_Daily_Stats Table (continued)
Column Name Type Constraints Description
Table 70 Http_Weekly_Stats Table
Column Name Type Constraints Description
CollectorID Bigint IDENTITY,
Primary Key
Collector (Running Instance) ID.
Reference to collector(ID)
Start Time date Not Null Start time of the week
MinRTT Integer Not Null Average of all MinRTT
MaxRTT Integer Not Null Average of all MaxRTT
SumRTT Integer Not Null Sum of all RTT
SumOfSquaredRTT Double Not Null Sum of the square of all RTT
DNSRTTSum Integer Not Null Sum of DNSRTT
TCPConnectRTTSum Integer Not Null Sum of TCPConnectRTT
TransactionRTTSum Integer Not Null Sum of TransactionRTT
MessageBodyOctetsSum Integer Not Null Sum of MessageBodyOctets
124Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
DNSServerTimeouts Integer Not Null DNSServer Timeouts
TCPConnectTimeouts Integer Not Null TCPConnect Timeouts
TransactionTimeouts Integer Not Null Transaction Timeouts
DNSQueryErrors Integer Not Null DNSQuery Errors
HttpErrors Integer Not Null Http Errors
InternalErrors Integer Not Null Internal Errors
NumBusies Integer Not Null Number of busies
NumCompletions Integer Not Null Number of completions.
NumOverThresholds Integer Not Null Number of over thresholds.
AvgRtt Numeric(30) Not Null Average of RTT
StdDevRTT Integer Null Standard deviation of RTT
NumTries Integer Not Null Number of tries
OverThresholdPercent Numeric(30) Null Over threshold percentage
Error_Percent Integer Not Null Error percentage
AvgDNSRTT Integer Not Null Average DNS RTT
AvgTCPConnectRTT Integer Not Null Average of TCP connect RTT
AvgTransactionRTT Integer Not Null Average of transaction RTT
AvgMessageBodyOctets Integer Not Null Average of messagebodyoctets
Table 70 Http_Weekly_Stats Table (continued)
Column Name Type Constraints Description
125Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Http_Monthly_Stats Table
All the column values other than the collector ID and Start Time are average values from the weekly table. See Table 71.
Table 71 Http_Monthly_Stats Table
Column Name Type Constraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID
Reference to collector(ID)
Start Time date Not Null Start time of the month
RTTMin Integer Not Null Average of all MinRTT.
RTTMax Integer Not Null Average of all MaxRTT.
RTTSum Integer Not Null Sum of all RTT
SumOfSquaredRTT Double Not Null Sum of the square of all RTT
DNSRTTSum Integer Not Null Sum of DNSRTT
TCPConnectRTTSum Integer Not Null Sum of TCPConnectRTT
TransactionRTT
Sum
Integer Not Null Sum of TransactionRTT
MessageBodyOctetsSum Integer Not Null Sum of MessageBodyOctets
DNSServerTimeouts Integer Not Null DNSServer Timeouts
TCPConnectTimeouts Integer Not Null TCPConnect Timeouts
TransactionTimeouts Integer Not Null Transaction Timeouts
DNSQueryErrors Integer Not Null DNSQuery Errors
HttpErrors Integer Not Null Http Errors
InternalErrors Integer Not Null Internal Errors
NumBusies Integer Not Null Number of busies.
NumCompletions Integer Not Null Number of completions.
NumOverThresholds Integer Not Null Number of over thresholds.
AvgRtt Numeric(30) Not Null Average of RTT
StdDevRTT Numeric(30) Null Standard deviation of RTT
NumTries Integer Not Null Number of tries
OverThresholdPercent
Numeric(30) Null Overthreshold percentage
Error_Percent Numeric(30) Not Null Error percentage
AvgDNSRTT Numeric(30) Not Null Average DNS RTT
AvgTCPConnectRTT Numeric(30) Not Null Average of TCP connect RTT
AvgTransactionRTT Numeric(30) Not Null Average of transaction RTT
AvgMessageBodyOctets Numeric(30) Not Null Average of messagebodyoctets
126Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
PATHECHO_Hourly_Stats Table
The Pathecho Hourly Statistics table is given in Table 72.
Table 72 PATHECHO_Hourly_Stats Table
Column Name Type Constraints Description
RowID Bigint IDENTITY,
primary key
Unique Identifier
CollectorID Bigint Not Null Collector (Running Instance) ID
Reference to collector(ID)
PathID Integer Null Path ID.
Reference to
pathinfo(path ID)
HopID Integer Null Hop ID
HopAddress Varchar(255) Null Hop address
See MIB object:
rttMonStatsCollectAddress
StartTime Timestamp Not Null Start time for the hourly bucket
MinRTT Integer Not Null Minimum of RTT
See MIB object:
rttMonStatsCaptureCompletionTimeMin
MaxRTT Integer Not Null Maximum of RTT
See MIB object:
rttMonStatsCaptureCompletionTimeMax
SumRTT Integer Not Null Sum of all RTT
See MIB object:
rttMonStatsCaptureSumCompletionTime
SumSqrdRTT Integer Not Null Sum of the square of all RTT
See MIB object:
rttMonStatsCaptureSumCompletionTime2Low, rttMonStatsCaptureSumCompletionTime2High
NumCompletions Integer Not Null Number of completions.
See MIB object:
rttMonStatsCaptureCompletions
127Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
NumOverThresholds Integer Not Null Number of overthresholds.
See MIB object:
rttMonHTTPStatsOverThresholds
MIB type: Counter (32 bit)
NumDisconnects Integer Not Null Number of disconnects.
See MIB object:
rttMonStatsCollectNumDisconnects
NumTimeouts Integer Not Null Number of Timeouts
See MIB object:
rttMonStatsCollectTimeout
MIB type:
Integer32(0..2147483647)
NumBusies Integer Not Null Number of busies
See MIB object: rttMonStatsCollectBusies
NumNoConnections Integer Not Null Number of no connections
See MIB object:
rttMonStatsCollectNoConnections.
NumDrops Integer Not Null Number of drops.
See MIB object:
rttMonStatsCollectDrops
NumSeqErrors Integer Not Null Number of sequence errors.
See MIB object:
rttMonStatsCollectSequenceErrors
NumVerifyErrors Integer Not Null Number of verify errors
See MIB object:
rttMonStatsCollectVerifyErrors
NumTries Integer Not Null Number of tries
AvgRTT Numeric(30) Not Null Average of all RTT
StandardDeviation Numeric(30) Not Null Standard deviation
OverThres_Percent Numeric(30) Not Null Overthreshold percentage
Error_Percent Numeric(30) Not Null Error percentage
Availability_ Percent Numeric(30) Not Null Availability Percent
Table 72 PATHECHO_Hourly_Stats Table (continued)
Column Name Type Constraints Description
128Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
PATHECHO_Daily_Stats Table
All the column values other than the Collector ID and Start Time are average values from the hourly table. See Table 73.
Table 73 PATHECHO_Daily_Stats Table
Column Name Type Constraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID
Reference to collector(ID)
PathID Integer Not Null Path ID.
See Pathinfo (path ID)
HopID Integer Not Null Hop ID
HopAddress Varchar(255) Not Null Hop address
StartTime date Not Null Start time of the day
MinRTT Integer Not Null Average of all MinRTT
MaxRTT Integer Not Null Average of all MaxRTT
SumRTT Integer Not Null Sum of all RTT
SumSqrdRTT Integer Not Null Sum of the square of all RTT
NumCompletions Integer Not Null Number of completions.
NumOverThresholds Integer Not Null Number of overthresholds.
NumDisconnects Integer Not Null Number of disconnects.
NumTimeouts Integer Not Null Number of Timeouts
NumBusies Integer Not Null Number of busies.
NumNoConnections Integer Not Null Number of no connections.
NumDrops Integer Not Null Number of drops.
NumSeqErrors Integer Not Null Number of sequence errors
NumVerifyErrors Integer Not Null Number of verify errors
NumTries Integer Not Null Number of tries
AvgRTT Numeric(30) Not Null Average of all RTT
StandardDeviation Numeric(30) Not Null Standard deviation
OverThres_Percent Numeric(30) Not Null Overthreshold percentage
Error_Percent Numeric(30) Not Null Error percentage
Availability_Percent Numeric(30) Not Null Availability percentage
129Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
PATHECHO_Weekly_Stats Table
All the column values other than the collector ID and Start Time are average values from Daily table. See Table 74.
Table 74 PATHECHO_Weekly_Stats Table
Column Name Type Constraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID
See collector(ID)
PathID Integer Not Null Path ID.
See pathinfo(pathID)
HopID Integer Not Null Hop ID
HopAddress Varchar(255) Not Null Hop address
See MIBobject:
rttMonStatsCollectAddress
StartTime date Not Null Start time of the week
MinRTT Integer Not Null Average of all MinRTT.
MaxRTT Integer Not Null Average of all MaxRTT.
SumRTT Integer Not Null Sum of all RTT
SumSqrdRTT Integer Not Null Sum square of all RTT
NumCompletions Integer Not Null Number of completions.
NumOverThresholds Integer Not Null Number of overthresholds.
NumDisconnects Integer Not Null Number of disconnects.
NumTimeouts Integer Not Null Number of Timeouts
NumBusies Integer Not Null Number of busies
NumNoConnections Integer Not Null Number of no connections.
NumDrops Integer Not Null Number of drops
NumSeqErrors Integer Not Null Number of sequence errors.
NumVerifyErrors Integer Not Null Number of verify errors.
NumTries Integer Not Null Number of tries
AvgRTT Numeric(30) Not Null Average of all RTT
StandardDeviation Numeric(30) Not Null Standard deviation
OverThres_Percent Numeric(30) Not Null Overthreshold percentage
Error_Percent Numeric(30) Not Null Error percentage
Availability_Percent Numeric(30) Not Null Availability percentage
130Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
PATHECHO_Monthly_Stats Table
All the column values other than the collector ID and Start Time are average values from the weekly table. See Table 75.
Table 75 PATHECHO_Hourly_Stats Table
Column Name Type Constraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID
See collector(ID)
PathID Integer Not Null Path ID.
See pathinfo(path ID)
HopID Integer Not Null Hop ID
HopAddress Varchar(255) Not Null Hop address
StartTime date Not Null Start time of the month
MinRTT Integer Not Null Average of all MinRTT.
MaxRTT Integer Not Null Average of all MaxRTT.
SumRTT Integer Not Null Sum of all RTT
SumSqrdRTT Integer Not Null Sum of the square of all RTT
NumCompletions Integer Not Null Number of completions.
NumOverThresholds Integer Not Null Number of over thresholds.
NumDisconnects Integer Not Null Number of disconnects
NumTimeouts Integer Not Null Number of Timeouts
NumBusies Integer Not Null Number of busies
NumNoConnections Integer Not Null Number of no connections.
NumDrops Integer Not Null Number of drops.
NumSeqErrors Integer Not Null Number of sequence errors.
NumVerifyErrors Integer Not Null Number of verify errors.
NumTries Integer Not Null Number of tries
AvgRTT Numeric(30) Not Null Average of all RTT
StandardDeviation Numeric(30) Not Null Standard deviation
OverThres_Percent Numeric(30) Not Null Overthreshold percentage
Error_Percent Numeric(30) Not Null Error percentage
Availability_Percent Numeric(30) Not Null Availability Percent
131Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
RTP_Minute_Stats Table
The RTP Minute Statisics table is given in Table 76.
Table 76 RTP_Minute_Stats Table
Column Name Type Constraints Description
rowID Bigint Not Null Unique identifier
CollectorID Bigint Not Null Collector (Running Instance) ID.
See collector(ID)
starttime Timestamp Not Null Start time
RTT Integer Null See MIB object:
rttMonLatestRtpOperRTT
MIB type: Gauge (32 bit)
IAJitterDS Integer Null See MIB object:
rttMonLatestRtpOperIAJitterDS
MIB type: Gauge (32 bit)
IAJitterSD Integer Null See MIB object:
rttMonLatestRtpOperPacketLossSD
MIB type: Gauge (32 bit)
packetLossDS Integer Null See MIB object:
rttMonLatestRtpOperPacketLossDS
MIB type: Gauge (32 bit)
packetLossSD Integer Null See MIB object:
rttMonLatestRtpOperPacketLossSD
MIB type: Gauge (32 bit)
RFactorDS Integer Null See MIB object:
rttMonLatestRtpOperRFactorDS
MIB type: Gauge (32 bit)
RFactorSD Integer Null See MIB object:
rttMonLatestRtpOperRFactorSD
MIB type: Gauge (32 bit)
MOSCQDS Numeric(30) Null See MIB object:
rttMonLatestRtpOperMOSCQDS
MIB type: Gauge (32 bit)
MOSCQSD Numeric(30) Null See MIB object:
rttMonLatestRtpOperMOSCQSD
MIB type: Gauge (32 bit)
132Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
frameLossDS Integer Null See MIB object:
rttMonLatestRtpOperFrameLossDS
MIB type: Gauge (32 bit)
MOSLQDS Numeric(30) Null See MIB object:
rttMonLatestRtpOperMOSLQDS
MIB type: Gauge (32 bit)
MIA Integer Null See MIB object:
rttMonLatestRtpOperPacketsMIA
MIB type: Gauge (32 bit)
totalPacketsDS Integer Null See MIB object:
rttMonLatestRtpOperTotalPaksDS
MIB type: Gauge (32 bit)
totalPacketsSD Integer Null See MIB object:
rttMonLatestRtpOperTotalPaksSD
MIB type: Gauge (32 bit)
outOfSequenceDS Integer Null Out of sequence of DS
See MIB object:
rttMonLatestRtpOperPacketOOSDS
earlyPacketsDS Integer Null Early packets of DS
See MIB object:
rttMonLatestRtpOperPacketEarlyDS
latePacketsDS Integer Null See MIB object:
rttMonLatestRtpOperPacketLateDS
MIB type: Gauge (32 bit)
AvgOWSD numeric(30,6 Not Null See MIB object: rttMonLatestRtpOperAvgOWSD
MIB type: Gauge (32 bit)
MinOWSD integer Not Null See MIB object: rttMonLatestRtpOperMinOWSD
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonLatestRtpOperMaxOWSD
MIB type: Gauge (32 bit)
AvgOWDS numeric(30,6)
Not Null See MIB object: rttMonLatestRtpOperAvgOWDS
MIB type: Gauge (32 bit)
Table 76 RTP_Minute_Stats Table (continued)
Column Name Type Constraints Description
133Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
RTP_Hourly_Stats Table
The RTP Hourly Statistics table is given in Table 77.
MinOWDS integer Not Null See MIB object: rttMonLatestRtpOperMinOWDS
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonLatestRtpOperMaxOWDS
MIB type: Gauge (32 bit)
Table 76 RTP_Minute_Stats Table (continued)
Column Name Type Constraints Description
Table 77 RTP_Hourly_Stats Table
Column Name Type Constraints Description
rowID bigint Not Null Unique identifier
CollectorID bigint Not Null Collector (Running Instance) ID.
See to collector(ID)
starttime Timestamp Not Null Start time of the hourly bucket.
MinRTT Integer Null Minimum of RTT.
See MIB object:
rttMonStatsCaptureCompletionTimeMin
MIB type: Gauge (32bit)
MaxRTT Integer Null Maximum of RTT.
See MIB object: rttMonRtpStatsRTTMax
MIB type: Gauge (32 bit)
AvgRTT Numeric(30,6) Null See MIB object: rttMonRtpStatsRTTAvg
MIB type: Gauge (32 bit)
IAJitterDSMin Integer Null See MIB object:
rttMonRtpStatsIAJitterDSMin
MIB type: Gauge (32 bit)
IAJitterDSMax Integer Null See MIB object
rttMonRtpStatsIAJitterDSMax
MIB type: Gauge (32 bit)
134Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
IAJitterDSAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsIAJitterDSAvg
MIB type: Gauge (32 bit)
IAJitterSDMin Integer Null See MIB object:
rttMonRtpStatsIAJitterSDMin
MIB type: Gauge (32 bit)
IAJitterSDMax Integer Null See MIB object:
rttMonRtpStatsIAJitterSDMax
MIB type: Gauge (32 bit)
IAJitterSDAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsIAJitterSDAvg
MIB type: Gauge (32 bit)
packetLossDSMin Integer Null See MIB object:
rttMonRtpStatsPacketLossDSMin
MIB type: Gauge (32 bit)
packetLossDSMax Integer Null See MIB object:
rttMonRtpStatsPacketLossDSMax
MIB type: Gauge (32 bit)
packetLossDSAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsPacketLossDSAvg
MIB type: Gauge (32 bit)
packetLossSDMin Integer Null See MIB object:
rttMonRtpStatsPacketLossSDMin
MIB type: Gauge (32 bit)
packetLossSDMax Integer Null See MIB object:
rttMonRtpStatsPacketLossSDMax
MIB type: Gauge (32 bit)
packetLossSDAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsPacketLossSDAvg
MIB type: Gauge (32 bit)
RFactorDSMin Integer Null See MIB object:
rttMonRtpStatsRFactorDSMin
MIB type: Gauge (32 bit)
Table 77 RTP_Hourly_Stats Table (continued)
Column Name Type Constraints Description
135Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
RFactorDSMax Integer Null See MIB object:
rttMonRtpStatsRFactorDSMax
MIB type: Gauge (32 bit)
RFactorDSAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsRFactorDSAvg
MIB type: Gauge (32 bit)
RFactorSDMin Integer Null See MIB object: rttMonRtpStatsRFactorSDMin
MIB type: Gauge (32 bit)
RFactorSDMax Integer Null See MIB object:
rttMonRtpStatsRFactorSDMax
MIB type: Gauge (32 bit)
RFactorSDAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsRFactorSDAvg
MIB type: Gauge (32 bit)
MOSCQDSMin Integer Null See MIB object:
rttMonRtpStatsMOSCQDSMin
MIB type: Gauge (32 bit)
MOSCQDSMax Integer Null See MIB object:
rttMonRtpStatsMOSCQDSMax
MIB type: Gauge (32 bit)
MOSCQDSAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsMOSCQDSAvg
MIB type: Gauge (32 bit)
MOSCQSDMin Integer Null See MIB object:
rttMonRtpStatsMOSCQSDMin
MIB type: Gauge (32 bit)
MOSCQSDMax Integer Null See MIB object:
rttMonRtpStatsMOSCQSDMax
MIB type: Gauge (32 bit)
MOSCQSDAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsMOSCQSDAvg
MIB type: Gauge (32 bit)
frameLossDSMin Integer Null See MIB object:
rttMonRtpStatsFrameLossDSMin
MIB type: Gauge (32 bit)
Table 77 RTP_Hourly_Stats Table (continued)
Column Name Type Constraints Description
136Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
frameLossDSMax Integer Null See MIB object:
rttMonRtpStatsFrameLossDSMax
MIB type: Gauge (32 bit)
frameLossDSAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsFrameLossDSAvg
MIB type: Gauge (32 bit)
MOSLQDSMin Numeric(30,6) Null See MIB object:
rttMonRtpStatsMOSLQDSMin
MIB type: Gauge (32 bit)
MOSLQDSMax Numeric(30,6) Null See MIB object:
rttMonRtpStatsMOSLQDSMax
MIB type: Gauge (32 bit)
MOSLQDSAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsMOSLQDSAvg
MIB type: Gauge (32 bit)
miaAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsPacketsMIAAvg
MIB type: Gauge (32 bit)
totalPacketsDSMin Integer Null See MIB object:
rttMonRtpStatsTotalPacketsDSMin
MIB type: Gauge (32 bit)
totalPacketsDSMax Integer Null See MIB object:
rttMonRtpStatsTotalPacketsDSMax
MIB type: Gauge (32 bit)
totalPacketsDSAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsTotalPacketsDSAvg
MIB type: Gauge (32 bit)
totalPacketsSDMin Integer Null See MIB object:
rttMonRtpStatsTotalPacketsSDMin
MIB type: Gauge (32 bit)
totalPacketsSDMax Integer Null See MIB object:
rttMonRtpStatsTotalPacketsSDMax
MIB type: Gauge (32 bit)
Table 77 RTP_Hourly_Stats Table (continued)
Column Name Type Constraints Description
137Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
totalPacketsSDAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsTotalPacketsSDAvg
MIB type: Gauge (32 bit)
outOfSequenceDSAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsPacketOOSDSAvg
MIB type: Gauge (32 bit)
earlyPacketsDSAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsPacketEarlyDSAvg
MIB type: Gauge (32 bit)
latePacketsDSAvg Numeric(30,6) Null See MIB object:
rttMonRtpStatsPacketLateDSAvg
MIB type: Gauge (32 bit)
AvgOWSD numeric(30,6 Not Null See MIB object: rttMonRtpStatsOperAvgOWSD
MIB type: Gauge (32 bit)
MinOWSD integer Not Null See MIB object: rttMonRtpStatsOperMinOWSD
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonRtpStatsOperMaxOWSD
MIB type: Gauge (32 bit)
AvgOWDS numeric(30,6) Not Null See MIB object: rttMonRtpStatsOperAvgOWDS
MIB type: Gauge (32 bit)
MinOWDS integer Not Null See MIB object: rttMonRtpStatsOperMinOWDS
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonRtpStatsOperMaxOWDS
MIB type: Gauge (32 bit)
Table 77 RTP_Hourly_Stats Table (continued)
Column Name Type Constraints Description
138Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
RTP_Daily_Stats Table
All the column values other than the Collector ID and Start Time are average values from the hourly table. See Table 78
Table 78 RTP_Daily_Stats Table
Column Name Type Contraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID.
See collector(ID)
starttime Timestamp Not Null Start time of the day
MinRTT integer Not Null Average of all MinRTT.
MaxRTT integer Not Null Average of all MaxRTT.
AvgRTT numeric(30,6) Not Null Average of RTT
IAJitterDSMin integer Not Null Minimum of IAJitterDS
IAJitterDSMax integer Not Null Maximum of IAJitterDS
IAJitterDSAvg numeric(30,6) Not Null Average of IAJitterDS
IAJitterSDMin integer Not Null Minimum of IAJitterSD
IAJitterSDMax integer Not Null Maximum of IAJitterSD
IAJitterSDAvg numeric(30,6) Not Null Average of IAJitterSD
packetLossDSMin integer Not Null Minimum of packetLossDS
packetLossDSMax integer Not Null Maximum of packetLossDS
packetLossDSAvg numeric(30,6) Not Null Average of packetLossDS
packetLossSDMin integer Not Null Minimum of packetLossSD
packetLossSDMax integer Not Null Maximum of packetLossSD
packetLossSDAvg numeric(30,6) Not Null Average of packetLossSD
RFactorDSMin integer Not Null Minimum of RFactorDS
RFactorDSMax integer Not Null Maximum of RfactorDS
RFactorDSAvg numeric(30,6) Not Null Average of RfactorDS
RFactorSDMin integer Not Null Minimum of RFactorSD
RFactorSDMax integer Not Null Maximum of RfactorSD
RFactorSDAvg numeric(30,6) Not Null Average of RfactorSD
MOSCQDSMin numeric(30,6) Not Null Minimum of MOSCQDS
MOSCQDSMax numeric(30,6) Not Null Maximum of MOSCQDS
MOSCQDSAvg numeric(30,6) Not Null Average of MOSCQDS
MOSCQSDMin numeric(30,6) Not Null Minimum of MOSCQSD
MOSCQSDMax numeric(30,6) Not Null Maximum of MOSCQSD
MOSCQSDAvg numeric(30,6) Not Null Average of MOSCQSD
frameLossDSMin integer Not Null Minimum of frameLossDS
frameLossDSMax integer Not Null Maximum of frameLossDS
139Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
frameLossDSAvg numeric(30,6) Not Null Average of frameLossDS
MOSLQDSMin numeric(30,6) Not Null Minimum of MOSLQDS
MOSLQDSMax numeric(30,6) Not Null Maximum of MOSLQDS
MOSLQDSAvg numeric(30,6) Not Null Average of MOSLQDS
miaAvg numeric(30,6) Not Null Average of MIA
totalPacketsDSMin integer Not Null Minimum of totalPacketsDS
totalPacketsDSMax integer Not Null Maximum of totalPacketsDS
totalPacketsDSAvg numeric(30,6) Not Null Average of totalPacketsDS
totalPacketsSDMin integer Not Null Minimum of totalPacketsSD
totalPacketsSDMax integer Not Null Maximum of totalPacketsSD
totalPacketsSDAvg numeric(30,6) Not Null Average of totalPacketsSD
outOfSequenceDSAvg numeric(30,6) Not Null Average of outOfSequenceDS
earlyPacketsDSAvg numeric(30,6) Not Null Average of earlyPacketsDS
latePacketsDSAvg numeric(30,6) Not Null Average of latePacketsDS
AvgOWSD numeric(30,6 Not Null See MIB object: rttMonRtpStatsOperAvgOWSD
MIB type: Gauge (32 bit)
MinOWSD integer Not Null See MIB object: rttMonRtpStatsOperMinOWSD
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonRtpStatsOperMaxOWSD
MIB type: Gauge (32 bit)
AvgOWDS numeric(30,6) Not Null See MIB object: rttMonRtpStatsOperAvgOWDS
MIB type: Gauge (32 bit)
MinOWDS integer Not Null See MIB object: rttMonRtpStatsOperMinOWDS
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonRtpStatsOperMaxOWDS
MIB type: Gauge (32 bit)
Table 78 RTP_Daily_Stats Table (continued)
Column Name Type Contraints Description
140Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
RTP_Weekly _Stats Table
All the column values other than the collector ID and Start Time are average values from Daily table. See Table 79.
Table 79 RTP_Weekly _Stats Table
Column Name Type Contraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID
Reference to collector(ID)
starttime Timestamp Not Null Start time of the week
MinRTT double Not Null Average of all MinRTT.
MaxRTT double Not Null Average of all MaxRTT.
AvgRTT numeric(30,6) Not Null Average of RTT
IAJitterDSMin double Not Null Minimum of IAJitterDS
IAJitterDSMax double Not Null Maximum of IAJitterDS
IAJitterDSAvg numeric(30,6) Not Null Average of IAJitterDS
IAJitterSDMin double Not Null Minimum of IAJitterSD
IAJitterSDMax double Not Null Maximum of IAJitterSD
IAJitterSDAvg numeric(30,6) Not Null Average of IAJitterSD
packetLossDSMin double Not Null Minimum of packetLossDS
packetLossDSMax double Not Null Maximum of packetLossDS
packetLossDSAvg numeric(30,6) Not Null Average of packetLossDS
packetLossSDMin double Not Null Minimum of packetLossSD
packetLossSDMax double Not Null Maximum of packetLossSD
packetLossSDAvg numeric(30,6) Not Null Average of packetLossSD
RFactorDSMin double Not Null Minimum of RFactorDS
RFactorDSMax double Not Null Maximum of RfactorDS
RFactorDSAvg numeric(30,6) Not Null Average of RfactorDS
RFactorSDMin double Not Null Minimum of RFactorSD
RFactorSDMax double Not Null Maximum of RfactorSD
RFactorSDAvg numeric(30,6) Not Null Average of RfactorSD
MOSCQDSMin numeric(30,6) Not Null Minimum of MOSCQDS
MOSCQDSMax numeric(30,6) Not Null Maximum of MOSCQDS
MOSCQDSAvg numeric(30,6) Not Null Average of MOSCQDS
MOSCQSDMin numeric(30,6) Not Null Minimum of MOSCQSD
MOSCQSDMax numeric(30,6) Not Null Maximum of MOSCQSD
MOSCQSDAvg numeric(30,6) Not Null Average of MOSCQSD
frameLossDSMin double Not Null Minimum of frameLossDS
frameLossDSMax double Not Null Maximum of frameLossDS
141Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
frameLossDSAvg numeric(30,6) Not Null Average of frameLossDS
MOSLQDSMin numeric(30,6) Not Null Minimum of MOSLQDS
MOSLQDSMax numeric(30,6) Not Null Maximum of MOSLQDS
MOSLQDSAvg numeric(30,6) Not Null Average of MOSLQDS
miaAvg numeric(30,6) Not Null Average of MIA
totalPacketsDSMin double Not Null Minimum of totalPacketsDS
totalPacketsDSMax double Not Null Maximum of totalPacketsDS
totalPacketsDSAvg numeric(30,6) Not Null Average of totalPacketsDS
totalPacketsSDMin double Not Null Minimum of totalPacketsSD
totalPacketsSDMax double Not Null Maximum of totalPacketsSD
totalPacketsSDAvg numeric(30,6) Not Null Average of totalPacketsSD
outOfSequenceDSAvg numeric(30,6) Not Null Average of outOfSequenceDS
earlyPacketsDSAvg numeric(30,6) Not Null Average of earlyPacketsDS
latePacketsDSAvg numeric(30,6) Not Null Average of latePacketsDS
AvgOWSD numeric(30,6 Not Null See MIB object: rttMonRtpStatsOperAvgOWSD
MIB type: Gauge (32 bit)
MinOWSD integer Not Null See MIB object: rttMonRtpStatsOperMinOWSD
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonRtpStatsOperMaxOWSD
MIB type: Gauge (32 bit)
AvgOWDS numeric(30,6) Not Null See MIB object: rttMonRtpStatsOperAvgOWDS
MIB type: Gauge (32 bit)
MinOWDS integer Not Null See MIB object: rttMonRtpStatsOperMinOWDS
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonRtpStatsOperMaxOWDS
MIB type: Gauge (32 bit)
Table 79 RTP_Weekly _Stats Table (continued)
Column Name Type Contraints Description
142Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
RTP_Monthly_Stats Table
The RTP Monthly Statistics table is given in Table 80.
Table 80 RTP_Monthly_Stats Table
Column Name Type Constraints Description
CollectorID Bigint Not Null Collector (Running Instance) ID
See to collector(ID)
starttime Timestamp Not Null Start time of the month
MinRTT double Not Null Average of all MinRTT.
MaxRTT double Not Null Average of all MaxRTT.
AvgRTT numeric(30,6) Not Null Average of RTT
IAJitterDSMin double Not Null Minimum of IAJitterDS
IAJitterDSMax double Not Null Maximum of IAJitterDS
IAJitterDSAvg numeric(30,6) Not Null Average of IAJitterDS
IAJitterSDMin double Not Null Minimum of IAJitterSD
IAJitterSDMax double Not Null Maximum of IAJitterSD
IAJitterSDAvg numeric(30,6) Not Null Average of IAJitterSD
packetLossDSMin double Not Null Minimum of packetLossDS
packetLossDSMax double Not Null Maximum of packetLossDS
packetLossDSAvg numeric(30,6) Not Null Average of packetLossDS
packetLossSDMin double Not Null Minimum of packetLossSD
packetLossSDMax double Not Null Maximum of packetLossSD
packetLossSDAvg numeric(30,6) Not Null Average of packetLossSD
RFactorDSMin double Not Null Minimum of RFactorDS
RFactorDSMax double Not Null Maximum of RfactorDS
RFactorDSAvg numeric(30,6) Not Null Average of RfactorDS
RFactorSDMin double Not Null Minimum of RFactorSD
RFactorSDMax double Not Null Maximum of RfactorSD
RFactorSDAvg numeric(30,6) Not Null Average of RfactorSD
143Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
MOSCQDSMin numeric(30,6) Not Null Minimum of MOSCQDS
MOSCQDSMax numeric(30,6) Not Null Maximum of MOSCQDS
MOSCQDSAvg numeric(30,6) Not Null Average of MOSCQDS
MOSCQSDMin numeric(30,6) Not Null Minimum of MOSCQSD
MOSCQSDMax numeric(30,6) Not Null Maximum of MOSCQSD
MOSCQSDAvg numeric(30,6) Not Null Average of MOSCQSD
frameLossDSMin double Not Null Minimum of frameLossDS
frameLossDSMax double Not Null Maximum of frameLossDS
frameLossDSAvg numeric(30,6) Not Null Average of frameLossDS
MOSLQDSMin numeric(30,6) Not Null Minimum of MOSLQDS
MOSLQDSMax numeric(30,6) Not Null Maximum of MOSLQDS
MOSLQDSAvg numeric(30,6) Not Null Average of MOSLQDS
miaAvg numeric(30,6) Not Null Average of MIA
totalPacketsDSMin double Not Null Minimum of totalPacketsDS
totalPacketsDSMax numeric(30,6) Not Null Maximum of totalPacketsDS
totalPacketsDSAvg numeric(30,6) Not Null Average of totalPacketsDS
totalPacketsSDMin double Not Null Minimum of totalPacketsSD
totalPacketsSDMax double Not Null Maximum of totalPacketsSD
totalPacketsSDAvg numeric(30,6) Not Null Average of totalPacketsSD
outOfSequenceDSAvg numeric(30,6) Not Null Average of outOfSequenceDS
earlyPacketsDSAvg numeric(30,6) Not Null Average of earlyPacketsDS
latePacketsDSAvg numeric(30,6) Not Null Average of latePacketsDS
Table 80 RTP_Monthly_Stats Table (continued)
Column Name Type Constraints Description
144Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
video_oper Table
The Video Operation table is given in Table 81.
AvgOWSD numeric(30,6 Not Null See MIB object: rttMonRtpStatsOperAvgOWSD
MIB type: Gauge (32 bit)
MinOWSD integer Not Null See MIB object: rttMonRtpStatsOperMinOWSD
MIB type: Gauge (32 bit)
MaxOWSD integer Not Null See MIB object: rttMonRtpStatsOperMaxOWSD
MIB type: Gauge (32 bit)
AvgOWDS numeric(30,6) Not Null See MIB object: rttMonRtpStatsOperAvgOWDS
MIB type: Gauge (32 bit)
MinOWDS integer Not Null See MIB object: rttMonRtpStatsOperMinOWDS
MIB type: Gauge (32 bit)
MaxOWDS integer Not Null See MIB object: rttMonRtpStatsOperMaxOWDS
MIB type: Gauge (32 bit)
Table 80 RTP_Monthly_Stats Table (continued)
Column Name Type Constraints Description
Table 81 video_oper Table
Column Name Type Constraints Description
OperationID bigint PRIMARY Reference to operation(ID)
srcPort integer Not Null Source Port number
tgtPort integer Not Null Target Port number
145Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Video_Minute_Stats Table
The Video Minute Statistics table is given in Table 82.
callDuration integer Not Null Call duration in the range of 1 — 600 seconds. Default is 20 seconds.
profileName varchar(255) Not Null Name of the video profile denoting the type of Video traffic.
The profiles could be IPTV, IPVSC, and Telepresence.
Table 81 video_oper Table (continued)
Table 82 Video_Minute_Stats Table
Column Name Type Constraints Description
rowid bigint Not Null Unique identifier
starttime timestamp Not Null Start time of the collector
minofposisd integer Not Null Minimum of positive SD
maxofposisd integer Not Null Maximum of positive SD
AvgPosSD numeric(30,6) Not Null Average of positive SD
numofposisd integer Not Null Number of positive SD
sumofposisd integer Not Null Sum of positive SD
sum2posisd double Not Null Sum squared of positive SD
StdDevPosSD numeric(30,6) Not Null Standard deviation of positive SD
minofnegasd integer Not Null Minimum of negative SD
maxofnegasd integer Not Null Maximum of negative SD
AvgNegSD numeric(30,6) Not Null Average of negative SD
numofnegasd integer Not Null Number of negative SD
sumofnegasd integer Not Null Sum of negative SD
sum2negasd double Not Null Sum squared of negative SD
StdDevNegSD numeric(30,6) Not Null Standard deviation of negative SD
NumOfOWSD integer Not Null Number of one way SD
SumOWSD double Not Null Sum of one way SD
Sum2OWSD double Not Null Sum squared of one way SD
StddevOWSD numeric(30,6) Not Null Standard deviation of one way SD
AvgOWSD numeric(30,6) Not Null Average of positive one way SD
MinOWSD integer Not Null Minimum of one way SD
MaxOWSD integer Not Null Maximum of one way SD
numpacketlossSD integer Not Null Number of packet loss SD
PktOutSeq integer Not Null Number of packet out sequence
146Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Video_Hourly_Stats Table
The Video Hourly Statistics table is given in Table 83.
PktLateArrival integer Not Null Number of packet arrived late
UnSyncRTs integer Not Null Number of unsync round trips
AvgJitterSD integer Not Null Average Jitter SD
IAJOut integer Not Null Inter-arrival Jitter Out
IPDVAvgSDJ integer Not Null Source to Destination IPDV average jitter
VideoSense integer Not Null Application specific sense code for the completion status.
NTPState integer Not Null Value of sync(1) means sender and responder was in sync with NTP
ErrorSenseDescr varchar Not Null Sense description for the completion status of the latest video operation.
CollectorID bigint Not Null Collector (Running Instance) ID.
Table 82 Video_Minute_Stats Table (continued)
Table 83 Video_Hourly_Stats Table
Column Name Type Constraints Description
starttime timestamp Not Null Start time of the collector
numvideoCompletions integer Not Null Number of video completions
numOverThresholds integer Not Null Number of overthresholds
minofposisd integer Not Null Minimum of positive SD
maxofposisd integer Not Null Maximum of positive SD
AvgPosSD numeric(30,6) Not Null Average of positive SD
numofposisd integer Not Null Number of positive SD
sumofposisd integer Not Null Sum of positive SD
sum2posisd double Not Null Sum squared of positive SD
StdDevPosSD numeric(30,6) Not Null Standard deviation of positive SD
minofnegasd integer Not Null Minimum of negative SD
maxofnegasd integer Not Null Maximum of negative SD
AvgNegSD numeric(30,6) Not Null Average of negative SD
numofnegasd integer Not Null Number of negative SD
sumofnegasd integer Not Null Sum of negative SD
sum2negasd double Not Null Sum squared of negative SD
StdDevNegSD numeric(30,6) Not Null Standard deviation of negative SD
NumOfOW integer Not Null Number of one way SD
SumOWSD double Not Null Sum of one way SD
147Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Video_Daily_Stats Table
The Video Daily Statistics table is given in Table 84.
Sum2OWSD double Not Null Sum squared of one way SD
StddevOWSD numeric(30,6) Not Null Standard deviation of one way SD
AvgOWSD numeric(30,6) Not Null Average of positive one way SD
MinOWSD integer Not Null Minimum of one way SD
MaxOWSD integer Not Null Maximum of one way SD
numpacketlossSD integer Not Null Number of packet loss SD
PktOutSeq integer Not Null Number of packet out sequence
PktLateArrival integer Not Null Number of packet arrived late
PktSkipped integer Not Null Number of packet skipped
Errors integer Not Null Number of errors
Busies integer Not Null Number of busies
UnSyncRTs integer Not Null Number of unsync round trips
AvgJitterSD integer Not Null Average Jitter SD
IAJOut integer Not Null Inter-arrival Jitter Out
IAJIn integer Not Null Inter-arrival Jitter In
numTries integer Not Null Number of tries
Error_perc numeric(30,6) Not Null Error percentage
OverThreshold_perc numeric(30,6) Not Null Over threshold percentage
Completion_perc numeric(30,6) Not Null Completion percentage
Packet_Error_perc numeric(30,6) Not Null Packet error percentage
CollectorID bigint Not Null Collector (Running Instance) ID.
Table 83 Video_Hourly_Stats Table (continued)
Table 84 Video_Daily_Stats Table
Column Name Type Constraints Description
starttime timestamp Not Null Start time of the collector
numvideoCompletions integer Not Null Number of video completions
numOverThresholds integer Not Null Number of overthresholds
minofposisd integer Not Null Minimum of positive SD
maxofposisd integer Not Null Maximum of positive SD
AvgPosSD numeric(30,6) Not Null Average of positive SD
numofposisd integer Not Null Number of positive SD
sumofposisd integer Not Null Sum of positive SD
sum2posisd double Not Null Sum squared of positive SD
StdDevPosSD numeric(30,6) Not Null Standard deviation of positive SD
148Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
minofnegasd integer Not Null Minimum of negative SD
maxofnegasd integer Not Null Maximum of negative SD
AvgNegSD numeric(30,6) Not Null Average of negative SD
numofnegasd integer Not Null Number of negative SD
sumofnegasd integer Not Null Sum of negative SD
sum2negasd double Not Null Sum squared of negative SD
StdDevNegSD numeric(30,6) Not Null Standard deviation of negative SD
NumOfOW integer Not Null Number of one way SD
SumOWSD double Not Null Sum of one way SD
Sum2OWSD double Not Null Sum squared of one way SD
StddevOWSD numeric(30,6) Not Null Standard deviation of one way SD
AvgOWSD numeric(30,6) Not Null Average of positive one way SD
MinOWSD integer Not Null Minimum of one way SD
MaxOWSD integer Not Null Maximum of one way SD
numpacketlossSD integer Not Null Number of packet loss SD
PktOutSeq integer Not Null Number of packet out sequence
PktLateArrival integer Not Null Number of packet arrived late
PktSkipped integer Not Null Number of packet skipped
Errors integer Not Null Number of errors
Busies integer Not Null Number of busies
UnSyncRTs integer Not Null Number of unsync round trips
AvgJitterSD integer Not Null Average Jitter SD
IAJOut integer Not Null Inter-arrival Jitter Out
IAJIn integer Not Null Inter-arrival Jitter In
numTries integer Not Null Number of tries
Error_perc numeric(30,6) Not Null Error percentage
OverThreshold_perc numeric(30,6) Not Null Over threshold percentage
Completion_perc numeric(30,6) Not Null Completion percentage
Packet_Error_perc numeric(30,6) Not Null Packet error percentage
CollectorID bigint Not Null Collector (Running Instance) ID.
Table 84 Video_Daily_Stats Table (continued)
149Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Video_Weekly_Stats Table
The Video Weekly Statistics table is given in Table 85.
Table 85 Video_Weekly_Stats Table
Column Name Type Constraints Description
starttime timestamp Not Null Start time of the collector
numvideoCompletions integer Not Null Number of video completions
numOverThresholds integer Not Null Number of overthresholds
minofposisd integer Not Null Minimum of positive SD
maxofposisd integer Not Null Maximum of positive SD
AvgPosSD numeric(30,6) Not Null Average of positive SD
numofposisd integer Not Null Number of positive SD
sumofposisd integer Not Null Sum of positive SD
sum2posisd double Not Null Sum squared of positive SD
StdDevPosSD numeric(30,6) Not Null Standard deviation of positive SD
minofnegasd integer Not Null Minimum of negative SD
maxofnegasd integer Not Null Maximum of negative SD
AvgNegSD numeric(30,6) Not Null Average of negative SD
numofnegasd integer Not Null Number of negative SD
sumofnegasd integer Not Null Sum of negative SD
sum2negasd double Not Null Sum squared of negative SD
StdDevNegSD numeric(30,6) Not Null Standard deviation of negative SD
NumOfOW integer Not Null Number of one way SD
SumOWSD double Not Null Sum of one way SD
Sum2OWSD double Not Null Sum squared of one way SD
StddevOWSD numeric(30,6) Not Null Standard deviation of one way SD
AvgOWSD numeric(30,6) Not Null Average of positive one way SD
MinOWSD integer Not Null Minimum of one way SD
MaxOWSD integer Not Null Maximum of one way SD
numpacketlossSD integer Not Null Number of packet loss SD
PktOutSeq integer Not Null Number of packet out sequence
PktLateArrival integer Not Null Number of packet arrived late
PktSkipped integer Not Null Number of packet skipped
Errors integer Not Null Number of errors
Busies integer Not Null Number of busies
UnSyncRTs integer Not Null Number of unsync round trips
AvgJitterSD integer Not Null Average Jitter SD
IAJOut integer Not Null Inter-arrival Jitter Out
150Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
IPSLA Database Schema
Video_Monthly_Stats Table
The Video Monthly Statistics table is given in Table 86.
IAJIn integer Not Null Inter-arrival Jitter In
numTries integer Not Null Number of tries
Error_perc numeric(30,6) Not Null Error percentage
OverThreshold_perc numeric(30,6) Not Null Over threshold percentage
Completion_perc numeric(30,6) Not Null Completion percentage
Packet_Error_perc numeric(30,6) Not Null Packet error percentage
CollectorID bigint Not Null Collector (Running Instance) ID.
Table 85 Video_Weekly_Stats Table (continued)
Table 86 Video_Monthly_Stats Table
Column Name Type Constraints Description
starttime timestamp Not Null Start time of the collector
numvideoCompletions integer Not Null Number of video completions
numOverThresholds integer Not Null Number of overthresholds
minofposisd integer Not Null Minimum of positive SD
maxofposisd integer Not Null Maximum of positive SD
AvgPosSD numeric(30,6) Not Null Average of positive SD
numofposisd integer Not Null Number of positive SD
sumofposisd integer Not Null Sum of positive SD
sum2posisd double Not Null Sum squared of positive SD
StdDevPosSD numeric(30,6) Not Null Standard deviation of positive SD
minofnegasd integer Not Null Minimum of negative SD
maxofnegasd integer Not Null Maximum of negative SD
AvgNegSD numeric(30,6) Not Null Average of negative SD
numofnegasd integer Not Null Number of negative SD
sumofnegasd integer Not Null Sum of negative SD
sum2negasd double Not Null Sum squared of negative SD
StdDevNegSD numeric(30,6) Not Null Standard deviation of negative SD
NumOfOW integer Not Null Number of one way SD
SumOWSD double Not Null Sum of one way SD
Sum2OWSD double Not Null Sum squared of one way SD
StddevOWSD numeric(30,6) Not Null Standard deviation of one way SD
AvgOWSD numeric(30,6) Not Null Average of positive one way SD
MinOWSD integer Not Null Minimum of one way SD
MaxOWSD integer Not Null Maximum of one way SD
151Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Notices
NoticesThe following notices pertain to this software license:
• OpenSSL/Open SSL Project
OpenSSL/Open SSL ProjectThis product includes software developed by the OpenSSL Project for use in the OpenSSL Toolkit (http://www.openssl.org/).
This product includes cryptographic software written by Eric Young ([email protected]).
This product includes software written by Tim Hudson ([email protected]).
numpacketlossSD integer Not Null Number of packet loss SD
PktOutSeq integer Not Null Number of packet out sequence
PktLateArrival integer Not Null Number of packet arrived late
PktSkipped integer Not Null Number of packet skipped
Errors integer Not Null Number of errors
Busies integer Not Null Number of busies
UnSyncRTs integer Not Null Number of unsync round trips
AvgJitterSD integer Not Null Average Jitter SD
IAJOut integer Not Null Inter-arrival Jitter Out
IAJIn integer Not Null Inter-arrival Jitter In
numTries integer Not Null Number of tries
Error_perc numeric(30,6) Not Null Error percentage
OverThreshold_perc numeric(30,6) Not Null Over threshold percentage
Completion_perc numeric(30,6) Not Null Completion percentage
Packet_Error_perc numeric(30,6) Not Null Packet error percentage
CollectorID bigint Not Null Collector (Running Instance) ID.
Table 86 Video_Monthly_Stats Table (continued)
152Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Notices
License Issues
The OpenSSL toolkit stays under a dual license, i.e. both the conditions of the OpenSSL License and the original SSLeay license apply to the toolkit. See below for the actual license texts. Actually both licenses are BSD-style Open Source licenses. In case of any license issues related to OpenSSL please contact [email protected].
OpenSSL License:
Copyright © 1998-2007 The OpenSSL Project. All rights reserved.
Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
1. Redistributions of source code must retain the copyright notice, this list of conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions, and the following disclaimer in the documentation and/or other materials provided with the distribution.
3. All advertising materials mentioning features or use of this software must display the following acknowledgment: “This product includes software developed by the OpenSSL Project for use in the OpenSSL Toolkit (http://www.openssl.org/)”.
4. The names “OpenSSL Toolkit” and “OpenSSL Project” must not be used to endorse or promote products derived from this software without prior written permission. For written permission, please contact [email protected].
5. Products derived from this software may not be called “OpenSSL” nor may “OpenSSL” appear in their names without prior written permission of the OpenSSL Project.
6. Redistributions of any form whatsoever must retain the following acknowledgment:
“This product includes software developed by the OpenSSL Project for use in the OpenSSL Toolkit (http://www.openssl.org/)”.
THIS SOFTWARE IS PROVIDED BY THE OpenSSL PROJECT “AS IS”' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE OpenSSL PROJECT OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
This product includes cryptographic software written by Eric Young ([email protected]). This product includes software written by Tim Hudson ([email protected]).
153Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01
Notices
Original SSLeay License:
Copyright © 1995-1998 Eric Young ([email protected]). All rights reserved.
This package is an SSL implementation written by Eric Young ([email protected]).
The implementation was written so as to conform with Netscapes SSL.
This library is free for commercial and non-commercial use as long as the following conditions are adhered to. The following conditions apply to all code found in this distribution, be it the RC4, RSA, lhash, DES, etc., code; not just the SSL code. The SSL documentation included with this distribution is covered by the same copyright terms except that the holder is Tim Hudson ([email protected]).
Copyright remains Eric Young’s, and as such any Copyright notices in the code are not to be removed. If this package is used in a product, Eric Young should be given attribution as the author of the parts of the library used. This can be in the form of a textual message at program startup or in documentation (online or textual) provided with the package.
Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
1. Redistributions of source code must retain the copyright notice, this list of conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
3. All advertising materials mentioning features or use of this software must display the following acknowledgement:
“This product includes cryptographic software written by Eric Young ([email protected])”.
The word ‘cryptographic’ can be left out if the routines from the library being used are not cryptography-related.
4. If you include any Windows specific code (or a derivative thereof) from the apps directory (application code) you must include an acknowledgement: “This product includes software written by Tim Hudson ([email protected])”.
THIS SOFTWARE IS PROVIDED BY ERIC YOUNG “AS IS” AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
The license and distribution terms for any publicly available version or derivative of this code cannot be changed. i.e. this code cannot simply be copied and put under another distribution license [including the GNU Public License].
Cisco and the Cisco logo are trademarks or registered trademarks of Cisco and/or its affiliates in the U.S. and other countries. To view a list of Cisco trademarks, go to this URL: www.cisco.com/go/trademarks. Third-party trademarks mentioned are the property of their respective owners. The use of the word partner does not imply a partnership relationship between Cisco and any other company. (1110R)
Open Database Schema Support in Cisco Prime LAN Management Solution 4.2Copyright © 1998-2012, Cisco Systems, Inc. All rights reserved.
154Open Database Schema Support in Cisco Prime LAN Management Solution 4.2
OL-25951-01