VPSystems table

Last Updated : Jun 23, 2021 |
Prolog information
Metadata
Keywords:
Multiple Experience Portal systems store their reporting data in the same external database even though those systems are autonomous in all respects. Together these multiple Experience Portal systems are said to form the Experience Portal cluster. To ensure that the data from separate systems can be distinguished, each system is assigned a unique numeric identifier (the VPID) in addition to having a unique system name (the VPName).
This table has one row for each Experience Portal system in the Experience Portal cluster.
Note:
This data model differs slightly from the actual implementation. The model lists VPID as the primary key to illustrate the logical relationships between tables. In the actual implementation the primary key is VPName with VPID as an attribute.
Primary key columns
Name
VPID
Column
Data Type
Description
VPID
INTEGER
Identifies the EP system , within a cluster of multiple EP systems that merge the data into the same external database. If there is only one EP system at an installation, this field is always 1.
VPName
VARCHAR2(512)
The administered name of this Experience Portal system.
TimeZoneDrift
INTEGER
Offset in milliseconds of the Experience Portal system from GMT.
AdminURL
VARCHAR2(2048)
IP address of the Experience Portal system.
CreateDate
VARCHAR2(64)
Timestamp of the time the Experience Portal system was first added to the cluster.
LastUpdate
VARCHAR2(64)
Timestamp of the time that configuration data changed in the table.
LicensedTelephony
INTEGER
Total telephony licenses purchased for the Experience Portalsystems.
LicensedASR
INTEGER
Nonzero if ASR is licensed for the Experience Portal system.
LicensedTTS
INTEGER
Nonzero if TTS is licensed for the Experience Portal system.
CallCapacity
INTEGER
Total Telephony resources concurrently configured to take calls across all media servers for this EP system. The number can be less than the sum of the individual media server maximum port configuration represented by TotalCapacity column.
LicensesAllocated
INTEGER
Telephony resources assigned to MPPs.
TotalCapacity
INTEGER
Total of the maximum call capacity of all the MPPs in an EP system.
DatabaseFail
TIMESTAMP
Currently unused.
IncomingCalls
INTEGER
Number of currently active inbound calls.
OutgoingCalls
INTEGER
Number of currently active outbound calls made from Experience Portal system.
AlarmStatus
INTEGER
Current alarm status of the Experience Portal system:
  • 0 = none
  • 1 = Minor
  • 2 = Major
  • 3 = Critical
Corresponds to EPM Status Monitor Alarm icons :
  • 0 - green
  • 1 - yellow
  • 2 - red
StatusUpdate
VARCHAR2(64)
Timestamp of when the last status update occurred (Licensing and call info).
SystemType
INTEGER
Primary or secondary
RecordStatus
VARCHAR2(32)
Set to 'Active' if the Experience Portal system participates in the cluster.
Set to 'Inactive' if the Experience Portal system left the cluster.
Version
VARCHAR(32)
The version of the software that is currently running on the system.
Note:
The supplied scripts to create the reporting tables will use the appropriate data types for the selected database vendor.